Hydrite

Data Integration Engineer

Hydrite
Apply
2 days ago
Brookfield, WI, USAMid Level / Senior

Responsibilities

  • Design, build, monitor, schedule, deploy, and support Matillion ETL pipelines.
  • Become the subject-matter expert for existing data flows, especially Infor M3 to Snowflake integrations.
  • Simplify and consolidate pipelines to improve reliability, performance, scalability, and maintainability.
  • Integrate ERP, CRM, SaaS, API, and other source systems into Snowflake using Matillion, MuleSoft, direct APIs, or other suitable approaches.
  • Implement data quality checks, reconciliation, monitoring, logging, and error handling.
  • Design and maintain Snowflake staging, transformation, curated, data-model, view, and semantic-layer structures.
  • Define data grain, relationships, dimensions, facts, measures, and business definitions.
  • Deliver trusted data to Power BI, AI solutions, applications, and other consumers.
  • Create semantic layers and evaluations supporting AI agents and the Model Context Protocol.
  • Document source-to-target mappings, lineage, transformation logic, and business definitions.
  • Partner with business analysts and BI/reporting resources and establish engineering standards for data integration and deployment.

Requirements

  • Bachelor's degree in Information Technology, Computer Science, Information Systems, or a related field is preferred; equivalent experience is considered.
  • Three to five years of experience in data engineering, ETL development, or data integration.
  • Hands-on experience building ETL or ELT pipelines with Matillion or comparable tools such as Fivetran, Informatica, SSIS, or Azure Data Factory.
  • Strong SQL skills and experience with Snowflake or another cloud data warehouse.
  • Understanding of dimensional modeling, including facts, dimensions, grain, and data warehouse design.
  • Experience integrating data through REST APIs, MuleSoft, or other integration platforms.
  • Experience with Git/source control, orchestration, and deployment practices for data pipelines.
  • Interest in AI tools and preparing data for AI agents, including Copilot Studio, Cowork, or Snowflake Coco.
  • Problem-solving ability to trace data issues across multiple systems to root cause.
  • Strong written and verbal communication skills for translating business requirements into technical designs.
  • High attention to detail, accuracy, documentation, and conscientious execution.
  • Experience with ERP data, ideally Infor M3, is preferred.
  • Familiarity with Salesforce, Maximo, transportation management systems, or Power BI data is preferred.
  • Experience with semantic models, AI evaluations, or the Model Context Protocol is preferred.

Benefits

  • Up to 10% retirement contribution.
  • $600 annual wellness incentive.
  • Two weeks of starting paid time off.
  • Medical, dental, and vision coverage eligible from the first day of the month following hire date.
  • 401(k), profit sharing, life insurance, tuition reimbursement, adoption assistance, legal services insurance, and scholarship awards for employees' children.
  • Summer picnic, community giving events, and free family wellness coaching including nutritionist and fitness coach.
  • The position is based in Brookfield, Wisconsin.

Tech Stack

GitInformaticaSnowflakeSQL

Categories

Data Engineering
Hydrite

About Hydrite

501-1,000 employees

Hydrite manufactures and distributes bulk and specialty chemicals and related services for food and beverage processors, industrial manufacturers, water and wastewater operations, and agriculture. Its offerings include foam control, sanitation, membrane cleaning, process organics, wastewater treatment solutions, and toll manufacturing, supported by logistics and onsite services. Founded in 1929 and headquartered in Brookfield, Wisconsin, the company is privately held and serves customers across the United States.

Contact me