Snowflake Python ETL Engineer – Hybrid Boston

Ethereum Technologies LLC; Boston (MA); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Ethereum Technologies LLC in Boston, MA is seeking a Snowflake Python ETL Engineer to design and maintain scalable data pipelines, ingesting data into Snowflake Cloud. The role collaborates closely with data engineers, analysts, and business stakeholders to ensure reliable and secure data processing using Python-based ETL frameworks.

Responsibilities include building ETL/ELT pipelines, orchestrating workflows with Airflow/dbt, and implementing data quality checks, governance, and security

Qualifications

• Proficient in Snowflake data cloud and Python for ETL development.
• Strong SQL skills, especially in Snowflake.
• Experience with ETL/ELT tools and orchestration frameworks.
• Knowledge of cloud platforms (AWS/Azure/GCP) and data modeling.

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 databases, APIs, flat files, and cloud storage (S3, Azure Blob, GCS).
• Implement data validation, quality checks, and reconciliation processes.
• Optimize Snowflake performance with clustering, partitioning, caching, and sizing.
• Develop reusable Python modules for ETL automation.
• Orchestrate workflows with Airflow, Azure Data Factory, dbt, or Control-M.
• Implement CI/CD pipelines for data workflows across environments.
• Monitor ETL jobs, troubleshoot failures, and ensure SLA compliance.
• Ensure data security and governance with RBAC, masking policies, and encryption.
• Collaborate with analytics, BI, and data science teams for reporting.

Skills

Snowflake Data Cloud

Python ETL

SQL (Snowflake)

ETL/ELT tools

Cloud platforms (AWS/Azure/GCP)

Data modeling (star/snowflake)

CI/CD & DevOps

Data security & governance

Tools

Airflow

dbt

Control-M

Snowpark

Job description

Ethereum Technologies LLC in Boston, MA is seeking a Snowflake Python ETL Engineer to design and maintain scalable data pipelines, ingesting data into Snowflake Cloud. The role collaborates closely with data engineers, analysts, and business stakeholders to ensure reliable and secure data processing using Python-based ETL frameworks.

Responsibilities include building ETL/ELT pipelines, orchestrating workflows with Airflow/dbt, and implementing data quality checks, governance, and security