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

Similar Jobs

Recover Medical Group

Certified Alcohol and Drug Counselor - Remote Job at Recover Medical Group

...About the company Recover is working to make addiction treatment and mental healthcare more effective, accessible, and affordable. We work with governments to use medicine to improve outcomes for people who need care. Our program is an outpatient and intensive outpatient...

Jobot

Urgent Care Nurse Practitioner / Physician Assistant Job at Jobot

...Salary: $130,000 - $180,000 per year A bit about us: We are the premier Urgent Care provider of Georgia. We are looking for a Nurse Practitioner (FNP) and/or Physician Assistant (PA-C) who thrives in a fast-paced setting. For more information contact: ***...

Cheer Home Care

Care Manager Physical Therapy Home Health Job at Cheer Home Care

...time with older adults? Do you want to work for a company that cares about you and listens? Do you want to Be the Reason Someone Smiles... ...reading and apply today! Cheer Home Care is hiring a PT Care Manager in San Diego. The PT Care Manager collaborates with...

Traveling with Mchaila

Work From Home Booking Administrative Planner Job at Traveling with Mchaila

...individuals to join our team as Work From Home Booking Administrative Planners. In this role,... ..., and vacation packages Organize and review booking details to ensure accuracy and... ...Communicate with clients via email and online platforms Assist with updates, changes...

Sittercity

Nanny / Babysitter in Louisville Job at Sittercity

...babysitting to part-time nannying and after-school help, Sittercity makes it easy for caregivers to find meaningful, flexible work... ...supporting families in their communities. Why Sittercity Flexible scheduling that fits your lifestyle and availability Consistent job...

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

ZDRKN3VSSHd2eTdOTjluZW1nWmxQWXJUUGc9PQ==