Matillion ETL / Snowflake / Python Data Engineer Contract

Data Lens, Inc.

United States

Remote

USD 55,000 - 96,000

Part time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Data Lens Consulting is seeking a Matillion ETL Developer / Data Engineer to migrate an existing Matillion ETL framework to a Python-based solution using Prefect and Snowflake. The role focuses on analyzing, documenting, and migrating ETL pipelines while preserving business rules. U.S.

citizens and those authorized to work in the U.S. are preferred; no sponsorship available. The ideal candidate will have hands-on Matillion ETL experience, strong Snowflake/SQL skills, and cloud data warehousing

Qualifications

  • 3+ years hands-on experience with Matillion ETL, including orchestration and transformation jobs.
  • Strong Snowflake and advanced SQL development skills.
  • Experience with Python-based data engineering and ETL development.
  • Experience with AWS services, particularly S3.
  • Solid understanding of ETL/ELT architectures, data warehousing, and data integration patterns.
  • Experience troubleshooting complex ETL pipelines and resolving data quality issues.
  • Ability to analyze and reverse-engineer existing ETL implementations.

Responsibilities

  • Analyze existing Matillion orchestration and transformation jobs to understand processing logic, dependencies, and data flows.
  • Migrate Matillion ETL pipelines to a Python-based framework orchestrated through Prefect.
  • Extract, adapt, and optimize existing SQL transformations for Snowflake.
  • Work with AWS S3 data sources, file ingestion processes, and cloud storage integrations.
  • Implement error handling, logging, auditing, and restart/recovery mechanisms.
  • Validate migrated pipelines to ensure data accuracy, completeness, and consistency with existing processes.
  • Troubleshoot ETL issues and optimize pipeline performance.
  • Collaborate with data engineers to document migration requirements, dependencies, and technical specifications.

Skills

Matillion ETL
Snowflake
SQL Development
Python Data Engineering
AWS S3
ETL/ELT architectures
Data warehousing
Data integration patterns
Troubleshooting ETL pipelines
Reverse-engineering ETL

Tools

Prefect
Git
CI/CD
Snowflake procedures

Job description

Matillion ETL / Snowflake / Python Data Engineer Contract
Matillion ETL / Snowflake / Python Data Engineer Contract

Matillion ETL Migration Engineer (Snowflake / Prefect / Python)

Position Overview

Data Lens Consulting is seeking an experienced Matillion ETL Developer / Data Engineer to support the migration of an existing Matillion ETL framework to a Python-based solution using Prefect and Snowflake. The ideal candidate will have hands‑on experience with Matillion ETL, AWS, strong Snowflake/SQL development skills, and cloud data warehousing.

The candidate will collaborate with data engineers to analyze, document, and migrate existing Matillion ETL pipelines into a scalable, maintainable Python-based framework while preserving existing data transformation logic and business rules.

  • U.S. citizens and candidates authorized to work in the U.S. We are unable to sponsor at this time.
  • No third parties at this time.

Key Responsibilities

  • Analyze existing Matillion orchestration and transformation jobs to understand processing logic, dependencies, and data flows.
  • Migrate Matillion ETL pipelines to a Python-based framework orchestrated through Prefect.
  • Extract, adapt, and optimize existing SQL transformations for Snowflake.
  • Work with AWS S3 data sources, file ingestion processes, and cloud storage integrations.
  • Implement error handling, logging, auditing, and restart/recovery mechanisms.
  • Validate migrated pipelines to ensure data accuracy, completeness, and consistency with existing processes.
  • Troubleshoot ETL issues and optimize pipeline performance.
  • Collaborate with data engineers to document migration requirements, dependencies, and technical specifications.

Required Qualifications

  • 3+ years of hands‑on experience with Matillion ETL, including orchestration and transformation jobs.
  • Strong Snowflake and advanced SQL development skills.
  • Experience with Python-based data engineering and ETL development.
  • Experience with AWS services, particularly S3.
  • Solid understanding of ETL/ELT architectures, data warehousing, and data integration patterns.
  • Experience troubleshooting complex ETL pipelines and resolving data quality issues.
  • Ability to analyze and reverse‑engineer existing ETL implementations.

Preferred Qualifications

  • Experience with Prefect or similar Python-based orchestration frameworks.
  • Prior experience migrating Matillion jobs to another ETL framework.
  • Familiarity with Snowflake stored procedures, tasks, and performance optimization.
  • Experience with Git, CI/CD, and automated deployment processes.

Ideal Candidate

The ideal candidate is a hands‑on data engineer with strong Matillion and Snowflake expertise who can quickly understand existing ETL processes and translate them into efficient Python-based solutions. The candidate should be comfortable working collaboratively in a consulting environment, independently troubleshooting complex data pipelines, and delivering well‑documented, production‑ready solutions.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer: Matillion to Python + Snowflake Orchestration
Data Engineer: Matillion to Python + Snowflake Orchestration

Data Lens, Inc. • United States

Remote
USD 55,000 - 96,000
Data Engineer (Matillion)
Data Engineer (Matillion)

Focus Cloud Group • United States

Remote
USD 100,000 - 130,000
Senior ELT Engineer — Matillion & Snowflake Leader
Senior ELT Engineer — Matillion & Snowflake Leader

TechDigital Group • Cary (NC)

On-site
USD 110,000 - 140,000
Data Engineer
Data Engineer

Kaleidoscope Innovation, Inc. • Detroit (MI)

On-site
USD 120,000 - 180,000
Data Engineer (Matillion)
Data Engineer (Matillion)

TechDigital Group • Secaucus (NJ)

On-site
USD 120,000 - 150,000
Data Engineer Snowflake
Data Engineer Snowflake

Capgemini • Miami (FL)

On-site
USD 120,000 - 160,000
Snowflake Platform Engineer
Snowflake Platform Engineer

SCI SOLUTIONS GLOBAL • Wilmington (DE)

On-site
USD 140,000 - 200,000
Data Engineer: Snowflake ETL Pipelines (Contract-to-Hire)
Data Engineer: Snowflake ETL Pipelines (Contract-to-Hire)

Fults & Associates, LLC • Texas

On-site
USD 90,000 - 120,000
Data Engineer
Data Engineer

INFOSYS NOVA HOLDINGS LLC • Detroit (MI)

On-site
USD 80,000 - 110,000
Equal opportunity employer
Data Integration Engineer
Data Integration Engineer

Hydrite • Brookfield (WI)

On-site
USD 90,000 - 120,000
401k and profit sharing
Medical/Dental/Vision
Paid time off
+4