Data Engineer - Remote

Mindex

City of Rochester (NY)

Remote

USD 90,000 - 140,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
401(k) with Company Match
Company-Paid Life and Disability Insur

Job summary

Mindex is seeking Data Engineers to join a migration-focused team moving Informatica pipelines to Maia (Matillion) and Snowflake. You will convert, test, and validate pipelines—roughly 1,500–1,700 in scope—while building reusable components and collaborating with client SMEs to ensure cutover readiness.

The ideal candidate has strong ETL/ELT fundamentals, advanced SQL and Python skills, and clear communication with technical and non-technical stakeholders.

Qualifications

  • BS degree in Computer Science, Data Science, Engineering, or related field or equivalent experience.
  • 3+ years of hands-on SQL and Python for data processing and pipeline support.
  • 2+ years designing, building, and supporting ETL/ELT pipelines with reusable components.
  • 2+ years Snowflake experience including dynamic tables, views, and tuning.
  • Informatica or Maia (Matillion) experience is a plus.

Responsibilities

  • Convert Informatica pipelines to Maia (Matillion) and Snowflake using factory patterns.
  • Build reusable shared jobs, templates, and validation utilities.
  • Speed up conversions by removing bottlenecks and validating outputs.
  • Design and optimize Snowflake pipelines and downstream objects for performance and reliability.
  • Build and support ingestion pipelines for on-premises and cloud sources.
  • Profile source data and resolve discrepancies with SQL and Python.

Skills

Advanced SQL
Python
ETL/ELT Fundamentals
Data Pipelines
Analytical thinking
Communication
Problem solving

Education

BS in Computer Science/Data Science/Engineering or related field

Tools

Maia (Matillion)
Informatica
Snowflake

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineering Solution Lead - Remote
Data Engineering Solution Lead - Remote

Mindex • City of Rochester (NY)

Hybrid
USD 105,000 - 155,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+2
Data Engineer - Remote
Data Engineer - Remote

Mindex • United States

Remote
USD 90,000 - 140,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+2
Data Engineering Solution Lead
Data Engineering Solution Lead

Mindex • City of Rochester (NY)

Hybrid
USD 105,000 - 155,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+3
Data Engineering Solution Lead - Remote
Data Engineering Solution Lead - Remote

Mindex • United States

Remote
USD 105,000 - 155,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
Data Engineer – Snowflake Migration & ETL at Mindex
Data Engineer – Snowflake Migration & ETL at Mindex

Mindex • City of Rochester (NY)

Hybrid
USD 90,000 - 140,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+2
Data Engineer - Hybrid
Data Engineer - Hybrid

Mindex • City of Rochester (NY)

Hybrid
USD 90,000 - 140,000
Flexible Time Off
Medical, Dental, Vision Insurance
401(k) with Company Match
+1
Data Engineer - Hybrid
Data Engineer - Hybrid

Mindex • City of Rochester (NY)

Hybrid
USD 90,000 - 140,000
Flexible Time Off
Medical Insurance
Dental Insurance
+4
Data Engineering Lead Role: Snowflake, AI & ETL Migration
Data Engineering Lead Role: Snowflake, AI & ETL Migration

Mindex • City of Rochester (NY)

Hybrid
USD 105,000 - 155,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+3
.NET Software Engineer
.NET Software Engineer

Mindex • City of Rochester (NY)

Remote
USD 70,000 - 120,000
Fully Remote Work Environment
Flexible Time Off
Medical, Dental, and Vision Insurance
+3
Data Engineering Solution Lead
Data Engineering Solution Lead

Jobgether • United States

Remote
USD 105,000 - 155,000
Remote work
Medical, dental, and vision insurance
401(k) retirement plan with company •?
+4