Dice is the leading career destination for tech experts at every stage of their careers. Our client, Avtech Solutions, is seeking the following. Apply via Dice today!
Job Title : Snowflake Technical Lead
Location : Cupertino, CA (Onsite / Hybrid (3 days onsite))
Job Type: Contract
Note: Need candidates local to California or PST zone
Looking for a Snowflake Subject Matter Expert (SME) with strong Python hands-on skills to lead end-to-end Snowflake development-including ingestion, pipelines, automation, and optimization. Candidate must have deep Snowflake platform knowledge beyond SQL or basic ETL.
Key Responsibilities
• Lead end-to-end design and development of Snowflake data pipelines.
• Implement ingestion using Snowpipe, Streams, Tasks, external stages, OpenPipe.
• Build automation and processing scripts using Python.
• Optimize Snowflake performance, cost, and security.
• Support CI/CD, orchestration, and integration with cloud platforms.
• Provide Snowflake SME guidance to the engineering team.
Required Skills
• Strong, hands-on Snowflake architecture and pipeline development.
• Expertise in Python for automation, ingestion, and data processing.
• Experience with Snowpipe, Streams, Tasks, stages, and end-to-end ingestion frameworks.
• Strong SQL, cloud platform experience (AWS/Azure/Google Cloud Platform), and CI/CD exposure.
Preferred Skills
• Experience with Airflow / dbt / Snowpark.
• Snowflake or cloud certifications.
