Data Engineering Solution Lead

Jobgether

United States

Remote

USD 105,000 - 155,000

Full time

21 hours 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

Remote work
Medical, dental, and vision insurance
401(k) retirement plan with company •?
Company-paid life and disability保险
Flexible time off
Professional development
Occasional in-person meetings near NY

Job summary

Jobgether seeks a Data Engineering Solution Lead in the United States to drive a large-scale migration from Informatica to Maia (Matillion) and Snowflake. You will own end-to-end architecture, define repeatable migration processes, and mentor engineers in a client-focused environment.

The role emphasizes leadership, enterprise ETL/ELT expertise, Snowflake development, and an AI-first approach to accelerate delivery while ensuring quality.

Qualifications

  • Bachelor's degree or equivalent experience in CS/Engineering/Data Science.
  • 5+ years hands-on data engineering in enterprise ETL/ELT.
  • 3+ years Snowflake experience with dynamic tables, views, performance optimization.
  • Advanced SQL and Python for data processing and validation.
  • Proven experience leading large-scale data migrations or platform conversions.
  • Strong Informatica expertise and experience with Matillion.
  • Experience using AI-assisted technologies to accelerate pipeline conversions.
  • Excellent communication and leadership in Agile teams.

Responsibilities

  • Own end-to-end technical design for migrating pipelines to Maia/Matillion and Snowflake.
  • Define repeatable processes for discovering, converting, testing, and promoting pipelines.
  • Build a library of reusable conversion patterns and components.
  • Design connectors for on-prem, Azure SQL Server, files, APIs, and MongoDB.
  • Establish testing standards and validation processes.
  • Mentor and develop data engineers and guide delivery priorities.
  • Lead daily delivery activities and coordinate with data acquisition teams.
  • Apply AI-first approach to automate routine tasks while ensuring accountability.

Skills

SQL
Python
Snowflake
Informatica
Matillion
ETL/ELT
Team leadership
Communication
AI usage

Education

Bachelor's degree in Computer Science or related

Tools

Matillion
Informatica
Snowflake

Job description

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Data Engineering Solution Lead based in the United States.

We are looking for an experienced Data Engineering Solution Lead to drive a large-scale data migration initiative, transitioning legacy Informatica pipelines to Maia (Matillion) and Snowflake. In this role, you will own the end-to-end technical architecture and lead the conversion of approximately 1,500–1,700 data pipelines. You will establish scalable migration patterns, strengthen data quality standards, and leverage AI-assisted technologies to accelerate delivery while maintaining technical excellence. Working closely with clients and engineering stakeholders, you will guide priorities, manage delivery risks, and ensure successful project milestones. This is an opportunity to combine hands‑on technical expertise, architectural leadership, and team development in a collaborative, client‑focused environment.

Accountabilities

You will lead the technical strategy and day-to-day execution of a complex data engineering migration, ensuring that legacy pipelines are converted into scalable, reusable, and reliable solutions. You will also serve as the primary technical point of contact for the client, coordinating delivery priorities and supporting the development of engineering capabilities.

  • Own the end-to-end technical design for migrating Informatica pipelines to Maia (Matillion) and Snowflake, including target architecture, orchestration, error handling, and operational standards.
  • Define repeatable processes for discovering, classifying, converting, testing, and promoting pipelines.
  • Build and maintain a shared library of reusable conversion patterns and high-impact technical components.
  • Design connector and authentication approaches for on-premises systems, Azure SQL Server, files, APIs, and MongoDB.
  • Establish testing standards, validation processes, and sign-off requirements to ensure migration quality.
  • Review pipelines, test evidence, and technical documentation, providing feedback and requesting corrections when necessary.
  • Scale AI-assisted pipeline conversion through appropriate quality controls, verification processes, and human oversight.
  • Collaborate with client stakeholders and internal leadership to establish priorities, sequencing, and cutover readiness.
  • Lead daily delivery activities and coordinate with data acquisition teams to meet critical May and June fiscal year-end milestones.
  • Identify delivery risks, communicate technical trade-offs, and elevate potential issues proactively.
  • Mentor and develop data engineers, including potential direct reports, while encouraging continuous improvement and technical innovation.
  • Evaluate emerging tools, technologies, and engineering practices to improve productivity and solution quality.
  • Apply an AI-first approach to automate routine tasks, accelerate problem‑solving, and enhance delivery efficiency while maintaining accountability for final outcomes.
