Data Engineer - Remote

Mindex•Rochester, NY

1d•$90,000 - $140,000•Remote

About The Position

Mindex is hiring Data Engineers for a focused migration team moving Informatica pipelines into Maia (Matillion) and Snowflake. The role involves converting, testing, and verifying approximately 1,500–1,700 pipelines, developing reusable components to accelerate conversions, and partnering with the client on validation and cutover readiness. The position requires strong ETL/ELT fundamentals, advanced SQL and Python skills, and clear communication with technical and non-technical stakeholders. The role is fully remote, though candidates must be open to occasional in-person participation for business meetings, team events, or collaboration. Candidates within approximately 35 miles of Rochester, New York, may be asked to work from the office more frequently based on business or team needs. Applicants must be authorized to work for any U.S. employer; Mindex cannot sponsor employment visas at this time.

Requirements

At least 3 years of hands-on experience with advanced SQL and Python for data processing and pipeline support.
At least 2 years designing, building, and supporting ETL/ELT pipelines, including reusable components and workflow improvements.
At least 2 years of Snowflake experience, including dynamic tables, views, performance tuning, and schema design.
Ability to profile data from complex source systems, directly test and verify pipeline outputs, and independently resolve data issues.
Ability to work independently, communicate clearly, ask for help when blocked, and demonstrate curiosity and initiative.
Ability to use AI to augment expertise and decision-making while retaining ownership, accountability, and professional judgment for final work products and outcomes.
Sound judgment in the ethical, secure, and compliant use of AI, including protecting confidential, customer, and company information.
Authorization to work for any employer in the United States.

Nice To Haves

A bachelor's degree in Computer Science, Data Science, Engineering, or a related field, or an equivalent combination of education and experience.
Experience with data ingestion and replication tools, including connector setup, authentication, and integration across diverse sources.
Informatica or Maia (Matillion) experience.
Awareness of emerging AI capabilities, tools, and best practices, and the ability to identify opportunities to apply them in the workplace.

Responsibilities

Convert Informatica pipelines to Maia (Matillion) and Snowflake using factory-style patterns established by the Solution Lead.
Build reusable shared jobs, templates, and validation utilities.
Accelerate conversions by removing bottlenecks and manual steps, verifying AI-generated output, and incorporating proven improvements into 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 identify edge cases; use 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 subject-matter experts.
Document migration logic, assumptions, test evidence, and go-live readiness for stakeholder review.
Develop an efficient, repeatable workflow and communicate progress and risks early and often to keep the team on track for project milestones.
Use AI-assisted tools and technologies to enhance productivity, accelerate problem-solving, improve quality, automate routine tasks, and support innovation.
Use AI to streamline workflows, reduce manual effort, improve efficiency, and increase business value while applying sound ethical, secure, and compliant judgment.