Hybrid Snowflake Python ETL Engineer - Data Cloud Pipelines

Quantum Technologies. LLC; Boston (MA); Hybrid; USD 100,000 - 130,000; Full time

Job summary

A leading technology company in Boston is seeking a Snowflake Python ETL Engineer to design and maintain scalable data pipelines using Python. Collaborate with data engineers and business stakeholders, ensuring reliable data processing and performance optimization. Candidates should have strong experience in Snowflake Data Cloud and proficiency in Python. This is a long-term hybrid position requiring effective communication and collaboration skills.

Qualifications

• 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 GCP).
• Experience with data modeling, star/snowflake schemas.
• Familiarity with CI/CD, Git, and DevOps practices.
• Understanding of data security, governance, and compliance.

Responsibilities

• 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 including databases, APIs, and cloud storage.
• Implement data validation, quality checks, and reconciliation processes.
• Optimize Snowflake performance using clustering, partitioning, and caching.
• Develop reusable Python modules and frameworks for ETL automation.
• Orchestrate workflows using Airflow, Azure Data Factory, or dbt.
• Implement CI/CD pipelines for data workflows.
• Monitor ETL jobs, troubleshoot failures, and ensure SLA compliance.
• Ensure data security and governance using RBAC and encryption.

Skills

Snowflake Data Cloud

Python for ETL development

SQL

ETL/ELT tools

Cloud platforms (AWS, Azure, GCP)

Data modeling

CI/CD and DevOps practices

Data security and governance

Job description

A leading technology company in Boston is seeking a Snowflake Python ETL Engineer to design and maintain scalable data pipelines using Python. Collaborate with data engineers and business stakeholders, ensuring reliable data processing and performance optimization. Candidates should have strong experience in Snowflake Data Cloud and proficiency in Python. This is a long-term hybrid position requiring effective communication and collaboration skills.