What are the responsibilities and job description for the Snowflake python ETL engineer position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Lorven Technologies, Inc., is seeking the following. Apply via Dice today!
Our client is looking for a Snowflake Python ETL Engineer at Boston, MA (Hybrid) It's a Long Term Contract opportunity.
Job Title: Snowflake Python ETL Engineer
Location: Boston, MA (Hybrid 3 days onsite 2 days remote per week
Duration: Long Term Contract
Job Description:
Job Summary:
Our client is looking for a Snowflake Python ETL Engineer at Boston, MA (Hybrid) It's a Long Term Contract opportunity.
Job Title: Snowflake Python ETL Engineer
Location: Boston, MA (Hybrid 3 days onsite 2 days remote per week
Duration: Long Term Contract
Job Description:
Job Summary:
- The Snowflake Python ETL Engineer is responsible for designing, developing, and maintaining scalable data pipelines that ingest, transform, and load data into Snowflake Data Cloud.
- This role involves working closely with data engineers, analysts, and business stakeholders to ensure reliable, performant, and secure data processing using Python-based ETL frameworks and cloud-native technologies.
- Design, develop, and optimize ETL/ELT pipelines using Python to load data into Snowflake
- Build and manage data transformations using Snowflake SQL, Python, and Snowpark
- Ingest data from multiple sources such as databases, APIs, flat files, and cloud storage (S3, Azure Blob, GCS)
- Implement data validation, data quality checks, and reconciliation processes
- Optimize Snowflake performance using clustering, partitioning, caching, and warehouse sizing
- Develop reusable Python modules and frameworks for ETL automation
- Orchestrate workflows using tools such as Airflow, Azure Data Factory, dbt, or Control-M
- Implement CI/CD pipelines for data workflows and manage deployments across environments
- Monitor ETL jobs, troubleshoot failures, and ensure SLA compliance
- Ensure data security and governance using RBAC, masking policies, and encryption
- Collaborate with analytics, BI, and data science teams to support reporting and advanced analytics
- Strong experience with Snowflake Data Cloud
- Proficient in Python for ETL development (Pandas, PySpark, Snowpark)
- Strong SQL skills, especially in Snowflake
- Experience with ETL/ELT tools and orchestration frameworks
- Knowledge of cloud platforms (AWS, Azure, or Google Cloud Platform)
- Experience with data modeling, star/snowflake schemas
- Familiarity with CI/CD, Git, and DevOps practices
- Understanding of data security, governance, and compliance