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

Z2ZIQVhRaG9Jc0ZWSHVSN05HSlkyaDNpTVE9PQ==
  • 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

University Presbyterian Church

Church Business Administrator Job at University Presbyterian Church

Church Business Administrator Location Seattle, WA (University District area) : SUMMARY The UPC mission is: We are a family of communities joining Jesus to transform our lives and the lives of neighbors at the University of Washington, in our neighborhoods, and all around... 

NOLA PROTECTION

Security Officer (Unarmed) Meadowbrook Job at NOLA PROTECTION

 ...or emergency personnel. Maintain accurate written and electronic reports. Provide a professional and courteous presence at all times. Qualifications/Requirements: Must either be registered as a Security Officer with LSBPSE, or be able to meet requirements for... 

SWCA Environmental Consultants

Staff Restoration Ecologist Job at SWCA Environmental Consultants

 ...opportunity: SWCA Environmental Consultants is seeking a temporary, non-exempt, hourly Staff Restoration Ecologist to support an ecological restoration project in the Buffalo, New York area. This role will be part of our Ecological Restoration Group and will focus on... 

King Courier

Delivery Van Driver Job at King Courier

 ...Delivery Van Driver - San Francisco Are you looking for a fast-paced job where you can hit the road and make a difference? Do you...  ...Drive our cargo van Employee position (W-2), not an \Independent Contractor\ opportunity Over 30 years of industry experience, offering... 

DAVITA

Registered Nurse Job at DAVITA

 ...54467-2385, United States of America Registered Nurse Float - Stevens Point WI Start Fresh. No Dialysis Experience Needed. Learn a Specialty Skill. Make an Impact Every...  ...will vary depending on clinic/patient needs travel may be up to 2 hours away with travel pay and mileage...