Senior Data Modeler and Snowflake Developer

Job Title: Senior Snowflake Developer and Data Modeler

Location: Dallas, TX

Duration: 12 Monts Contract

Candidate beyond general Data and Snowflake expertise/experience, the candidate must:

1. Have expertise/experience with Data Vault, not just theoretical, but actual use. As data modeling is part of the role, previous experience is required and in the case of someone that would be unknown to us (vs Abhishek V.) the candidate should already have their Data Vault certification.
2. While it is beneficial for the candidate to have knowledge of different toolsets that integrate with Snowflake, it is a requirement that the candidate have expertise/experience using the native Snowflake tools.
3. Understanding the Azure toolsets would be a plus, but not a must.

Job Description:

Seeking a highly skilled Senior Snowflake Developer and Data modeler to join the Business Intelligence and Data Warehousing team. The ideal candidate will have extensive experience in Snowflake Cloud Data Platform, Data modeling, ETL processes, and SQL development. This role will be responsible for designing, modeling, developing, and optimizing Snowflake solutions to support data warehousing, reporting, and analytics initiatives.

Responsibilities:

• Design, model and develop scalable Snowflake data warehouses and optimize performance
• Implement data ingestion, transformation, and ETL pipelines using Snowflake, SQL, and Python
• Develop stored procedures, functions, and views to support business intelligence and reporting
• Optimize Snowflake performance by using best practices such as clustering, caching, and partitioning
• Integrate Snowflake with cloud platforms (AWS, Azure, Google Cloud Platform) and third-party tools
• Collaborate with data engineers, analysts, and business teams to define data solutions
• Ensure data security, access control, and compliance within Snowflake
• Collaborate with IT Security team to implement Business Continuity and Disaster Recovery process

Must-have Requirements:

• Atleast 5 years of experience working with Snowflake as a developer or data engineer
• Advanced knowledge in SQL, CDC, SnowSQL, Snow Pipes, Streams, Tasks, Stored procedures, Functions
• Proven track record of implementing Data Vault 2.0methodology in Snowflake along with developing conceptual, logical and physical data models and ERD's
• Hands-on Python development experience
• Should have knowledge of Real time or Near-real time streaming data using Kafka with Snowpipe
• Knowledge of Cloud platforms (AWS, Azure, or Google Cloud Platform) and data integration
• Experience with performance tuning, indexing, and query optimization in Snowflake
• Strong problem-solving skills and ability to work in agile environments

.

Preferred Requirements:

• Snowflake certifications (SnowPro Core, SnowPro Advanced)
• Experience with CI/CD pipelines and DevOps practices for Snowflake
• Knowledge of DBT is a plus
• Snowflake Admin experience is preferred

Vimal Charan

Phone: | Mob:

Email: