Data Engineer
Job Description
Mindex is hiring a Data Engineer to help migrate Informatica-based pipelines into Maia (Matillion) and Snowflake. This role supports end-to-end conversion work, including converting and validating pipelines, building reusable components, and partnering with technical leads and client SMEs on migration sequencing and cutover readiness.
The position is based in Rochester, NY with remote work available. Compensation is $90,000 to $140,000 per year, and the role requires 3+ years of hands-on data engineering experience.
Responsibilities
- Convert Informatica pipelines to Maia (Matillion) and Snowflake using Solution Lead-provided factory-style patterns, while building reusable shared jobs, templates, and validation utilities.
- Improve conversion throughput by removing bottlenecks and manual steps, verifying AI-generated output, and incorporating proven improvements into team patterns.
- Design and optimize Snowflake pipelines and downstream objects to support performance, reliability, and ease of operation.
- Build and support ingestion pipelines for on-premises and Azure SQL Server, as well as files, APIs, and MongoDB.
- Profile source data and investigate legacy behavior to uncover edge cases, using SQL and Python to compare outputs and resolve discrepancies.
- Align with technical leads and client SMEs on migration sequencing, testing standards, and sign-off criteria.
- Document migration logic, assumptions, test evidence, and go-live readiness so stakeholders can review and verify decisions.
- Establish an efficient, repeatable workflow and communicate progress and risks early to support key project milestones.
- Apply an AI-first mindset by leveraging AI-assisted tools and technologies to enhance productivity, accelerate problem-solving, improve quality, automate routine tasks, and drive innovation.
Requirements
- BS degree in Computer Science, Data Science, Engineering, or a related field preferred, or an equivalent combination of education and experience.
- 3+ years hands-on experience with advanced SQL and Python for data processing and pipeline support.
- 2+ years experience designing, building, and supporting ETL/ELT pipelines, including building reusable components and improving existing workflows.
- 2+ years Snowflake experience, including dynamic tables, views, performance tuning, and schema design.
- Experience with data ingestion and replication tools; strong preference for connector setup, authentication, and integration across diverse sources. Informatica or Maia (Matillion) experience is a plus.
- Proven ability to profile data from complex systems, test and verify pipeline outputs directly, and independently resolve data issues.
- Proactive and curious approach, with the ability to work independently, communicate clearly, and ask for help when blocked.
- Experience using AI to augment expertise and decision-making while maintaining ownership, accountability, and professional judgment.
- Ability to identify opportunities to streamline workflows, reduce manual effort, and improve efficiency and business value using AI.
- Awareness of emerging AI capabilities, tools, and best practices, with a proactive approach to applying them in the workplace.
- Demonstrated sound judgment for ethical, secure, and compliant use of AI technologies while protecting confidential information.
Technologies
- Informatica, Maia (Matillion), Snowflake
- SQL, Python
- ETL, ELT
- Azure SQL Server, MongoDB
- Dynamic tables
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 expected; exertion of up to 10 lbs.