Snowflake python ETL engineer

Cloud Analytics Technologies, LLC; Boston (MA); Hybride; USD 96 000 - 179 000; Plein temps

Résumé du poste

Cloud Analytics Technologies is seeking a Snowflake Python ETL Engineer in Boston for designing, developing, and maintaining scalable data pipelines into Snowflake Data Cloud. The role collaborates with data engineers, analysts, and stakeholders to ensure secure, performant processing using Python-based ETL frameworks and cloud-native tech.

The candidate will optimize Snowflake performance, orchestrate workflows, and implement CI/CD, RBAC, and data governance to support analytics and reporting

Qualifications

• Experience with Snowflake Data Cloud and Python-based ETL frameworks.
• Strong SQL skills, especially Snowflake SQL.
• Familiar with BI/analytics data pipelines and data governance.

Responsabilités

• 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 via clustering, partitioning, caching, and warehouse sizing.
• Develop reusable Python modules and frameworks for ETL automation.
• Orchestrate workflows with Airflow, Azure Data Factory, dbt, or Control-M.
• Implement CI/CD pipelines for data workflows and 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 for reporting.

Connaissances

Snowflake Data Cloud

Python ETL

Pandas

PySpark

Snowpark

Snowflake SQL

ETL/ELT tooling

Cloud platforms

CI/CD / DevOps

Data security governance

Outils

Airflow

Azure Data Factory

dbt

Control-M

S3

Azure Blob

GCS

Description du poste

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

CLOUD ANALYTICS TECHNOLOGIES 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. CLOUD ANALYTICS TECHNOLOGIES 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 CLOUD ANALYTICS TECHNOLOGIES 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

Equal Opportunity Employer

CLOUD ANALYTICS 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. CLOUD ANALYTICS 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 CLOUD ANALYTICS 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

Some of our Business Ventures - Knowledge Analytics

Do restrictive necessities, your capability for advanced analytics or your business model need custom-made applications and infrastructure configurations? opt for our hosted managed services to urge comprehensive analytics solutions supported industry-leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you: