> Markdown version of [/jobs/ext/4589371-lead-snowflake-data-engineer](https://www.wearedevelopers.com/jobs/ext/4589371-lead-snowflake-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead Snowflake Data engineer

- **Company:** Diamondpick, Inc.
- **Location:** San Jose, CA, United States
- **Experience:** Expert
- **Contract:** Contract
- **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, Airflow, Amazon Web Services, Business Logic, ARM Architecture, Microsoft Azure, Data Architecture, Data Transformation, Data Security, Data Systems, Data Warehousing, Dimensional Modeling, Python (Programming Language), Performance Tuning, Query Optimization, Software Engineering, SQL Stored Procedures, SQL Databases, Systems Integration, Google Cloud, Enterprise Software Applications, Retrieval-Augmented Generation, Large Language Models, Snowflake, Generative AI, Data Analytics, Semantic Modeling, Streamlit Framework, Data Pipelines
- **Published:** November 5, 2026
- **Apply:** https://www.dice.com/job-detail/4226b3d3-5901-4ae0-b2f6-b30e9840ada0

## About the Role

We are seeking a highly skilled handson Lead Snowflake Developer Snowflake AI Specialist with deep expertise in Snowflake architecture advanced SQL development semantic modeling and Snowflake Cortex AI capabilities
The ideal candidate should have strong technical expertise and the ability to independently design develop and implement scalable enterprisegrade Snowflake solutions including semantic layers and AIdriven analytics applications, * Strong handson experience in Snowflake development and architecture

 * Expertlevel SQL programming query optimization and performance tuning
 * Handson experience developing Snowflake Semantic Views Semantic Models
 * Practical experience with Snowflake Cortex Analyst andor Cortex Agents
 * Strong understanding of data warehousing dimensional modeling and enterprise data architecture
 * Proficiency in Python and Snowpark
 * Experience integrating Snowflake with enterprise data sources and applications
 * Strong problemsolving skills and ability to work independently on complex technical challenges

Good to Have Skills

 * Snowflake Cortex Search Cortex AI Functions and RAG implementations
 * Streamlit application development
 * Experience with LLMs Generative AI and naturallanguagetoSQL solutions
 * Experience with dbt Airflow or other data orchestration tools
 * Experience with cloud platforms such as AWS Azure or Google Cloud Platform
 * Snowflake certifications

## Description

* Design develop and optimize complex Snowflake data solutions including SQL queries stored procedures data pipelines and data transformations
 * Build and maintain Snowflake Semantic Views Semantic Models defining business metrics dimensions relationships and reusable business logic
 * Develop and integrate Snowflake Cortex Analyst and Cortex Agents to enable naturallanguage querying and AIpowered data analytics
 * Design and implement enterprise data models including dimensional modeling star schemas and analytical data structures
 * Develop AIdriven use cases leveraging Snowflake Cortex capabilities including Cortex Search and RetrievalAugmented Generation RAG where applicable
 * Integrate Snowflake AI capabilities with enterprise applications using Python APIs Snowpark and Streamlit
 * Optimize Snowflake performance scalability query execution and cost efficiency
 * Implement data security rolebased access controls governance and best practices
 * Collaborate with business stakeholders data architects and AI engineering teams to translate business requirements into technical solutions
 * Provide technical leadership troubleshoot complex issues and independently drive endtoend solution delivery