Lead Snowflake Data engineer
Diamondpick, Inc.
San Jose, CA, United States
4 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Working hours
Regular working hours
Job source
Tech stack
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
+18 more
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
Job 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
Requirements
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
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