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

Ellenco Estágios e Treinamentos

Boston (MA)

Hybrid

USD 110,000 - 160,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Ellenco Estágios e Treinamentos is seeking a Snowflake Python ETL Engineer in Boston, MA for a long-term contract. You design, develop, and maintain scalable data pipelines that load data into Snowflake, collaborating with data engineers, analysts, and business stakeholders.

You will implement Python-based ETL frameworks, optimize Snowflake performance, and orchestrate workflows with Airflow, dbt, or similar tools. Strong SQL and cloud platform experience are required.

Qualifications

Proven experience designing scalable data pipelines in Snowflake.
Strong Python-based ETL development experience with Pandas/PySpark/Snowpark.
Advanced SQL skills focused on Snowflake environments.
Familiarity with ETL/ELT orchestration tools and cloud platforms.
Knowledge of data modeling (star/snowflake) and data governance basics.

Responsibilities

Design, develop, and optimize ETL/ELT pipelines using Python for Snowflake ingestion and transformation.
Build and manage data transformations with Snowflake SQL, Python, and Snowpark.
Ingest data from databases, APIs, files, and cloud storage (S3, Azure, GCS).
Implement data validation, quality checks, and reconciliation processes.
Tune Snowflake performance via clustering, partitioning, and warehouse sizing.
Develop reusable Python modules and ETL automation frameworks.
Orchestrate workflows with Airflow, Azure Data Factory, dbt, or Control-M.
Implement CI/CD for data workflows and manage multi-environment deployments.
Monitor jobs, troubleshoot failures, and ensure SLA compliance.
Ensure data security and governance using RBAC, masking policies, and encryption.

Skills

Snowflake Data Cloud

Python ETL development

SQL (Snowflake)

ETL/ELT tools

Cloud platforms (AWS/Azure/GCP)

Data modeling (star/snowflake)

CI/CD, Git, DevOps

Data security, governance

Snowpark

Tools

Airflow

dbt

Control-M

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 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