Data Engineer jobs

Data Integration Engineer

HydriteBrookfield, WI3+ years experiencePosted 5 days ago

Pay not listed

Looks real and checked open today.

On Hydrite’s own careers site (Greenhouse).

Trust score ready Nov 23

  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteGreenhouse board
  • Checked: Checked open todayGreenhouse board
  • Note: Too new for a trust scoreScored after a week of daily checks, from Nov 23
See all 4 checksShow fewer
How we check

What you’ll do

  • Build, monitor, troubleshoot, and improve Matillion ETL pipelines, including existing Infor M3-to-Snowflake data flows.
  • Integrate data from systems such as Bluejay TMS, Maximo, and Salesforce into Snowflake, selecting appropriate integration methods and adding quality checks and monitoring.
  • Design and maintain Snowflake staging, transformation, curated, and semantic data structures.
  • Deliver trusted data to BI tools, applications, and AI solutions; prepare semantic layers and evaluations for AI agents using MCP.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • 3–5 years of experience in data engineering, ETL development, or data integration (preferred)
  • Hands-on experience building ETL/ELT pipelines with Matillion or a comparable tool (preferred)
  • Experience integrating data through REST APIs, MuleSoft, or other integration platforms (preferred)
  • Experience with Git/source control, orchestration, and deployment practices for data pipelines (preferred)
  • Experience with ERP data, ideally Infor M3 (preferred)
  • Familiarity with Salesforce, Maximo, a 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)

Education

  • Bachelor's degree in Information Technology, Computer Science, Information Systems, or a related field; equivalent experience considered (preferred)

Skills

  • Strong SQL skills and experience with Snowflake or another cloud data warehouse (preferred)
  • Understanding of dimensional modeling and data warehouse design (preferred)

Other requirements

  • Openness to AI tools such as Copilot Studio, Cowork, and Snowflake Coco, and interest in preparing data for AI agents (preferred)

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Benefits

Health insurance
Medical insurance; eligible the first day of the month following hire
Dental & vision
Dental and vision insurance; eligible the first day of the month following hire
Retirement plan
Up to 10% retirement contribution, 401(k) and profit sharing
Paid time off
Two weeks starting paid time off
Learning & tuition
Tuition reimbursement
Wellness & mental health
$600 per year wellness incentive, Free family wellness coaching, including a nutritionist and fitness coach
Life & disability insurance
Life insurance
Family & fertility support
Adoption assistance
Other
Legal services insurance, Scholarship awards for children of employees, Summer picnic and community giving events

Full job description

From Hydrite’s careers site

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.

JOIN A TOP WORKPLACE - https://www.youtube.com/watch?v=7nlFHnnfvhk

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.

Show full descriptionShow less

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.

WANT TO STAY CONNECTED? FIND US ON SOCIAL MEDIA

  • LinkedIn: linkedin.com/company/hydrite-chemical-co-
  • Facebook: facebook.com/hydrite
  • YouTube:https://www.youtube.com/watch?v=Bs_493NR8RI

Learn more about Hydrite on our website: www.hydrite.com/careers

Privacy Notice for California Residents: https://www.hydrite.com/Legal/Privacy-Notice-for-Employees.htm

Something wrong with this job? Report it · This flag looks wrong

Similar jobs

Data Integration Engineer

D.A. Davidson · Remote · US only

$74k–$106k/yrFull-time

StrongChecked open todayPosted 10 days ago

Senior Data Engineer

Vericast · Remote · US only

$130k–$150k/yrFull-time

StrongChecked open todayPosted yesterday

Senior Data Engineer

AIR Communities · Denver, CO

$125k–$145k/yrFull-timeOn-site

StrongChecked open todayPosted 2 days ago

Lead Data Engineer

AIR Communities · Denver, CO

$135k–$160k/yrFull-timeOn-site

StrongChecked open todayPosted 2 days ago

Sr. Data Engineer

NBCUniversal · New York, NY

$115k–$145k/yrFull-timeHybrid

StrongChecked open todayPosted 2 days ago

See more like this