Data Engineering Solution Lead - Remote
Mindex
- Rochester, NY
- Remote
- Senior level
- 5+ yrs experience
- Data Engineering
- Visa: not specified
- $105k–$155k
The role in 30 seconds
Mindex is seeking a Data Engineering Solution Lead to head a focused team migrating Informatica pipelines into Maia (Matillion) and Snowflake. The role owns the technical design for roughly 1,500-1,700 pipelines, turns legacy pipelines into repeatable conversion patterns, and serves as the primary client contact. The ideal candidate pairs deep ETL/ELT architecture experience with clear communication and a client-first mindset.
Is this role a fit for you?
The backgrounds this role is most likely to hire from, as RoleStack reads the posting.
Strong match
- Data platform / ML pipeline
- B2B infrastructure / API / developer tools
- Enterprise-scale
- Growth-stage
Workable stretch
- B2B enterprise platform / workflow software
- Internal tooling / back-office systems
- Regulated environment
Harder transition
- B2C consumer-facing application
- Embedded systems / hardware-adjacent
- Startup / greenfield
Industry: Horizontal agnostic (data engineering services across sectors; education/K-12 client context incidental). See your personal match score
What they're really screening for
Must-haves
- CORE 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
- CORE 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
- CORE Experience leading the technical design of a large-scale pipeline migration or platform conversion, including source-to-target mapping patterns and reusable conversion standards
- CORE Informatica expertise and hands-on experience with Matillion or a comparable cloud-native integration platform; Informatica-to-Matillion migration experience is highly desirable
- PLUS Experience using AI to accelerate pipeline conversion at scale and setting review and verification practices for AI-generated work
- PLUS Strong testing and verification skills, including designing validation approaches and independently identifying and resolving data issues
- CORE 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
- PLUS Uses AI to augment expertise and decision-making while maintaining ownership, accountability, and professional judgment for final work products and outcomes
- PLUS Identifies opportunities to use AI to streamline workflows, reduce manual effort, improve efficiency, and increase business value
- PLUS Maintains awareness of emerging AI capabilities, tools, and best practices and proactively identifies opportunities to apply them in the workplace
Nice-to-haves
- PLUS BS degree in Computer Science, Data Science, Engineering, or a related field preferred, or an equivalent combination of education and experience
Résumé keywords for this role
Terms the posting stresses. Include the ones you can honestly back up.
Tools & technologies
- Informatica
- Matillion
- Maia
- Snowflake
- ETL
- ELT
- SQL
- Python
- Azure SQL Server
- MongoDB
- APIs
- dynamic tables
- views
- AI-assisted tools
- AI-generated work
Concepts & phrases
- Data Engineering Solution Lead
- Informatica pipelines
- Maia (Matillion)
- Snowflake
- ETL/ELT pipelines
- pipeline migration
- platform conversion
- source-to-target mapping
- reusable conversion standards
- cloud-native integration platform
- AI-assisted conversion
- AI-first mindset
- client-first mindset
- data acquisition leadership
- fiscal year-end milestones
Words that count as the same thing: "Maia" ≈ Matillion, Matillion ETL · "ETL/ELT" ≈ Extract Transform Load, Extract Load Transform, data integration pipelines · "Agile" ≈ Scrum, iterative development, Agile delivery · "AI-assisted conversion" ≈ LLM-assisted code conversion, AI-generated pipeline conversion, AI-augmented ETL
Check my résumé against these keywordsHiring at Mindex
Open senior roles RoleStack tracks right now, posted in the last 30 days.
More open roles at Mindex
- Senior Project Manager - Hybrid $90k–$140k
Full job description from Mindex
From Mindex's posting. View the original
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.
Show full description Show less
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.
• 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.
FAQ
How much does a Data Engineering Solution Lead - Remote at Mindex make?
The posted pay for this role is $105k–$155k a year.
How much experience do you need?
The posting asks for 5+ years in data engineering. It is a senior-level role.
Does Mindex sponsor visas for this role?
The posting does not say whether visa sponsorship is available. Ask the recruiter before you apply.
Is this role remote?
It is a remote role.
What tools and technologies does the posting mention?
Informatica, Matillion, Maia, Snowflake, ETL, ELT, SQL, Python, Azure SQL Server, MongoDB, APIs, dynamic tables, views, AI-assisted tools, AI-generated work.