Snowflake python ETL engineer
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
Recommended Jobs
Merchant Consultant - Bilingual in Chinese
Are you ready to go uP? We are named in Top Workplaces NYC for 2024 We are one of the winners of USPAACC’s Fast 100 Asian American Business awards We are recognized as one of the Top 5000 in …
Fixed Income Sovereign Research Analyst - MFS Investment Management
At MFS, you will find a culture that supports you in doing what you do best. Our employees work together to reach better outcomes, favoring the strongest idea over the strongest individual. We put pe…
Patient Transporter (40 Hours, Day)
At Boston Medical Center South, we are committed to improving the health of our communities by delivering exceptional, personalized health care with dignity, compassion and respect. Our continued focu…
HHA / PCA / Homemaker -Help The Elderly Near You
Do you want a job where you make a real difference every day? Guardian Angel Senior Services is hiring Caregivers / PCAs / HHAs to help seniors remain safe, independent, and comfortable in thei…
IT LAA Sr. Systems Admin Specialist
Responsibilities for this Position IT LAA Sr. Systems Admin Specialist ID: 2025-69563 USA-MA-Pittsfield Required Clearance: Secret, obtainable within reasonable time based on requirement…
HEAD CLERK
MASSHIRE CAREER CENTER CITY OF WORCESTER The City of Worcester is seeking qualified applicants for the position of Head Clerk for the MassHire Central Career Center. The Head Clerk will serve as…
HVAC Project Manager
We are a large growing mechanical contractor that works on many large mechanical hvac and plumbing projects. This is a full-time position with great benefits, retirement package, and plenty of room f…
Caregiver
Resident Care Associate (CNA, HHA) Cambridge, Massachusetts Neville Place’s caring and compassionate Resident Care team members provide direct care to our senior residents. Our associates appre…
First Grade Teacher in the Beautiful Berkshires- 2026-27
1st Grade Class Teacher Fall 2026 Berkshire Waldorf School is seeking a full time First Grade class teacher for the 2026-27 school year. Ideally, candidates would have Waldorf teaching experience. E…