Data Integration Engineer

Hydrite•Brookfield, WI
•Onsite

About The Position

The Data Integration Engineer is a detail-oriented, systems-minded professional who designs, builds, and supports pipelines that move data between business systems and Snowflake. Based in Brookfield, Wisconsin, the role delivers reliable, efficient, well-structured enterprise data, primarily using Matillion as the ETL platform. The engineer will become the expert on existing Infor M3-to-Snowflake data flows and simplify them to improve reliability and efficiency. As data from integrated systems such as Bluejay TMS, Maximo, and Salesforce is added to Snowflake, the role evaluates suitable integration approaches—including MuleSoft and APIs—and structures data for business reporting and AI agents. The team is AI-forward, and this role helps prepare AI-ready data through semantic layers and evaluations supporting the Model Context Protocol (MCP). The position partners with business analysts and BI/reporting resources to translate business requirements into scalable data models, supports governance of shared enterprise data definitions and semantic models, and establishes engineering standards for Matillion, Snowflake, SQL, Git/source control, and deployment practices.

Requirements

  • 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 such as Fivetran, Informatica, SSIS, or Azure Data Factory.
  • Strong SQL skills and experience with Snowflake or another cloud data warehouse.
  • Solid understanding of dimensional modeling, including facts, dimensions, and 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 tracing data issues across multiple systems to their root cause.
  • Excellent written and verbal communication skills and ability to translate business requirements into technical designs.
  • Conscientious work style with high attention to detail, accuracy, and thorough documentation.

Nice To Haves

  • Bachelor's degree in Information Technology, Computer Science, Information Systems, or a related field; equivalent experience is considered.
  • Experience with ERP data, ideally Infor M3.
  • Familiarity with Salesforce, Maximo, a transportation management system (TMS), or Power BI data.
  • Experience building semantic models, writing AI evaluations, or working with the Model Context Protocol (MCP).

Responsibilities

  • Design, build, monitor, and support Matillion ETL pipelines, including orchestration, scheduling, dependencies, and deployment.
  • Develop expertise in existing ETL data flows, including core Infor M3-to-Snowflake integrations, their dependencies, and business purpose.
  • Simplify and consolidate data flows to improve pipeline reliability, performance, scalability, and maintainability.
  • Troubleshoot data issues across the pipeline, from source systems through the semantic layer.
  • Develop and maintain data pipelines between ERP, CRM, SaaS platforms, APIs, and Snowflake, including onboarding Bluejay TMS, Maximo, and Salesforce data.
  • Evaluate and select integration methods such as Matillion, MuleSoft, direct APIs, or other approaches based on reliability, efficiency, and supportability.
  • Implement data quality checks, reconciliation processes, monitoring, logging, and error handling.
  • Design and maintain Snowflake staging, transformation, and curated data structures.
  • Develop reusable data models, views, and semantic layers; define data grain, relationships, dimensions, facts, measures, and business definitions.
  • Build and manage data flows delivering trusted enterprise data to Power BI, AI solutions, applications, and other consumers.
  • Create semantic layers and write evaluations to prepare data for AI agents through the Model Context Protocol (MCP).
  • Provide a trusted data foundation for BI, analytics, Copilot/AI, agents, and natural-language querying.
  • Partner with business analysts and BI/reporting resources to turn business requirements into scalable data models.
  • Document source-to-target mappings, lineage, transformation logic, and business definitions, and support governance of shared enterprise data definitions and semantic models.
  • Establish engineering standards for Matillion, Snowflake, SQL, Git/source control, and deployment practices.

Benefits

  • Up to 10% retirement contribution.
  • $600 per year wellness incentive.
  • Two weeks of starting paid time off.
  • Medical, dental, and vision coverage, eligible the first day of the month following hire date.
  • 401(k) and profit sharing.
  • Life insurance.
  • Tuition reimbursement.
  • Adoption assistance.
  • Legal services insurance.
  • Scholarship awards for children of employees.
  • Summer picnic and community giving events.
  • Free family wellness coaching, including access to a nutritionist and fitness coach.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service