Data & Integration Manager

Ontech Talent; Wisconsin; On-site; USD 120,000 - 170,000; Full time

Job summary

Ontech Talent seeks a Data & Integration Manager to lead the enterprise data, integration, automation, and internal development function in a large multi-system environment. This role owns strategy, delivery, quality, governance, and support of data platforms and integration services to connect ERP and business apps with reporting and analytics.

The role partners with business and IT leadership, vendors, and stakeholders to deliver trusted data, reliable integrations, scalable automations, and

Qualifications

• 8+ years of progressive experience in data engineering, integration, analytics, or enterprise systems roles.
• 3+ years of experience leading teams or major enterprise data/integration initiatives.
• Strong experience with Microsoft Azure data services and cloud platforms.
• Experience with API-based integrations, EDI, ETL/ELT pipelines, automation, and enterprise patterns.
• Hands-on leadership with Power BI, Power Apps, Power Automate, Databricks, SQL, Python, and Spark.

Responsibilities

• Own enterprise data platform strategy, architecture, and delivery for Azure-based platforms.
• Oversee data ELT/ETL, warehousing, and data modeling for analytics and reporting.
• Lead ERP and line of business integrations via APIs, EDI, and automation workflows.
• Deliver process improvements using automation and integration solutions.
• Establish development, governance, quality, security, and documentation standards.

Skills

Data engineering

Leadership

Azure data services

Power BI

API integrations

ETL/ELT

SQL

Python

Data governance

Education

Bachelor’s degree in IT/CS/Data Engineering

Tools

Azure Data Factory

Databricks

Power Platform

Synapse

Job description

Job Description

Job Summary: The Data & Integration Manager is responsible for leading the enterprise data, integration, automation, and internal development function in a large, multi-system environment. This role owns the strategy, delivery, quality, governance, and support of data platforms and integration services. The position will play a key role in connecting enterprise business systems, including ERP and other lines of business applications, with downstream reporting, analytics, automation, application, and process-improvement needs. The manager will partner with business leaders, IT infrastructure & operation teams, application owners, vendors, and executive stakeholders to deliver trusted data, reliable integrations, scalable automations, and measurable business value.

Job Duties & Responsibilities:

• Own enterprise data platform strategy, architecture, and delivery for Azure Databases, Dataverse, Data Lakes, Synapse, Fabric, and other platforms in alignment with business priorities.
• Oversee data ELT, ETL, warehousing, semantic modeling, and orchestration processes across operational, analytical, and reporting environments to support enterprise analytics and reporting teams.
• Lead ERP and line of business application integrations (Infor Cloud Suite, PJM, Adobe, Autodesk, Command Alkon, HubSpot, Dispatch, and others) via APIs, EDI, event-driven integrations, and automation workflows.
• Deliver measurable process improvements using automation and integration solutions using Power Platform and other systems (Power Apps, Power Automate, Copilot Studio, etc.).
• Establish development and data governance, quality, security, and documentation standards.
• Develop monitoring, audit, retention, exception handling, reconciliation, and issue-resolution processes related to enterprise data and software development.
• Manage data and development teams, vendors, 3rd party consulting, project backlog, and delivery priorities.
• Partner with business and IT leaders to deliver analytics, integration, and automation value.

Job-Based Competencies:

• Spark / Big Data Processing
• Data Modeling & Warehousing
• Pipeline Design & Reliability
• Cloud Data Platforms
• Streaming
• Data Governance & Security
• Architecture & Cost Optimization
• Communication
• Customer Service
• Collaboration & Cross-Team Influence
• Mentoring & Tech Leadership
• Change Management & Learning Agility

Experience & Qualifications:

• 8+ years of progressive experience in data engineering, integration, analytics, application development, business intelligence, or enterprise systems roles.
• 3+ years of experience leading teams, managing technical delivery, or overseeing major enterprise data/integration initiatives.
• Strong experience with Microsoft Azure data services, including Azure SQL, Azure Data Factory, Data Lake/Lakehouse, Synapse, Fabric, and equivalent cloud data platforms.
• Experience integrating, expanding, and onboarding ERP systems; experience with Infor Cloud Suite Distribution is strongly preferred.
• Experience with API-based integrations, EDI, ETL/ELT data pipelines, automation workflows, and enterprise integration patterns.
• Hands-on and/or leadership experience with Power BI, Power Apps, Power Automate, Databricks, SQL, Python, Spark, and modern analytics platforms.
• Experience establishing standards for development lifecycle, source control, testing, deployment, documentation, monitoring, and production support.
• Experience supporting multi-location, enterprise-scale operations with distributed business processes and systems.
• Bachelor’s degree in Information Technology, Computer Science, Data Engineering, Information Systems, Business Analytics, or equivalent.
• Experience supporting audits, compliance, data disaster recovery, and business continuity planning is a plus.
• Ability to lead and communicate clearly with technical teams, vendors, and cross-functional initiatives with clear accountability and follow-through.
• Strong analytical mindset with ability to troubleshoot complex data, integration, automation, and business process issues.
• Strong documentation, change management, testing, release management, governance, and support habits.

Experience & Qualifications:

• TOGAF, ITIL, CBIP, PMP, and/or Microsoft Data Engineering / Development / Architecture certifications.
• Familiarity with Azure API Management, Infor ION API Gateway, MuleSoft, Boomi, Apigee, Kong, Amazon API Gateway, Postman, SAP Integration Suite frameworks and platforms.

Work Environment:

• Work is typically performed