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

TGVuTFFIaGJwWTBTTXMyQTRJV3liaUlyRmc9PQ==
  • 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, 3 days per week

Similar Jobs

MMM LEGAL GROUP

Conflicts Attorney Job at MMM LEGAL GROUP

 ...Taft is looking for a highly motivated, team-oriented Conflicts Attorney to serve our Conflicts team.We are seeking a Conflicts Attorney to join our conflicts team. The ideal candidate will have 2+ years of experience working in a conflicts department in a mid - to large... 

Randstad

Prior Authorization Specialist Job at Randstad

 ...6PM CST If Luminare is closed for a holiday, everyone will work 10 hours the next day. Job Description Top skills needed: Prior Authorization Experience Healthcare Insurance Scripted Call center Experience strong customer service skills with the ability to work with... 

Healthsalaries

Pediatric Neurologist Job at Healthsalaries

 ...Medical School at The University of Texas at Austin is recruiting a second pediatric neuromuscular physician to join the Dell Childrens Pediatric Neuromuscular Disease Center and Pediatric Neurology faculty. We seek an individual with excellent clinical skills, a passion... 

Legacy Nursing And Rehabilitation

Business Office Manager Job at Legacy Nursing And Rehabilitation

 ...To: Administrator Summary The purpose of the Business Office Manager (BOM) position is to oversee the administrative offices...  ...fund balances for residents over $1800 Balance resident petty cash box daily. Replenish cash box as needed Balance resident trust... 

Pilgrim's

Sanitation Supervisor Job at Pilgrim's

 ...Determination, Discipline, Humility, Ownership, Simplicity, Sincerity EOE, including disability/vets Unsolicited Assistance: JBS and its companies do not accept unsolicited assistance from any recruitment vendors for any of our open jobs. All resumes or...