Snowflake Lead Developer

Looking for an experienced Snowflake Developer with strong expertise in advanced SQL and Data Modeling, capable of independently designing and developing logical, physical, and dimensional data models. The ideal candidate will be responsible for designing and developing scalable data models, building data pipelines, optimizing Snowflake performance, and enabling enterprise reporting and analytics.

Job Title: Snowflake Lead Developer
Location: Milpitas, CA , 100% Onsite
Duration: 6+ Months


Location Requirements

• 100% onsite role.
• Local candidates preferred.
• Candidates willing to relocate to Milpitas, CA, may also be submitted.

 
Job Description:

• We are seeking an experienced Snowflake Developer with strong expertise in SQL, Data Modeling, and Data Warehousing.
• The ideal candidate will be responsible for designing and developing scalable data models, building data pipelines, optimizing Snowflake performance, and enabling enterprise reporting and analytics.
• The candidate should have hands-on experience in creating logical, physical, and dimensional data models and translating business requirements into efficient data solutions.
• Looking for an experienced Snowflake Developer with strong expertise in advanced SQL and Data Modeling, capable of independently designing and developing logical, physical, and dimensional data models.
• Hands-on experience with Snowflake, DBT/ETL-ELT, and Python is required. Exposure to AI/GenAI capabilities such as Snowflake Cortex AI, RAG, embeddings, vector search, and AI-ready data pipelines is highly preferred.

Key Responsibilities:

• Design, develop, and maintain logical, physical, and dimensional data models in Snowflake.
• Build and optimize scalable data warehouse solutions to support enterprise reporting and analytics.
• Develop complex SQL queries, stored procedures, views, and data transformation logic.
• Create and maintain star schema, snowflake schema, and dimensional models.
• Collaborate with business stakeholders, data architects, and analytics teams to understand data requirements.
• Develop and support ETL/ELT pipelines for structured and semi-structured data.
• Perform data profiling, data quality validation, and source-to-target mapping.
• Optimize Snowflake performance through partitioning, clustering, query tuning, and warehouse sizing.
• Implement data governance, security, and best practices for data management.
• Support production issues, performance bottlenecks, and data reconciliation activities.
• Create technical documentation, including data dictionaries, mapping documents, and model designs.

Required Skills:

• Experience Required overall 8+ Years.
• 6+ years of overall Data Engineering/Data Warehousing experience.
• 7+ years of hands-on Snowflake experience.
• Strong expertise in advanced SQL.
• Strong Data Modeling experience.
• Hands-on experience with DBT and ETL/ELT.
• Hands-on Python experience.
• Experience independently designing logical, physical, and dimensional data models.

Preferred Skills:

• Exposure to AI/GenAI capabilities.
• Snowflake Cortex AI.
• RAG (Retrieval-Augmented Generation).
• Embeddings.
• Vector Search.
• AI-ready data pipelines.