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

Foxcom Inc

Production Assistant, Media Desk Job at Foxcom Inc

...Owned by FOX Corporation, FOX News Media reaches 200 million people each month.JOB DESCRIPTIONWe are looking for a talented Production Assistant to join our Media Desk. The Production Assistant will be a self-starter with stellar communication skills. The Production...

Domino's Franchise

Delivery Driver(02993) - 380 W. Galena Blvd. Job at Domino's Franchise

...Job Description Job Description Job Description OUR DRIVERS MAKE MORE THAN UBER AND LYFT DRIVERS Delivery Driver Job Description This is for our 380 W. Galena Blvd Aurora, IL 60506 location The stores phone number is (***) ***-**** Want daily cash in...

Sinai Akiba Academy

Elementary School (K-5) Teaching Assistant Job at Sinai Akiba Academy

...committed, and creative individuals for opportunities as Teaching Assistants in our Lower School (kindergarten through 5th grade). TAs work alongside an... ...development. Sinai Akiba Academy is a preeminent private Jewish day school in Los Angeles, serving students in Early...

Staffmark

Japanese Bilingual Accounting Associat Job at Staffmark

Position Title: Japanese Bilingual Accounting AssociateLocation: Carson, CAClassification: Full-Time / Non-ExemptSummaryThis position is with aprofessional organization dedicated to financial integrity and operationalexcellence. The Accounting Specialist plays a vital...

MCCARTHY POOLS CORP.

Swimming Pool Service Technician Job at MCCARTHY POOLS CORP.

...1(k) Competitive salary Health insurance Opportunity for advancement Paid time off McCarthy Pools Corporation is looking to add experienced swimming pool service technicians to its staff. A successful candidate should have experience in the following areas...

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

TGVuTFFIaGJwWTBTTXMyQTRJV3liaUlyRmc9PQ==