Senior Snowflake Developer and Data Modeler

Job Title: Senior Snowflake Developer and Data Modeler

Location: Dallas, TX

Duration: 12 Months Contract

Note:

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

Have expertise/experience with Data Vault, not just theoretical, but actual use. As data modeling is part of the role, the candidate should already have their Data Vault certification.

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.

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, GCP) 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.0 methodology 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 GCP) 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: