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

NmZpcGk1UGRtZ0V3VWNWSXZNRHBEQW5kRkE9PQ==
  • Cloud Analytics Technologies, LLC
  • Boston, MA

Job Description

Overview 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. 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 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. #J-18808-Ljbffr

Job Tags

Long term contract, Permanent employment, Contract work, Local area, Remote work, 2 days per week

Similar Jobs

dancker

Interior Designer I Job at dancker

 ...Position Title: Interior Designer I Location: Capitol Heights, MD Department: Client Services - Design Difference You'll Make We're looking...  ..., sample ordering, and specification documentation Maintain internal reporting tools and project records with accurate... 

Best Version Media

Multimedia Motion Designer Job at Best Version Media

Job Description Job Description Description: Overview: Best Version Media was founded in 2007 and now serves over 1,300 communities across the U.S. and Canada. We connect local businesses to customers with a suite of innovative print and digital solutions. Our...

Wellstar Health Systems, Inc.

PRN Radiation Therapist Job at Wellstar Health Systems, Inc.

 ...the healthcare industry, and in people's lives. Work Shift Day (United States of America) Job Summary: The Staff Radiation Therapist in the Radiation Oncology Department applies ionizing radiation to a diverse population of patients in accordance with the... 

AAA Academy

Special Ed Teacher with LSB1 Endorsement Job at AAA Academy

Join Our Team as a Special Education Teacher with LSB1 Endorsement! Are you dedicated to making a positive impact in the lives of students with special needs? Do you possess the necessary skills and commitment to deliver high-quality education to children requiring additional... 

Aveanna Healthcare

Home Health RN Clinical Management Specialist Travel Position Job at Aveanna Healthcare

 ...This is a hybrid position - remote and travel in territory that includes 8 locations in Alabama, 3 in Atlanta area and Hardeeville, SC. Position Overview The Clinical Management Specialist is a qualified professional responsible for collaboration with Home Health...