Job Description
Mindex is looking for Data Engineers to join a focused migration team moving Informatica pipelines into Maia (Matillion) and Snowflake. You’ll convert, test, and verify pipelines across an estate of roughly 1,500-1,700 pipelines, build reusable components that speed up each conversion, and partner with our client on validation and cutover readiness. The ideal candidate has strong ETL/ELT fundamentals, advanced SQL and Python skills, and communicates clearly with technical and non-technical stakeholders.
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
$90,000 - $140,000
What You’ll Accomplish
Convert Informatica pipelines to Maia (Matillion) and Snowflake using the Solution Lead’s factory-style patterns, and build reusable shared jobs, templates, and validation utilities.
Speed up conversions by removing bottlenecks and manual steps, verifying AI-generated output, and folding proven improvements into the team’s shared patterns.
Design and optimize Snowflake pipelines and downstream objects for performance, reliability, and ease of operation.
Build and support ingestion pipelines for on-premises and Azure SQL Server, files, APIs, and MongoDB.
Profile source data and investigate legacy behavior to uncover edge cases, using SQL and Python to compare outputs with legacy results and resolve discrepancies.
Agree on migration sequencing, testing standards, and sign-off criteria with technical leads and client SMEs.
Document migration logic, assumptions, test evidence, and go-live readiness so stakeholders can review and verify decisions.
Build an efficient, repeatable workflow and communicate progress and risks early and often to keep the team on track for key project milestones.
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.
3+ years of hands-on experience with advanced SQL and Python for data processing and pipeline support.
2+ years designing, building, and supporting ETL/ELT pipelines, including building reusable components and improving existing workflows.
2+ years of Snowflake experience, including dynamic tables, views, performance tuning, and schema design.
Experience with data ingestion and replication tools; connector setup, authentication, and integration across diverse sources strongly preferred. Informatica or Maia (Matillion) experience is a plus.
Proven ability to profile data from complex source systems, test and verify pipeline outputs directly, and independently resolve data issues.
Proactive, curious, and able to work independently, communicate clearly, and ask for help when blocked.
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.
- 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.
