Data Engineering Solution Lead - Remote

Mindex is looking for 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, turn one-off legacy pipelines into repeatable conversion patterns, and serve as the team’s primary contact with our client. The ideal candidate pairs deep ETL/ELT architecture experience with clear communication and a client-first mindset.

We welcome candidates from a variety of locations; however, all candidates should be open to occasional in-person participation for business meetings, team events, or collaboration opportunities. Candidates located within approximately 35 miles of Rochester, NY may be asked to work from the office more frequently based on business or team needs.

Compensation

$105,000 - $155,000

What You’ll Accomplish

• 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.