Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Integration Engineer

Hydrite

Job Description

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 f irst day of the month following hire date.

JOIN A TOP WORKPLACE -

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.

 

WANT TO STAY CONNECTED?  FIND US ON SOCIAL MEDIA

  • LinkedIn: linkedin.com/company/hydrite -chemical-co-
  • Facebook: facebook.com/hydrite
  • YouTube:

Learn more about Hydrite on our website:

Privacy Notice for California Residents: -Notice-for-Employees.htm

Vacancy posted 6 days ago
Similar jobs that could be interesting for youBased on the Data Integration Engineer in Brookfield, WI vacancy
  •  ...Become the subject-matter expert for existing data flows, especially Infor M3 to Snowflake integrations. Simplify and consolidate pipelines to improve...  ...analysts and BI/reporting resources and establish engineering standards for data integration and deployment.... 
    Suggested
    Full time
    Summer work

    Hydrite

    Brookfield, WI
    5 days ago
  • We are looking for a Data Engineer to help shape and expand a cloud-focused data environment that supports analytics, operational reporting...  ..., and long-term growth.• Implement ETL processes that integrate data from multiple sources while improving consistency, completeness... 
    Suggested

    Robert Half

    Brookfield, WI
    3 days ago
  •  ...Intelligent Automation We are seeking a highly innovative Director of Data Science & Analytics to lead the next evolution of an enterprise...  ...Business Intelligence, Data Science, and emerging AI-focused engineering functions while helping shape the company's long-term data and... 
    Suggested
    Immediate start

    Robert Half

    Brookfield, WI
    15 days ago
  • We are looking for a Staff Data Engineer to shape the direction of enterprise data platforms in Brookfield, Wisconsin. In this role, you...  ..., scalability, and operational efficiency.• Develop APIs and integration patterns that connect internal platforms and external systems... 
    Suggested

    Robert Half

    Brookfield, WI
    4 days ago
  • $131.6k - $249.78k

     ...we develop and deploy category-defining, data-driven, software-as-a-service (SaaS)...  ...future. In this position as a Staff Data Engineer of IntelliScript’s Data Platform, you will...  ...and implementation of internal APIs for integrating data between different systems and applicationsIntegration... 
    Suggested
    Full time
    Work experience placement
    Work at office
    Remote work

    Milliman

    Brookfield, WI
    3 days ago
  •  ...Primary Function Provide senior-level technical expertise in data center thermal management, with an emphasis on liquid cooling,...  ...thermal storage. Evaluate data center cooling architectures, develop engineering concepts, support prototype and laboratory validation, and... 
    Full time
    Temporary work
    Local area
    Worldwide

    A.O. Smith

    Milwaukee, WI
    3 days ago
  •  ...Job Description Job Description Summary: The engineer in this position should have a wealth of experience engineering/installing...  ...cohesive package. This would include the complete engineering of data centers including, but not limited to, infrastructure, overhead... 
    For contractors
    Work at office
    Local area

    ADEX

    Milwaukee, WI
    3 days ago
  • Data & ML Architect - New Resources ConsultingSummary: We’re looking for a Data & ML Architect to design and deliver modern data solutions...  ...teams. You’ll design and model data environments, support data integration and transformation, and help implement end-to-end solutions.... 
    Remote work
    Flexible hours

    New Resources Consulting

    Milwaukee, WI
    3 days ago
  •  ...Data Security Engineer (Microsoft Purview / DLP) Milwaukee, WI | Hybrid: 3 days onsite | Contract-to-hire CDW is seeking a Data Security Engineer with hands-on Microsoft Purview and enterprise data loss prevention experience for a Fortune 500 energy utility. This... 
    Contract work
    3 days per week

    CDW

    Milwaukee, WI
    2 days ago
  • $105.59k - $179.51k

     ...opportunity help us create the next generation data platform. Becoming Data-driven is at the...  ...! We are looking for a Senior Data Engineer who is passionate about building trusted...  ...: Define and evolve data integration frameworks, engineering standards, reusable... 
    Full time
    Casual work
    Work at office
    Local area

    MGIC Investment

    Milwaukee, WI
    3 days ago
  • $97.55k - $159.77k

    Job Description: The Data Engineer at Northwestern Mutual Life Insurance Company in Milwaukee, WI will design and build scalable data pipelines...  ...data pipeline monitoring, data quality detection, and data integration issue resolution. Build intelligent anomaly detection systems... 
    Full time
    Remote work
    2 days per week

    Northwestern Mutual

    Milwaukee, WI
    16 hours ago
  • We Are:The beginning of a new Data & AI decade that will reshape work and society has...  ..., and Power Ecosystem.You Are:As a Data Engineering, Management & Governance professional, you...  ...have: Experience in large-scale data integration and data warehouse solutions, Databricks... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Milwaukee, WI
    1 day ago
  •  ...everything you need to create innovative new solutions on our engineering team. As a Sr. Data Engineer, you will design, build, and support scalable...  ...maintain scalable data pipelines, data models, and data integration solutions that support engineering and test operations.... 
    Full time

    Milwaukee Electric Tool

    Menomonee Falls, WI
    3 days ago
  • About the RoleAs Senior Software Engineer, you will collaborate closely with design, product...  ...critical thinking, experimentation, data, and industry best practices to implement...  ...standards such as GDPR, PCI DSS, SOX, and CCPA.Integrate GenAI tools such as OpenAI, Gemini, and... 
    Remote work

    Kohl's

    Menomonee Falls, WI
    1 day ago
  •  ...Data & Analytics Engineer As a Data & Analytics Engineer, you’ll help transform data into meaningful business insights that drive decision-making across the organization. You will have the opportunity to build data pipelines, develop reporting solutions, and partner... 
    Internship
    Live in

    HUSCO International

    Waukesha, WI
    3 days ago
  •  ...experience focuses on delivering robust data solutions using ADF for OBP and Snowflake...  ...efficiently while maintaining data integrity and consistency across subject areas. -Implement...  ...practical knowledge of cloud based data engineering practices, including monitoring, cost... 
    Remote work
    Day shift

    TechDigital Corporation

    Milwaukee, WI
    6 days ago
  •  ...functional agility.Your Role on Our TeamAs a Metrology Data, Systems, and Automation Engineer, you will help modernize metrology operations by...  ...engineering, software automation, data analytics, systems integration, technical applications support, or related technical... 
    Full time

    Milwaukee Electric Tool

    Brookfield, WI
    4 days ago
  • $118.96k - $178.44k

     ...to acquire, analyze, combine, synthesize, and structure data with clear definitions and sources for analytical consumptionConsult...  ...of data products using continuous deployment and integration practicesApply engineering best practices in order to analyze, design, develop,... 
    Full time
    Local area

    Northwestern Mutual

    Milwaukee, WI
    4 days ago
  • $85.91k - $162.89k

     ...our applicant tracking system.Job Description:As an Associate Data Engineer you will design, build, and optimize modern data solutions...  ...Bicep) and test automation frameworks preferred.- Experience in integrating SaaS/ERP sources (e.g., Dynamics 365, Workday, Oracle,... 
    Full time
    Local area
    Remote work
    Worldwide

    Baker Tilly

    Milwaukee, WI
    16 hours ago
  •  ...Job Description Job Description Job Title: Data & Analytics Engineer Location: Milwaukee , WI Duration: 06 months contract JOB...  ...SQL Database, and Azure Data Lake Experience with data integration tools such as SSIS, dbt, Azure Data Factory, or similar technologies... 
    Contract work

    Sunrise Systems Inc

    Milwaukee, WI
    24 days ago
  •  ...real-world solutions, join us and unleash your potential as a change catalyst.   Who We’re Looking For We’re excited to add a Data Engineer to our Cloud, Data & AI Solutions Team. In this role, you’ll work with a team of customer-focused professionals who are... 
    Remote job
    Contract work
    Part time
    Live out

    concurrency

    Brookfield, WI
    9 days ago
  • $61 per hour

     ...Cloud Data Platform Engineer (database replication / migration) Location: Franklin, WI - 3 days onsite a week Duration: 1 year minimum...  ...enhance enterprise cloud platforms responsible for moving and integrating data across AWS and hybrid environments. This is not a... 
    3 days per week

    Tier4 Group

    Franklin, WI
    3 days ago
  •  ...StatesPosted: 2026-08-20This OpportunityAccelerate possibilities. The WSP Data Center CoE (Center of Excellence) is growing, and we’re looking...  ...is currently initiating a search for a Data Center Mechanical Engineer, Senior Consultant for our Milwaukee, WI office. As a Senior... 
    For contractors
    Internship
    Work at office

    WSP Group

    Milwaukee, WI
    3 days ago
  • $131.6k - $249.78k

     ...we develop and deploy category-defining, data-driven, software-as-a-service (SaaS) products...  ...entailsAs a Staff Information Security Engineer on the Information Security team at...  ...breachesCollaborate with development teams to integrate security best practices throughout the... 
    Full time
    Work experience placement
    Remote work

    Milliman

    Brookfield, WI
    16 hours ago
  • $122.9k - $204.9k

     ...strategies. The ideal candidate will have a strong background in data analytics, experience with Adobe CJA, and a passion for...  ...objectives. Implement data collection strategies and ensure data integrity across various marketing channels. Analyze data to identify trends... 
    Summer holiday
    Immediate start
    Flexible hours

    EY

    Milwaukee, WI
    2 days ago
  • $112k - $147k

     ...-11-11Accelerate possibilities. The WSP Data Center CoE (Center of Excellence) is growing...  ...design assignments supporting multiple engineering disciplines Produce accurate 2D drawings...  ..., and electrical/mechanical control integrations Meet required schedules while producing... 
    For contractors
    Work at office
    Local area
    Remote work
    Flexible hours

    WSP Group

    Milwaukee, WI
    4 days ago
  • $96.8k - $135k

     ...places. Great projects. kW Mission Critical Engineering, a WSP company, is a high-performance,...  ...consulting engineering firm designing data centers and mission critical environments...  ..., and electrical/mechanical control integrations Meet required schedules while producing... 
    For contractors
    Work at office
    Local area
    Flexible hours

    WSP Group

    Milwaukee, WI
    1 day ago
  •  ...Job Description Job Description Role Overview The Principal Data Engineer is a senior technical authority responsible for defining the organization's data architecture, setting long-term technical strategy, and solving the most complex data engineering challenges.... 

    Continuus Technologies LLC

    Germantown, WI
    29 days ago
  •  ...-functional and global application teams to design and develop data layers and data stores (data services in Java, stored procedures...  ...targeted applications • Data analytics - implement known data engineering tasks including transformation, quality remediation and report,... 
    Immediate start
    Remote work

    LanceSoft

    Waukesha, WI
    16 hours ago
  • $131k - $180k

     ...TX, United States; Dallas, TX, United StatesPosted: 2026-10-16Building ICT & Structured Cabling | Hyperscale Data Center ProjectskW Mission Critical Engineering, a WSP USA company, is currently initiating a search for a Lead Telecommunications Designer - Building ICT &... 
    For contractors
    Work at office
    Local area
    Remote work
    Flexible hours

    WSP Group

    Milwaukee, WI
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Integration Engineer. Be the first to apply!