Data Engineer - Remote

Mindex is seeking Data Engineers for a focused migration team converting Informatica pipelines to Maia (Matillion) and Snowflake. The role involves converting and validating pipelines, building reusable migration components, optimizing data workflows, and partnering with the client on validation and cutover readiness.

Responsibilities:

• 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

Requirements:

• 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
• 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
• Applicants must be authorized to work for any employer in the United States
• Mindex is unable to sponsor employment visas at this time
• BS degree in Computer Science, Data Science, Engineering, or a related field
• an equivalent combination of education and experience
• Experience with data ingestion and replication tools; connector setup, authentication, and integration across diverse sources
• Informatica or Maia (Matillion) experience