Data Integration Engineer

Hydrite

Town of Brookfield (WI)

On-site

USD 100,000 - 130,000

Full time

19 hours 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

Up to 10% Retirement Contribution
Wellness Incentive $600 per year
Two Weeks Starting Paid Time Off
Medical, Dental, and Vision - Eligible

Job summary

Hydrite is seeking a Data Integration Engineer to design and manage data pipelines moving information from ERP and other systems into Snowflake. You will standardize, optimize, and document data flows to support reporting, analytics, and AI-ready data preparation.

Based in Brookfield, WI, this role focuses on building robust ETL pipelines with Matillion, integrating systems like Infor M3, Salesforce, and Maximo, and ensuring data quality and governance across enterprise datasets.

Qualifications

  • Bachelor's degree in IT/CS/IS or related field.
  • 3-5 years of experience in data engineering, ETL development, or data integration.
  • Hands-on experience building ETL/ELT pipelines with Matillion or comparable tools.
  • Strong SQL skills and experience with Snowflake or another cloud data warehouse.
  • Experience integrating data through REST APIs, middleware such as MuleSoft, or other integration platforms.
  • Familiarity with Git/source control, orchestration, and deployment practices for data pipelines.
  • Interest in AI tools and preparing data for AI agents (Copilot Studio, Snowflake Coco).
  • Proven problem-solving skills and ability to trace data issues across systems.
  • Excellent written and verbal communication, with ability to translate requirements into technical designs.
  • Experience with ERP data (Infor M3) preferred.

Responsibilities

  • Build and Support Matillion ETL Pipelines: design, build, monitor, and support ETL pipelines; become the team's expert on existing data flows.
  • Integrate New Systems Into Snowflake: develop pipelines between ERP, CRM, SaaS, APIs, and Snowflake; onboard data from Bluejay TMS, Maximo, Salesforce.
  • Model And Structure Data In Snowflake: design staging, transformation, and curated data structures; develop reusable models and semantic layers.
  • Prepare Trusted Data For BI And AI: deliver trusted data to Power BI, AI solutions, and applications; create semantic layers for MCP.
  • Partner, Document, And Govern: translate requirements into scalable models; document mappings and governance around data definitions.
  • Reporting Structure: reports to Sr. Manager - Applications.

Skills

SQL
ETL development
Data integration
Problem-solving
Communication
Documentation
Analytical thinking

Education

Bachelor's degree in IT / CS / IS or related field

Tools

Matillion
Fivetran
Informatica
SSIS
Azure Data Factory
Git
Power BI
Snowflake
MuleSoft
REST APIs

Job description

Who We Are

We are a company where people matter.

We are family driven.

We are financially strong.

And we are looking for problem-solvers to join our growing team.

Benefits
  • Up to 10% Retirement Contribution
  • $600 per Year Wellness Incentive
  • Two Weeks Starting Paid Time Off
  • Medical, Dental, and Vision - Eligible first day of the month following hire date.
Data Integration Engineer

The Data Integration Engineer is a detail-oriented, systems-minded professional who designs, builds, and supports the pipelines that move data between our business systems and Snowflake. This role is based in Brookfield, WI.

The primary purpose of this position is to deliver reliable, efficient, and well-structured enterprise data. Using Matillion as our primary ETL platform, this person will become the expert in our data flows from Infor M3 into Snowflake and will simplify them to improve how reliably and efficiently we move data. As we expand Snowflake with data from integrated systems such as Bluejay TMS, Maximo, and Salesforce, this role will select the right integration approach, whether MuleSoft, APIs, or another method, and structure the data for consumption by business users for reporting and by AI agents. This is an AI-forward team, and this role is central to preparing AI-ready data through semantic layers and evaluations that support the Model Context Protocol (MCP).

