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

Clorox

Brand Management Intern (MBA - Summer 2027) Job at Clorox

...experience that runs from June through August. Interns are provided meaningful work assignments... ...As a member of a Brand Group, the Brand Management Intern has diverse responsibilities that... ...campaignsCoordinating package and product improvements that enhance the brand...

Confidential

Overnight Forklift Drivers / Electric Pallet Jack Drivers Job at Confidential

...Randstad is currently seeking experienced and safety-focused Forklift Operators to support operations on our 2nd shift at a well-known warehouse and distribution facility in your area. If you're skilled in multiple types of equipment and ready to work in a fast-paced, team-...

By the Sea Resorts

Housekeeping Manager Job at By the Sea Resorts

Description of the role:By the Sea Resorts is seeking a detail-oriented and experienced Housekeeping Manager to oversee all aspects of our housekeeping operations. The ideal candidate will ensure the cleanliness and orderliness of one resort property.Responsibilities...

vTech Solution

Lead ETL Developer Job at vTech Solution

Job Summary: The IA-DOM-DOIT-TS4 VISION ETL Lead is responsible for leading the design, development, and deployment of ETL pipelines... ...with business requirements while mentoring a team of ETL developers throughout the VISION CWIS FACS Conversion Initiative. Responsibilities...

Pepsico

Data Entry / Data Quality Specialist — Full-Time & Part-Time Remote Job at Pepsico

Job OverviewWe're looking for a reliable and detail-oriented Data Entry / Data Quality Specialist to help maintain accurate business records and support daily administrative operations.In this role, you'll enter, review, organize, and verify information across company...

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