Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Snowflake python ETL engineer

Cloud Analytics Technologies LLC

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

Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Snowflake python ETL engineer in Boston, MA vacancy
  • Job Title: Azure Snowflake Data Engineer Location: Boston, MA - HYBDID (4x per week Onsite) Duration:...  ...Services and Snowflake . Develop scalable ELT/ETL frameworks and manage large datasets...  ...and optimization. Experience with Python for scripting and automation. Solid understanding... 
    Suggested
    Contract work

    AceStack LLC

    West Roxbury, MA
    3 days ago
  •  ...client in need of a Senior Data Quality & Snowflake Migration Engineer in Boston, MA. Responsibilities:...  ...lifecycle * Build and support ETL/ELT processes for data cleansing, transformation...  ..., and quality checks using SQL and Python * Develop reporting and monitoring... 
    Suggested
    Hourly pay
    Contract work

    Kforce Technology Staffing

    Boston, MA
    2 days ago
  • Title: Snowflake Data Engineer Location: Boston, MA In-person: 2 Days per week in-person is MUST Duration...  ...warehouses, including data modeling, ETL processes, and data quality control. o...  ..., reliable, and efficient. o Write Python code to automate data processing, transformation... 
    Suggested
    2 days per week

    Equiliem

    Boston, MA
    3 days ago
  •  ...We are seeking an experienced Snowflake Developer with 7–12 years of experience in data engineering, data warehousing, and cloud data platforms. The ideal candidate will...  ...strong hands-on expertise in Snowflake, SQL, ETL/ELT, data modeling, and cloud-based data solutions... 
    Suggested
    Temporary work

    PB consulting

    Boston, MA
    a month ago
  • Data Engineer - Databricks & Snowflake Location: Quincy, MA (Onsite) Duration: W2 / C2C Contract Experience: 8+ Years Job Description Senior/Lead developer...  ...should have strong experience in the Data warehousing (ETL Concepts, Types of SCD). Candidate should have very good... 
    Suggested
    Contract work

    Syntricate Technologies

    Quincy, MA
    3 days ago
  • Kforce has a client in need of a Snowflake Data Consultant in Boston, MA. Responsibilities...  ...* 7+ years of experience in Data Engineering, Data Warehousing, or ETL/ELT development * 4+ years of hands...  ...data solutions * Proficiency with Python or other modern programming... 
    Temporary work
    Boston, MA
    12 days ago
  • $100k - $167.5k

     ...forFront-Office Software Development Trading Engineers for Charles River Investment Management...  ..., Charles River web services API, ETL tool usage, Java and/or C# programming, and...  ...using ETL toolsExperience with Azure and Snowflake Education & Preferred Qualifications:A BA... 
    Full time
    Temporary work
    Work at office
    Remote work
    Flexible hours

    State Street Bank

    Boston, MA
    10 hours ago
  • Overview Python and Kubernetes Software Engineer - Data, AI/ML & Analytics Join to apply for the Python and Kubernetes Software Engineer - Data, AI/ML...  ...MLFlow, DVC, and Feast. You may also work on workflow, ETL, data governance and visualization tools like Apache SuperSet... 
    Local area
    Work from home

    Canonical

    Boston, MA
    2 days ago
  •  ...an exciting job opportunity with one of our clients.Position: Snowflake Data EngineerContract: WRequirements:Candidates must have experience...  ...pipelines, snowpipes already set up (might need to modify, so Python Snowpipe experience needed).Need someone with Snowflake... 
    Remote work

    Software Technology Inc

    Boston, MA
    11 hours ago
  •  ...a Junior to Midlevel Software Engineer who is eager to learn, grow, and...  ...platform. You will support ETL and AI generated pipelines, implement...  ...platform. • Support Python-based data workflows and contribute...  ...such as AWS Redshift, Snowflake, or BigQuery—even through academic... 
    Full time
    Visa sponsorship

    Nexus It Group

    Boston, MA
    a month ago
  •  ...Kforce has a client in need of a Snowflake Data Consultant in Boston, MA. Responsibilities...  ...* 7+ years of experience in Data Engineering, Data Warehousing, or ETL/ELT development * 4+ years of...  ...solutions * Proficiency with Python or other modern programming... 
    Hourly pay
    Contract work

    Kforce Technology Staffing

    Boston, MA
    2 days ago
  •  ...Creating SQL stored procedures Creating dashboards with python Extracting and Loading Data using API's Building ETL processes Must Haves: 10-15 years of SQL...  ...tasks simultaneously Good to Have: Experience with Snowflake Experience using PowerShell scripts (2+ years) RIT... 
    Remote work
    Relocation

    RIT Solutions, Inc.

    Boston, MA
    5 days ago
  • We are seeking an experienced Snowflake Data Engineer with strong expertise in Snowflake, Python, SQL, Snowpark, and ELT pipeline development. The ideal candidate will have a strong background in data engineering, data warehousing, data modeling, and enterprise cloud data... 

    Veriipro

    Boston, MA
    2 days ago
  • Senior Data Engineer Analytics & Behavior Change is an innovation engine supporting the entire...  ..., Google Healthcare API, SQL, Teradata, Snowflake) Contribute to the enterprise feature...  ...(FHIR store) 2 years of experience in Python Hands on experience with RDBMS (Teradata... 
    Remote job
    Local area

    Phenom People

    Wellesley, MA
    3 days ago
  • AI/ML Engineer Opportunity We've partnered with a well-funded, fast-growing...  .... Strong coding skills in Python and experience using Git/...  ...practices. Comfort working with ETL pipelines, relational and non-...  ...databases, and data platforms like Snowflake or Databricks. Familiarity... 
    Remote work
    3 days per week

    DRH Search

    Cambridge, MA
    3 days ago
  • Data Engineer with Databricks & Azure Quincy, MA onsite Contract. Role...  ...on Azure/AWS using Databricks/Snowflake and maintaining cloud-based...  ...Proficient in Oracle RDBMS and Python/Java/SQL coding . • Experience...  ...setting up data pipelines for ETL jobs across multiple data sources... 
    Contract work
    Immediate start

    Syntricate Technologies

    Quincy, MA
    3 days ago
  • $90k - $210k

     ...technology. MORSE boasts a specially selected team of scientists, engineers, and software developers to deliver best-in-class technical...  ...Ecosystem.    MORSE is seeking highly motivated and talented Python Software Engineers to join our innovative team, supporting various... 
    Full time

    Morse Corp

    Cambridge, MA
    more than 2 months ago
  • $77k - $202k

    The Opportunity As a GenAI Python Systems Engineer - Senior Associate, you will play a pivotal role in transforming raw data into actionable...  ...including AWS, Google Cloud, Microsoft Azure, Databricks, Snowflake, or related data and AI credentials Utilizing Python programming... 
    H1b

    PwC

    Boston, MA
    3 days ago
  •  ...(must be local to one of these areas) - Minimum 7+ years of experience in Data Engineering - At least 4+ years of hands-on experience with Snowflake - Strong expertise in Python, SQL, and Snowpark - Proficient in developing ELT pipelines - Experience with... 
    Local area

    Expert Technology Services

    Boston, MA
    2 days ago
  •  ...Description: The Data Platform Engineering team supports CI/CD and infrastructure...  ...such as Amazon Redshift, Snowflake, Apache Iceberg, Apache Spark,...  ...engineering, data analysis, and/or ETL Experience with programming languages such as Python Experience with OS-level... 

    TalentOla

    Boston, MA
    1 day ago
  •  ...Full job description 6+ months contract Skill Requirements: We are looking for skilled Python API engineers with a strong background in backend development. The ideal candidate will have hands-on experience in API development, testing with Pytest, and implementing dependency... 
    Contract work

    Cloud Analytics Technologies LLC

    Boston, MA
    2 days ago
  •  ...Sonic MQ and Open JMS) Kafka Knowledge of ETL Tools such as Kettle and Talend...  ...and externally. Experience with Azure and Snowflake Strong written and verbal communication...  ...technical field including Finance, Economics, Engineering or Computer Science. A minimum of 8-10 years... 
    Full time
    Remote work
    Flexible hours

    State Street Bank

    Boston, MA
    3 days ago
  • Senior Data Engineer - MassHealth Data Modernization Initiative Duration: 12 months Location...  ...leveraging Informatica (IICS), Snowflake, SQL and Python code to solve complex use cases. Provide...  ...the data layers including review of ETL requirements. Capable of leading team... 
    Apprenticeship
    Local area

    LanceSoft

    Quincy, MA
    3 days ago
  •  ...plus. Start up environment with strong financial backing. The Engineering team seeks individuals passionate and disciplined about writing...  ...high-performance, distributed systems Experience with ETL and machine learning ("big data" and analytics) Front-end development... 
    Hourly pay
    Full time
    Contract work
    Immediate start
    Remote work

    Northstar Staffing Solutions

    Boston, MA
    more than 2 months ago
  • Job Description Hiring: Senior Python Developer Locations: Westlake, TXDurham, NCSmithfield, RIBoston, MAMerrimack, NHJersey City, NJ...  ...integration experience Django / FastAPI / Zope REST Framework ETL APIs and data integration XML / JSON processing MySQL & complex... 

    SCI Solutions Global LLC

    Boston, MA
    4 days ago
  • $90k - $125k

     ...We’re seeking an exceptional Backend Engineer to join and help build the core implementation...  ...environment. About You Strong Python and/or PHP skills with solid backend development...  ...Understanding of data pipelines (ETL; Spark/Databricks is a plus) Experience... 
    Full time
    Local area
    Flexible hours

    Laminar

    Somerville, MA
    more than 2 months ago
  •  ...Center of Excellence and help lead that change.You Are:As a Snowflake Advanced AI Engineer, you will design, build, and operationalize artificial...  ...driving innovationBonus Points if you haveProficiency in Python and python-based AI/ML framework and familiarity with relevant... 
    Full time
    Work experience placement
    Live in
    Work at office
    Local area
    Shift work

    Accenture

    Boston, MA
    3 days ago
  • $150k - $180k

     ...Role  We are looking for a Lead Software Engineer who thrives in a high growth environment...  ...React, React Native, Typescript, Python, Django, Postgres, Docker, and AWS. It’s...  ...with the messiness of healthcare data and ETL work The salary range for this position... 
    Full time
    Work at office
    Remote work

    Firefly Health

    Watertown, MA
    more than 2 months ago
  • $80 - $83 per hour

    Position: Senior Cloud Data Engineer Client: Commonwealth of MA (EOHHS...  ...cloud tools (including AWS & Snowflake,) and re-platforming existing...  ...Informatica (IICS), Snowflake, SQL and Python code to solve complex use...  ...layers including review of ETL requirements. Capable of leading... 
    Local area

    Apex Systems

    Quincy, MA
    4 days ago
  • Database Engineer Location: Boston MA/Merrimack NH/Durham NC (Hybrid - 5 days...  ...of database development (DB2, Snowflake, Oracle, MongoDB, Redshift, PostgreSQL) SQL, PL/SQL, Python, and shell scripting languages Experience working with ETL tools and processes (Kafka is preferred... 

    Samprasoft

    Boston, MA
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Snowflake python ETL engineer. Be the first to apply!