Data Engineer: Matillion to Python + Snowflake Orchestration

Data Lens, Inc.

United States

Remote

USD 55,000 - 96,000

Part time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

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

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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

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
Remote Data Engineer (6-Month) — Matillion & Snowflake
Remote Data Engineer (6-Month) — Matillion & Snowflake

Fynity • United States

Remote
GBP 64,000 - 84,000
Data Engineer (Matillion)
Data Engineer (Matillion)

TechDigital Group • Secaucus (NJ)

On-site
USD 120,000 - 150,000
Senior Snowflake Data Engineer — ETL, SQL & Cloud
Senior Snowflake Data Engineer — ETL, SQL & Cloud

Supersourcing • Oregon (WI)

Hybrid
USD 90,000 - 120,000
Remote Data Engineer — Snowflake & Matillion Migration
Remote Data Engineer — Snowflake & Matillion Migration

Mindex • City of Rochester (NY)

Hybrid
USD 90,000 - 140,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+2
Senior Data Engineer: Matillion/Snowflake, Remote
Senior Data Engineer: Matillion/Snowflake, Remote

Innova Solutions Inc. • New Jersey

Remote
USD 83,000 - 90,000
Medical & pharmacy coverage
Dental/vision insurance
401(k)
Data Engineer: Oracle-to-Snowflake Migration Expert
Data Engineer: Oracle-to-Snowflake Migration Expert

Highbrow LLC • Austin (TX)

On-site
USD 90,000 - 120,000
Remote Migration Data Engineer (Snowflake/Matillion)
Remote Migration Data Engineer (Snowflake/Matillion)

Mindex • City of Rochester (NY)

Remote
USD 90,000 - 140,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+2
Senior Python Data Engineer | Snowflake & Data Pipelines
Senior Python Data Engineer | Snowflake & Data Pipelines

Ethereum Technologies LLC • Sunnyvale (CA)

On-site
USD 130,000 - 190,000