Job Description

Job Details

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.

Key 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 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

Required 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 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

Job Tags

Long term contract, Remote work, 2 days per week, 3 days per week

Similar Jobs

Greenleap Solar

Graphic Designer/Photographer Job at Greenleap Solar

Requirements About the Role About The Company We are a family owned company that doesnt just focus on saving you money on your electric bill but provide the education and low pressure experience to own your power. We are proud to be a faith based company and we...

MultiplyMii

Amazon Graphic Designer Job at MultiplyMii

...love and make everyday routines better. About the Role Our client is seeking a talented and detail-oriented Amazon Graphic Designer to join their Amazon team supporting two brands on Amazon. In this role, youll be the creative engine behind their Amazon presence...

Culver's

Crew Member Job at Culver's

...options to choose from, so we appreciate when you take the time to visit Culvers. If we can do our part to make your day better with a wholesome, delicious... ...OWNED business and come grow your career with us! No experience required. At Culvers, the team member role is...

Gpac

Tax Associate Job at Gpac

A Top CPA firm in the area is looking to add a Tax Associate to their growing team. This stable and growing firm offers clients valuable knowledge and expertise in tax. Due to the recent growth of the firm, there is an opportunity for a Tax Associate to join a team of highly...

Domino's Franchise

Pizza Chef - 11102 W Colfax Ave Job at Domino's Franchise

...being able to show up for our communities by delivering hot fresh pizza right to their door! We strive to be #1 in every neighborhood... ...take pizzas during the hungry hours of the day and night. Pizza Chefs earn starting $15/hour + cash tips (paid daily!!!) Have...

Snowflake python ETL engineer Job at Cloud Analytics Technologies LLC, Boston, MA

Wk1PUTBnajRGMjI0aVU5Yi85elBaa0diQlE9PQ==