Primary Responsibilities Include
  • Build and Support Matillion ETL Pipelines:
    • Design, build, monitor, and support ETL pipelines using Matillion, including orchestration, scheduling, dependencies, and deployment.
    • Become the team's expert on all existing ETL data flows, including the core Infor M3 to Snowflake integrations, their dependencies, and their business purpose.
    • Simplify and consolidate data flows to optimize pipeline reliability, performance, scalability, and maintainability.
    • Troubleshoot data issues across the full pipeline, from source system through semantic layer.
  • Integrate New Systems Into Snowflake:
    • Develop and maintain data pipelines between systems such as ERP, CRM, SaaS platforms, APIs, and Snowflake.
    • Onboard data from integrated systems such as Bluejay TMS, Maximo, and Salesforce.
    • Evaluate and select the right integration method for each source, including Matillion, MuleSoft, direct APIs, or other approaches, based on reliability, efficiency, and supportability.
    • Implement data quality checks, reconciliation processes, monitoring, logging, and error handling.
  • Model And Structure Data In Snowflake:
    • Design and maintain staging, transformation, and curated data structures within Snowflake.
    • Develop reusable data models, views, and semantic layers.
    • Define appropriate data grain, relationships, dimensions, facts, measures, and business definitions.
  • Prepare Trusted Data For BI And AI:
    • Build and manage data flows that deliver trusted enterprise data to Power BI, AI solutions, applications, and other consumers.
    • Create semantic layers and write evaluations that prepare data for AI agents through the Model Context Protocol (MCP).
    • Provide the trusted data foundation needed for BI, analytics, Copilot/AI, agents, and natural-language querying.
  • Partner, Document, And Govern:
    • Partner with business analysts and BI/reporting resources to translate business requirements into scalable data models.
    • Document source-to-target mappings, lineage, transformation logic, and business definitions, and support governance around shared enterprise data definitions and semantic models.
    • Establish engineering standards for Matillion, Snowflake, SQL, Git/source control, and deployment practices.
  • Reporting Structure:
    • This position reports to the Sr. Manager - Applications
Preferred Experience
  • Bachelor's degree in Information Technology, Computer Science, Information Systems, or a related field preferred; equivalent experience considered.
  • 3-5 years of experience in data engineering, ETL development, or data integration.
  • Hands-on experience building ETL/ELT pipelines with Matillion or a comparable tool (e.g., Fivetran, Informatica, SSIS, or Azure Data Factory).
  • Strong SQL skills and experience with Snowflake or another cloud data warehouse.
  • Solid understanding of dimensional modeling (facts, dimensions, grain) and data warehouse design.
  • Experience integrating data through REST APIs, middleware such as MuleSoft, or other integration platforms.
  • Experience with Git/source control, orchestration, and deployment practices for data pipelines.
  • Openness to AI tools such as Copilot Studio, Cowork, and Snowflake Coco, and interest in preparing data for AI agents.
  • Proven problem-solving skills, including the ability to trace data issues across multiple systems to root cause.
  • Excellent written and verbal communication skills, with the ability to translate business requirements into technical designs.
  • Conscientious work style with high attention to detail, accuracy, and thorough documentation.
  • Experience with ERP data, ideally Infor M3, preferred.
  • Familiarity with Salesforce, Maximo, transportation management system (TMS), or Power BI data preferred.
  • Experience building semantic models, writing AI evaluations, or working with the Model Context Protocol (MCP) preferred.
Additional Benefits

Benefits and perks include 401k and profit sharing, medical/dental/vision/life insurance, paid time off, tuition reimbursement, adoption assistance, legal services insurance, scholarship awards for children of employees, summer picnic, community giving events, free family wellness coaching including nutritionist and fitness coach.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Integration Engineer
Data Integration Engineer

Hydrite • Brookfield (WI)

On-site
USD 90,000 - 120,000
401k and profit sharing
Medical/Dental/Vision
Paid time off
+4
Data Engineer
Data Engineer

Collectivus Holdings • United States

Remote
USD 100,000 - 150,000
Data Engineer
Data Engineer

Kaleidoscope • Detroit (MI)

On-site
USD 80,000 - 110,000
Sr. Data Engineer (Snowflake)
Sr. Data Engineer (Snowflake)

Data Ideology • Pittsburgh

Remote
USD 120,000 - 180,000
Flexible Time Off Policy
Health Benefits
Retirement Plan
+5
ELT Developer
ELT Developer

TechDigital Group • Cary (NC)

On-site
USD 110,000 - 140,000
Senior Data Engineer
Senior Data Engineer

Fictiv • Schaumburg (IL)

On-site
USD 167,000 - 202,000
Comprehensive medical and dental care
401(k) plan
Generous PTO and leave programs
Senior Data Engineer Schaumburg, IL
Senior Data Engineer Schaumburg, IL

Fictiv • Schaumburg (IL)

Remote
USD 167,000 - 202,000
Comprehensive medical and dental
401(k) plan
Generous PTO and leave programs
Lead Analyst, Data Platform Engineering
Lead Analyst, Data Platform Engineering

UR • United States

Remote
USD 120,000 - 170,000
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
Information Technology - Senior Data Engineer (USA)
Information Technology - Senior Data Engineer (USA)

DiversiTech Corporation • Duluth (GA)

On-site
USD 120,000 - 180,000