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

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

Confidential

Industrial Designer Job at Confidential

Industrial Designer Location: San Mateo, CA Full-time Hybrid (TuesThurs in studio, Mon/Fri optional WFH) Bould Design is growing. Were looking for an exceptional industrial designer to join our award-winning studio. Youll work closely with a small, experienced... 

Innovative Hematology, Inc.

Infusion Nurse (RN) Job at Innovative Hematology, Inc.

 ...The Infusion Nurse is responsible for the safe initiation, administration, monitoring, and discontinuation of infusion therapies. This role encompasses the provision of direct patient care, patient and family education, and ongoing evaluation of clinical outcomes. The... 

Brookdale Senior Living

Receptionist Collin Oaks Job at Brookdale Senior Living

Description Recognized by Newsweek in 2024 and 2025 as one of Americas Greatest Workplaces for Diversity Make Lives Better Including Your Own. If you want to work in an environment where you can become your best possible self join us! Youll earn more than a paycheck...

Summit Placement Service, Inc.

Physician Assistant Job at Summit Placement Service, Inc.

 ...Physician Assistant Internal Medicine Opportunity (Southern Washington State) We are seeking an experienced and compassionate Physician Assistant or Nurse Practitioner to join a well-established Internal Medicine practice in beautiful Southern Washington State.... 

FUJIFILM Biotechnologies

QA Engineer Job at FUJIFILM Biotechnologies

Position OverviewPosition Description Hours: 8:30am-5:00pm ESTWe are hiring a Quality Assurance Engineer. The Quality Assurance Engineer will be responsible for Lead Quality System improvements as well as drive resolution of deviations and product nonconformance. The role...