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

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

Autajon

Cost Accountant Analyst Job at Autajon

 ...millions euros. Authentic, sharing common values, we recruit individuals who are looking for a personal and collective adventure. Cost Accountant Analyst Are you looking for the opportunity and responsibility to make a difference? Look no further! Our Group is looking for... 

Confidential

Machine Operator Mechanic Job at Confidential

 ...Job Title: Machine Operator Mechanic Job Description We are seeking two skilled maintenance operators to join our dynamic team. One operator will specialize in operating the Vrock, while the other will focus on the Pipe Pro. The role involves operating concrete... 

TRITAL Care

Travel Registered Nurse Operating Room Job at TRITAL Care

 ...TRITAL Care is a premier healthcare staffing company committed to connecting talented nursing professionals with exceptional healthcare facilities nationwide. We provide comprehensive staffing solutions in various specialties including travel nursing, local and per diem... 

SGS Consulting

Regulatory Affairs Specialist II Job at SGS Consulting

 ...Job Responsibilities: Utilize the Regulatory Information Management System (RIMS) to manage data accuracy, integrity, and process efficiency; perform data analysis and manage submission/document and data uploads and verification; generate RIMS extracted reports to... 

DDB Solutions Inc.

Entry Level Sales Representative Job at DDB Solutions Inc.

 ...includes direct interaction with customers, product or service presentations, and structured performance tracking. No prior sales experience is required. Training is provided for candidates willing to learn and apply feedback. Core Duties Meet with potential...