Data Engineering Solution Lead - Remote

Posted 2 Days Ago
Be an Early Applicant
Hiring Remotely in Rochester, NY, USA
In-Office or Remote
105K-155K Annually
Senior level
Software
The Role
Leads the technical design and delivery of a large-scale Informatica pipeline migration to Matillion and Snowflake. Establishes reusable conversion patterns, connector and authentication standards, testing and verification processes, and operational practices. Partners with clients on priorities and cutover readiness, manages delivery risks, coaches data engineers, and applies AI-assisted tools to accelerate conversion while maintaining quality, security, and accountability.
Summary Generated by Built In

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.

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.

Skills Required

  • Bachelor’s degree in Computer Science, Data Science, Engineering, or a related field, or equivalent education and experience
  • 5+ years of hands-on data engineering experience designing, building, and supporting ETL/ELT pipelines in complex enterprise environments
  • 3+ years of Snowflake experience, including dynamic tables, views, performance tuning, and schema design
  • Advanced SQL and Python experience for data processing, validation, and pipeline support
  • Experience leading the technical design of a large-scale pipeline migration or platform conversion
  • Informatica expertise and hands-on experience with Matillion or a comparable cloud-native integration platform
  • Experience using AI to accelerate pipeline conversion at scale and establishing review and verification practices for AI-generated work
  • Strong testing and verification skills, including validation design and data issue resolution
  • Experience leading and mentoring Agile engineering teams
  • Strong verbal and written communication skills for explaining technical decisions to clients, senior management, and staff
  • Ability to use AI ethically, securely, and compliantly while protecting confidential information
  • Authorization to work for any employer in the United States
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Rochester, NY
346 Employees
Year Founded: 1994

What We Do

Mindex is an industry leader in software applications and development in Rochester, New York. For more than 25 years, Mindex has delivered on the needs of a variety of customers to achieve their goals through proven technologies, software, and services. Mindex specializes in software development for large enterprise clients in the Rochester, NY area and for New York State K-12 schools. We are a rapidly growing organization expanding heavily into cloud app. development and modernizing our home-grown K-12 Student Management System, SchoolTool. SchoolTool leads the way as the most trusted web-based student management system in New York State. Designed specifically to meet NYS requirements and school districts, it provides secure access to real-time data and time-saving tools for K-12 school administrators, faculty, staff, and parents. Awards and Accolades: #1 Software Developer, 2022 - RBJ Book of Lists A Top 100 Company (#48) - The Greater Rochester Chamber of Commerce #1 Best Company - 2019 RBJ Reader Rankings Best Company Culture (top three winner) - 2019 RBJ Reader Rankings Our Mission - With the brightest minds, unparalleled dedication, a passion for creating solutions, and thoughtful execution, we collaborate with our customers to achieve their goals through proven technologies, software, and services. Our Vision - We will anticipate tomorrow’s challenges, inspire innovation, and cultivate relationships to create solutions. We are committed to connecting people, teams, and communities to make a difference and give back. Our Values - Innovation, Collaboration, Excellence, Trust, Gratitude

Similar Jobs

Remote
United States
575 Employees
210K-280K Annually

SailPoint Logo SailPoint

Director Of Product Management

Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Remote or Hybrid
United States
2461 Employees
167K-281K Annually

Motive Logo Motive

Sr Manager, Content & Academy

Artificial Intelligence • Fintech • Hardware • Information Technology • Sales • Software • Transportation
Easy Apply
Remote
United States
4000 Employees
196K-245K Annually

SailPoint Logo SailPoint

Technical Program Manager

Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Remote or Hybrid
United States
2461 Employees
98K-165K Annually

Similar Companies Hiring

Ford Energy Thumbnail
Automotive • Software • Energy • Utilities • Manufacturing • Renewable Energy
US
Revel Thumbnail
Aerospace • Hardware • Robotics • Software
Marina Del Rey, California
70 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account