Data & Integration Manager

Central Processing; Town of Brookfield (WI); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401(k) match

Paid holidays

Paid time off

Disability insurance

Boot allowance

Job summary

County Materials in Brookfield, WI is seeking a Data & Integration Manager to lead enterprise data, integration, and automation initiatives across a multi-system environment. You will own data platforms, governance, and delivery, partnering with business leaders and IT teams to drive trusted data and measurable value.

The role focuses on Azure-based data services, ERP integrations, and scalable automation using Power Platform; requires strong leadership and cross-functional collaboration across

Qualifications

• 8+ years in data engineering, integration, analytics, or enterprise systems roles.
• 3+ years leading teams or major enterprise data initiatives.
• Strong experience with Microsoft Azure data services (Azure SQL, Azure Data Factory, Data Lake/Lakehouse, Synapse, Fabric).
• Experience integrating ERP systems; Infor Cloud Suite Distribution preferred.
• Experience with API-based integrations, EDI, ETL/ELT pipelines, and automation workflows.
• Hands-on or leadership experience with Power BI, Power Apps, Power Automate, Databricks, SQL, Python, Spark.

Responsibilities

• Own enterprise data platform strategy, architecture, and delivery across Azure Databases, Dataverse, Data Lakes, Synapse, Fabric, and related platforms.
• Oversee ELT/ETL, warehousing, semantic modeling, and orchestration for analytics and reporting environments.
• Lead ERP and line-of-business integrations via APIs, EDI, event-driven integrations, and automation workflows.
• Deliver automation and integration solutions using Power Platform and other systems (Power Apps, Power Automate, Copilot Studio).
• Establish development and data governance, quality, security, and documentation standards.
• Develop monitoring, audit, retention, 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.

Skills

Azure data services

ETL/ELT pipelines

Power Platform

APIs & EDI integrations

Data governance

Leadership

SQL / Python

Databricks

Education

Bachelor's degree in IT/CS/Data

Tools

Azure Data Factory

Dataverse

Synapse

Power Automate

Power BI

Databricks

Job description

We’re hiring a Data & Integration Manager to join County Materials in Brookfield, WI.

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, to 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.

County Core Competencies:

• Integrity & Organizational Awareness
• Customer First Focus
• Results Driven Orientation
• Teamwork, Safety & Collaboration
• Problem Solving & Decision Making
• Creativity & Innovation

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.

Certifications:

• 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 in an indoor office environment.
• Exposure may include noise, machinery, dust, and public interaction.
• 10‑20% travel is required (up to 50% while onboarding the first 90 days).
• Typical work performed during business hours.

Physical & Work Expectations:

An individual in this position must be able to perform the essential duties and responsibilities listed above successfully. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of this position.

• Frequent Sitting.
• Occasional standing, walking, bending, reaching, or handling materials/equipment.
• Occasional climbing, kneeling, crawling, or lifting/moving up to 25 pounds.
• Ability to concentrate, follow detailed instructions, communicate effectively, and safely perform job duties.
• May require the operation of specific tools, equipment, or vehicles associated with the position.

Benefits Overview:

• Health, dental and vision insurance
• Paid Short‑term & Long‑term disability
• 401(k) match
• 8 Paid holidays
• Paid Time Off
• Referral rewards program
• Wellness program with rewards
• Flexible Savings Options
• Employee Assistance Program
• Paid Life Insurance
• $200 Boot Allowance
• Safety focused: GUARD for Life
• Voluntary critical illness & accident insurance
• Optional Uniform Program

County Materials Family of Companies is an EEO/Affirmative Action Employer; all qualified applicants will receive consideration for employment without regard to any characteristic prohibited by federal, state and/or local laws.

We participate in E‑Verify to confirm employment eligibility for all new hires.