Snowflake Technical Lead; SME level

Snowflake Technical Lead (SME level candidate)

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!

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.

• Lead end-to-end design and development of Snowflake data pipelines.
• Implement ingestion using Snowpipe, Streams, Tasks, external stages, Open Pipe.
• 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.

• 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.

• Experience with Airflow / dbt / Snowpark.
• Snowflake or cloud certifications.