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

ZDRKN3VSSHd2eTdOTjluZW1nWmxQWXJUUGc9PQ==
  • Cloud Analytics Technologies LLC
  • Boston, MA

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

Elite Sports Clubs

Summer Food & Beverage Intern Job at Elite Sports Clubs

 ...Spend your summer learning the ins and outs of food & beverage operations in a fast-paced, high-energy club environment. At Elite Sports Clubs, our Food & Beverage Intern will get hands-on experience across poolside service, events, and day-to-day operationsworking... 

AO Globe Life

✔ No Experience Needed | Work from Home |Remote Sales Representative Job at AO Globe Life

 ...Start Your Remote Career Today | No Experience Needed | Work From Home Location: 100% Remote Job Type: Full-Time / Part-Time Schedule: Flexible Hours Available Start Date: Hiring Immediately About the Opportunity Ready to begin a rewarding work-from... 

Optimal Dispatch Service LLC

Owner-Operator CDL-A Drivers (Dedicated & OTR Freight) Job at Optimal Dispatch Service LLC

 ...Logistics Level: Experienced Position Overview: Opportunities are available for CDL-A owner-operators seeking consistent freight options across dedicated and over-the-road lanes. The role emphasizes operational consistency while allowing contractors to maintain... 

MultiCare Health System

Ortho/neuro/Med-tele Day Shift RN Job at MultiCare Health System

 ...to join our incredible hospital-based team. This is an excellent opportunity to utilize your specialized training, knowledge, and nursing care with a multidisciplinary approach. Its an exciting time to be a nurse at MultiCare. We are on a journey to become a best-in... 

AAA Club Alliance

Senior Business Intelligence Specialist Job at AAA Club Alliance

 ...follows a hybrid schedule with on-site work Tuesday through Thursday in Wilmington DE...  ...Increase Eligibility ~ Hybrid or work-from-home schedule available ~ Health & Life...  ...automated reports and dashboards on roadside assistance trends including volume cost service performance...