Opportunity

Data Engineering Lead Role: Snowflake, AI & ETL Migration in Columbus

Location Columbus
Company Mindex
Source workable
Posted 2026-11-13 23:16:55

Career & Market Insight

A High-Impact Technical Leadership Role

This position sits at the intersection of hands-on architecture and client-facing leadership — a relatively rare combination that commands a premium in today's data engineering market. The $105K–$155K band is competitive but leans toward mid-market for a senior lead with Snowflake and Matillion expertise; top-tier tech companies pay 20–40% more for equivalent seniority, though consulting/product firms like Mindex often compensate with stability and breadth of experience.

Skills You'll Build

  • Large-scale ETL/ELT migration architecture — directly marketable as cloud data modernization is a major industry trend through at least 2027.
  • AI-augmented pipeline development — a genuinely emerging skill set with high future demand.
  • Snowflake (dynamic tables, performance tuning) and Matillion — both are growing platforms with strong job market demand.
  • Client-facing technical leadership — positions you for Principal Engineer, Solutions Architect, or CTO tracks.

Culture & Green/Red Flags

  • Green flag: 30+ year company with established products suggests financial stability and low layoff risk.
  • Green flag: Explicit AI-first mindset signals a forward-looking engineering culture, not a stagnant legacy shop.
  • Yellow flag: Tight May/June fiscal year-end milestones on a 1,500+ pipeline migration suggests inherited urgency — clarify scope and risk ownership in interviews.
  • Yellow flag: "May include direct reports" language suggests team structure is still being defined.

Overall, strong for a senior engineer wanting to step into technical leadership with a diverse, client-facing portfolio.

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.

Requirements

  • BS degree in Computer Science, Data Science, Engineering, or a related field preferred, or an equivalent combination of education and experience.
  • 5+ years of hands-on data engineering experience designing, building, and supporting ETL/ELT pipelines in complex enterprise environments, including connector setup, authentication, and integration across diverse sources.
  • 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.
  • Identifies opportunities to use AI to streamline workflows, reduce manual effort, improve efficiency, and increase business value.
  • Maintains awareness of emerging AI capabilities, tools, and best practices and proactively identifies opportunities to apply them in the workplace.
  • Demonstrates sound judgment in the ethical, secure, and compliant use of AI technologies while protecting confidential, customer, and company information.

Why Join Mindex?

For more than 30 years, Mindex has helped organizations solve complex business challenges through custom software, cloud, data, and AI solutions. We combine deep technical expertise with a collaborative culture that empowers our employees to innovate, grow, and make a meaningful impact for our clients.

In our Product division, our teams have built platforms such as SchoolTool, Advanced Analytics, and our Integrations Platform from the ground up, while also supporting solutions like MTSS Edge and ClearTrack that help schools and organizations make smarter, data-driven decisions.

Benefits

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

Additional Information

Applicants must be authorized to work for any employer in the United States. Mindex is unable to sponsor employment visas at this time.

Physical Requirements/Conditions

  • Prolonged periods sitting at a desk and working on a computer.
  • No heavy lifting is expected. Exertion of up to 10 lbs.

Frequently Asked Questions

Is this role truly fully remote or is office attendance required?
The role is listed as fully remote, but all candidates must be open to occasional in-person participation for meetings or team events. Candidates within ~35 miles of Rochester, NY may be asked to come into the office more frequently.
What is the salary range for the Data Engineering Solution Lead position?
Mindex offers a compensation range of $105,000 to $155,000 annually for this role, depending on experience and qualifications.
Is visa sponsorship available for this position?
No. Applicants must already be authorized to work for any employer in the United States — Mindex is unable to sponsor employment visas at this time.
What technologies will I work with in this role?
You'll primarily work with Informatica (as the source), Matillion (branded as Maia), Snowflake, Azure SQL Server, MongoDB, and APIs, along with AI-assisted tooling for pipeline conversion at scale.
How large is the migration project this role will lead?
The project involves migrating approximately 1,500–1,700 Informatica pipelines to Matillion and Snowflake, with hard delivery milestones tied to the client's May and June fiscal year-end.
UdreamJob
Curated By

UdreamJob

Remote work & career advice that actually works.

Similar Opportunities