Requirements

The ideal candidate combines extensive data engineering experience with strong technical architecture and team leadership capabilities. You should have a proven background in enterprise ETL/ELT environments, large-scale platform migrations, and Snowflake development, alongside the ability to communicate complex technical decisions clearly to clients and stakeholders. A proactive, client-oriented mindset and the ability to use AI responsibly to improve engineering workflows are essential.

  • Bachelor's degree in Computer Science, Data Science, Engineering, or a related field preferred, or an equivalent combination of education and professional experience.
  • At least 5 years of hands‑on data engineering experience designing, building, and supporting ETL/ELT pipelines in complex enterprise environments.
  • At least 3 years of Snowflake experience, including dynamic tables, views, performance optimization, and schema design.
  • Advanced SQL and Python skills for data processing, validation, troubleshooting, and pipeline support.
  • Proven experience leading the technical design of large‑scale data migrations or platform conversions, including source‑to‑target mapping and reusable conversion standards.
  • Strong Informatica expertise and practical experience with Matillion or a comparable cloud‑native data integration platform.
  • Previous experience migrating Informatica pipelines to Matillion is highly desirable.
  • Experience using AI-assisted technologies to accelerate large‑scale pipeline conversion and establish review and verification standards for AI-generated outputs.
  • Strong testing and data validation capabilities, including the ability to independently identify, investigate, and resolve data quality issues.
  • Experience leading and mentoring Agile engineering teams.
  • Excellent written and verbal communication skills, with the ability to explain technical decisions to clients, senior management, and engineering teams.
  • Proactive, curious, self‑sufficient, and client-focused approach to problem‑solving and delivery.
  • Ability to use AI to enhance expertise and decision‑making while maintaining ownership, accountability, and professional judgment.
  • Experience identifying opportunities to automate workflows, reduce manual effort, improve efficiency, and increase business value through AI.
  • Awareness of emerging AI tools, capabilities, and best practices, with the ability to identify practical workplace applications.
  • Sound judgment in the ethical, secure, and compliant use of AI, particularly when handling confidential and customer information.
  • Authorization to work for any employer in the United States. Employment visa sponsorship is not available.
Benefits
  • Salary: $105,000–$155,000 per year.
  • Fully remote work environment.
  • Flexible time off.
  • Medical, dental, and vision insurance.
  • 401(k) retirement plan with company matching.
  • Company-paid life and disability insurance.
  • Professional development and continuous learning opportunities.
  • Occasional in‑person participation for business meetings, team events, and collaboration.
  • Candidates located within approximately 35 miles of Rochester, New York, may be asked to attend the office more frequently depending on business and team needs.

We appreciate your interest and wish you the best!

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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

Mindex • City of Rochester (NY)

Hybrid
USD 105,000 - 155,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+3
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 • United States

Remote
USD 90,000 - 140,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+2
Data Engineering Lead Role: Snowflake, AI & ETL Migration
Data Engineering Lead Role: Snowflake, AI & ETL Migration

Mindex • City of Rochester (NY)

Hybrid
USD 105,000 - 155,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+3
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
Data Engineer – Snowflake Migration & ETL at Mindex
Data Engineer – Snowflake Migration & ETL at Mindex

Mindex • City of Rochester (NY)

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

Empower Retirement, LLC • Kansas

Hybrid
USD 125,000 - 182,000
Medical, dental, vision & life
401(k) with company match
Tuition reimbursement
+5
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
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