Remote Data Engineering Lead: Informatica to Snowflake

Mindex

City of Rochester (NY)

Hybrid

USD 105,000 - 155,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

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
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’ll own the technical design for roughly 1,500-1,700 pipelines and serve as the primary client contact, turning legacy pipelines into repeatable conversion patterns.

The role combines deep ETL/ELT architecture with strong communication and a client-first mindset, while guiding Agile teams and leveraging AI to enhance productivity and quality.

Qualifications

  • BS degree in Computer Science, Data Science, Engineering, or a related field.
  • 5+ years of hands-on data engineering designing, building, and supporting ETL/ELT pipelines in complex enterprise environments.
  • 3+ years of Snowflake experience with dynamic tables, views, performance tuning, and schema design, plus advanced SQL and Python for data processing, validation, and pipeline support.
  • Experience leading the technical design of a large-scale pipeline migration or platform conversion, including source-to-target mapping patterns and reusable conversion standards.
  • Informatica expertise and hands-on experience with Matillion or a comparable cloud-native integration platform; Informatica-to-Matillion migration experience is highly desirable.
  • Experience using AI to accelerate pipeline conversion at scale and setting review and verification practices for AI-generated work.
  • Strong testing and verification skills, including designing validation approaches and independently identifying and resolving data issues.
  • Experience leading and mentoring Agile engineering teams; proactive, curious, self-sufficient, and client-focused, with strong verbal and written skills for explaining technical decisions to clients, senior management, and staff.
  • Uses AI to augment expertise and decision-making while maintaining ownership, accountability, and professional judgment for final work products and outcomes.

Responsibilities

  • Own the client-approved, end-to-end design for migrating Informatica pipelines to Maia (Matillion) and Snowflake, including target architecture, orchestration, error handling, and operational standards.
  • Define a repeatable process to discover, classify, convert, test, and promote pipelines, and maintain a shared library of conversion patterns and high-impact reusable components.
  • Design connector and authentication patterns for on-premises and Azure SQL Server, files, APIs, and MongoDB.
  • Set testing standards and sign-off evidence, and review pipelines, test evidence, and documentation for final quality, sending work back when needed.
  • Scale AI-assisted conversion to increase throughput, with guardrails and review steps that protect quality.
  • Partner with client and Mindex stakeholders on sequencing, priorities, and cutover readiness, tying delivery to the client’s mission and business goals.
  • Lead day-to-day delivery with data acquisition leadership to meet tight May and June fiscal year-end milestones, escalating risks and explaining trade-offs early.
  • Coach and develop data engineers, which may include direct reports, and evaluate new tools, processes, and practices for the team.
  • Demonstrate an AI-first mindset by effectively leveraging AI-assisted tools and technologies to enhance productivity, accelerate problem-solving, improve quality, automate routine tasks, and drive innovation in the delivery of solutions and services.

Skills

ETL/ELT design
Snowflake design
SQL
Python
Informatica
Matillion
AI acceleration
Agile leadership
Communication
Cloud integration

Education

BS degree in Computer Science / Data Science / Engineering

Tools

Informatica
Matillion
Snowflake
Azure SQL Server

Job description

Mindex is seeking a Data Engineering Solution Lead to head a focused team migrating Informatica pipelines into Maia (Matillion) and Snowflake. You’ll own the technical design for roughly 1,500-1,700 pipelines and serve as the primary client contact, turning legacy pipelines into repeatable conversion patterns.

The role combines deep ETL/ELT architecture with strong communication and a client-first mindset, while guiding Agile teams and leveraging AI to enhance productivity and quality.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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 Data Engineering Lead: AI-Driven ETL & Snowflake
Remote Data Engineering Lead: AI-Driven ETL & 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 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 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 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
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
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 Solution Lead
Data Engineering Solution Lead

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