Snowflake Lead Developer

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.