Remote Data Engineering Lead: AI-Driven ETL & Snowflake

Mindex

City of Rochester (NY)

Hybrid

USD 105,000 - 155,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

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

Get past ATS filters

Benefits offered by this job

Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
401(k) with Company Match
Company-Paid Life and Disability Ins
Professional Development Opportunities

Job summary

Mindex is seeking a Data Engineering Solution Lead to head a focused team migrating Informatica pipelines into Maia (Matillion) and Snowflake. You will own the technical design for about 1,500–1,700 pipelines and serve as the primary client contact, shaping architecture and delivery strategy with a client-first mindset.

The role combines hands-on architecture with client-facing leadership. Occasional in-person collaboration near Rochester, NY is possible, with the option for fully remote work.

Qualifications

  • 5+ years hands-on data engineering in complex enterprise environments designing, building, and supporting ETL/ELT pipelines.
  • 3+ years Snowflake experience with dynamic tables, views, performance tuning, and schema design; strong SQL and Python for data processing.
  • Experience leading technical design of large-scale pipeline migrations including source-to-target mapping and reusable conversion standards.
  • Informatica expertise and hands-on Matillion/ Maia migration experience highly desirable.
  • Experience using AI to accelerate pipeline conversions and setting review/verification practices for AI-generated work.

Responsibilities

  • Own end-to-end design for migrating Informatica pipelines to Maia (Matillion) and Snowflake, including target architecture and operational standards.
  • Define repeatable processes to discover, classify, convert, test, and promote pipelines with reusable components.
  • Design connectors and authentication patterns for on-premises and cloud data endpoints (Azure SQL Server, files, APIs, MongoDB).
  • Set testing standards and verify pipelines, providing guidance on quality and documentation.
  • Scale AI-assisted conversion with guardrails and review steps to protect quality.

Skills

Snowflake
Matillion
ETL/ELT Architecture
Leadership
Azure SQL / MongoDB / APIs

Education

BS in CS/related field

Tools

Informatica
Matillion/Maia
Snowflake
Azure SQL Server
MongoDB

Job description

Mindex is seeking a Data Engineering Solution Lead to head a focused team migrating Informatica pipelines into Maia (Matillion) and Snowflake. You will own the technical design for about 1,500–1,700 pipelines and serve as the primary client contact, shaping architecture and delivery strategy with a client-first mindset.

The role combines hands-on architecture with client-facing leadership. Occasional in-person collaboration near Rochester, NY is possible, with the option for fully remote work.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote Data Engineering Lead: Informatica to Snowflake
Remote Data Engineering Lead: Informatica to Snowflake

Mindex • City of Rochester (NY)

Hybrid
USD 105,000 - 155,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+3
Remote Data Engineering Solution Lead for 1500+ Pipelines
Remote Data Engineering Solution Lead for 1500+ Pipelines

Mindex • City of Rochester (NY)

Hybrid
USD 105,000 - 155,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+2
Remote Data Engineering Solutions Lead
Remote Data Engineering Solutions Lead

Mindex • United States

Remote
USD 105,000 - 155,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
Remote ETL Migration Engineer: Informatica to Snowflake
Remote ETL Migration Engineer: Informatica to Snowflake

Mindex • United States

Remote
USD 90,000 - 140,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+2
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
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
Data Engineering Solution Lead - Remote
Data Engineering Solution Lead - Remote

Mindex • United States

Remote
USD 105,000 - 155,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
Data Engineering Migration Lead: Informatica to Snowflake
Data Engineering Migration Lead: Informatica to Snowflake

Jobgether • United States

Remote
USD 105,000 - 155,000
Remote work
Medical, dental, and vision insurance
401(k) retirement plan with company •?
+4
Data Engineering Solution Lead - Remote
Data Engineering Solution Lead - Remote

Mindex • City of Rochester (NY)

Hybrid
USD 105,000 - 155,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+2
Data Engineer - Remote
Data Engineer - Remote

Mindex • City of Rochester (NY)

Remote
USD 90,000 - 140,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+2