Snowflake python ETL engineer

MACHINE LEARNING TECHNOLOGIES LLC; Boston (MA); Hybrid; USD 96,432 - 137,760; Full time

Job summary

MACHINE LEARNING TECHNOLOGIES LLC is seeking a Snowflake Python ETL Engineer responsible for designing and maintaining scalable data pipelines. This role will involve collaboration with data engineers, analysts, and stakeholders to ensure effective data processing.

The ideal candidate should possess strong experience with Snowflake and proficiency in Python for ETL development, along with robust SQL skills. The company offers a hybrid work model, combining onsite and remote work, across a long-term contract period.

Qualifications

• Strong experience with Snowflake Data Cloud.
• Proficient in Python for ETL development.
• Strong SQL skills, especially in Snowflake.

Responsibilities

• Design, develop, and optimize ETL/ELT pipelines using Python.
• Build and manage data transformations using Snowflake SQL.
• Ingest data from multiple sources such as databases and APIs.

Skills

Snowflake Data Cloud

Python (Pandas, PySpark, Snowpark)

SQL

ETL/ELT tools and orchestration frameworks

Cloud platforms (AWS, Azure, Google Cloud)

Data modeling, star/snowflake schemas

CI/CD, Git, and DevOps practices

Data security and governance

Job description

Job Overview

• Job ID: J52553
• Job Title: Snowflake Python ETL Engineer
• Location: Boston, MA (Hybrid 3 days onsite, 2 days remote per week)
• Duration: Long‑Term Contract (24 months + extension)
• Hourly Rate: Depends on Experience (DOE)
• Work Authorization: US Citizen, Green Card, OPT‑EAD, CPT, H‑1B, H4‑EAD, L2‑EAD, GC‑EAD
• Employment Type: W‑2, 1099, C2C

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.

Equal Opportunity Statement

MACHINE LEARNING TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. MACHINE LEARNING TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will MACHINE LEARNING TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.