What are the responsibilities and job description for the Onsite // Data Engineer (Snowflake, Python) position at Talent Groups?
Onsite
Data Engineer (Snowflake, Python)
Full time
Sunnyvale, CA
Job Description
We are seeking a highly skilled Data Engineer with strong hands-on experience in Snowflake, Python, and SQL to support data platform development, pipeline optimization, and large-scale data processing. This role requires deep technical expertise, strong problem-solving skills, and the ability to collaborate closely with data analytics, product, and engineering teams.
Key Responsibilities
- Design, build, and maintain scalable ETL/ELT pipelines using Python and Snowflake.
- Develop and optimize complex SQL queries for data transformation and analytics.
- Implement data ingestion frameworks, staging layers, and warehouse models in Snowflake.
- Ensure data quality, validation, and monitoring across pipelines and datasets.
- Work with cross-functional teams to gather requirements and deliver high-quality data solutions.
- Optimize Snowflake performance through clustering, partitioning, query tuning, and cost management.
- Automate workflows using Python scripts and orchestration tools (Airflow, ADF, etc. – optional depending on need).
- Support data governance, security, and compliance across all data assets.
Required Skills & Qualifications
- Strong proficiency in SQL (joins, window functions, performance tuning).
- Hands-on development experience with Snowflake (warehouse design, Snowflake SQL, Snowpipe, Streams/Tasks).
- Strong programming experience in Python (data processing, automation, APIs).
- Experience with ETL/ELT development and data modeling principles.
- Understanding of cloud data ecosystems (AWS, GCP, or Azure).
- Solid problem-solving, debugging, and performance optimization skills.
Preferred Qualifications
- Experience with orchestration tools (Airflow, Azure Data Factory, or similar).
- Familiarity with CI/CD workflows and DevOps practices.
- Experience working with BI tools (Tableau, Power BI, Looker).
- Background in analytics engineering or modern data stack environments.