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

Spencer Ogden

Site Safety Manager Job at Spencer Ogden

Job Description: Site Safety ManagerLocation: Cartersville, United StatesStart Date: 27 April 2026Pay Rate: $50 Per HourJob Description:The Site Safety Manager will be responsible for overseeing all aspects of safety on the construction site in Cartersville. This individual...

Dickson County Schools

Welcome Center Security Attendant-VES Job at Dickson County Schools

Job Description: Welcome Center Security Attendant Reports To: Principal Dept/School: Assigned Campus(es) Employment: 200 Day Contract, flexible hours Calendar: 10 months /200 days Salary Grade : Grade 28 (classified scale) Date Revised...

Pace Runners

Owner/Operator - Delivery Driver - Cargo/Sprinter Van Job at Pace Runners

Pace is seeking delivery drivers who are owner operators/independent contractors with their own Cargo/Sprinter van to make courier deliveries in our Shreveport, LA market. Join Pace's carrier network and grow your business with year-round, consistent, dedicated routes...

NYC Health + Hospitals/North Central Bronx

Psychiatrist - Nocturnist - CPEP (Part-Time) Job at NYC Health + Hospitals/North Central Bronx

...Physician Affiliate Group of New York (PAGNY) is adding a P art-Time Psychiatrist -Nocturnist - CPEP to the group at NYC Health + Hospitals/North Central Bronx . North Central Bronx Hospital (NCB) has 213 licensed beds. To this day, NCB remains a respected leader in...

Globe Life AIL - Lisa Russel

Online Desk Agent - Entry Level Job at Globe Life AIL - Lisa Russel

Entry Level CSR Benefits WFH Opportunity Location: 100% Remote Schedule: Flexible Ready to break free from rigid schedules and limited growth? This remote leadership opportunity is designed for individuals who want the freedom to lead, grow, and build a meaningful...

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

V1ZkbU5qMmxpMHJKQlBxOTZxV3BDUnVZWEE9PQ==