ERP Integrations Lead — Pillar Lead

University of Missouri - Columbia; Columbia Township (MO); On-site; USD 71,000 - 138,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Retirement plan

Job summary

University of Missouri - Columbia seeks an ERP Integrations Lead to own end-to-end integration architecture for the ERP Forward portfolio, spanning Boomi, Oracle Integration Cloud, Workday Studio, and Azure API governance.

You will lead a multi-team development effort, establish delivery standards, and ensure secure, compliant data flows across ~250 planned integrations while coordinating with MUHC and SI partners.

Qualifications

• Bachelor’s degree or equivalent combination of education and experience, and five years of relevant experience.
• Seven (7) or more years in enterprise application integration, middleware development, or ERP technical architecture.
• Experience leading or managing a technical integration team in a complex, multi-system environment.
• Proficiency in SQL/PL/SQL and at least one enterprise integration platform.
• Boomi architecture and development experience: Boomi integration processes, Atoms (cloud and local), API Management, DataHub, and event services.
• Experience with Azure API Management (APIM) and Azure API Center (APIC) for API gateway, lifecycle management, and catalog governance.
• Familiarity with Oracle Integration Cloud (OIC) and Workday integration tools.

Responsibilities

• Define and own the end-to-end integration architecture for ERP Forward across Boomi, ERP-native tools, and Azure API governance.
• Lead the integration development team through Plan, Architect & Configure, Test, Deploy, and Support phases.
• Coordinate MUHC-specific integrations with IT resources and leadership.
• Coordinate with Data & Analytics Lead to feed Fabric Lakehouse and Power BI pipelines correctly.
• Represent the Integrations pillar in Steering Committee updates and design reviews.

Skills

Boomi architecture

API governance

Integration architecture

Team leadership

SQL/PLSQL

Education

Bachelor's degree

Tools

Boomi

Azure API Management

Workday Studio

Oracle Integration Cloud

PeopleSoft Integration Broker

Job description

Hiring Department

ERP Project

Job Description

The ERP Integrations Lead serves as Pillar Lead for UM’s roughly 250-integration ERP Forward portfolio on a 50/50 workshare with the System Integrator (SI) partner. This role owns end-to-end integration architecture and delivery across UM’s enterprise toolstack: Boomi (selected enterprise iPaaS), Oracle Integration Cloud or Workday Studio (ERP-native integration), Azure API Management and Azure API Center (API governance layer), PeopleSoft Integration Broker (legacy source), and Oracle Database as the underlying data platform for PeopleSoft and potentially Oracle Fusion.

UM has selected Boomi as our enterprise iPaaS platform. The Integrations Lead will govern the integration architecture across Boomi, ERP-native tools, and Azure API governance — ensuring a coherent, maintainable integration landscape that supports ERP go-live and long-term operational sustainability.

Define and own the end-to-end integration architecture for ERP Forward, governing how Boomi (enterprise iPaaS), Oracle Integration Cloud/Workday Studio (ERP-native), and Azure API Management/APICenter (API governance layer) are used together across roughly 250 planned integrations. Establish Boomi delivery standards for UM: naming conventions, packaging, deployment procedures, connection management, Atom configuration (cloud vs. local Atoms for DCL3/4 data), logging, error handling, scheduling, and operational runbooks — building on the patterns established in the Boomi PowerCenter migration engagement.

Govern Azure API Management (APIM) and Azure API Center (APIC) as the API governance/discovery layer, decoupled from Boomi iPaaS, for enterprise API lifecycle management, catalog maintenance, and security policy enforcement. Define ERP-native integration standards for Oracle Integration Cloud (OIC) adapters (REST, SOAP, File, FBDI/HDL, ERP Cloud adapter) or Workday Studio/EIB/CoreConnectors, and govern how these complement vs. replace Boomi for ERP-specific interfaces. Ensure all integration patterns comply with UM System DCL1–4 data classification requirements, with local Boomi Atom deployment for DCL3/4 data processing.

Lead the integration development team (UM Integration Developers, MUHC Integration Developer, SI partner developers) through Plan, Architect & Configure, Test, Deploy, and Support phases. Review and approve integration technical design documents, Boomi process designs, OIC integration flows, EIB/Studio specifications, data mapping documents, and API contracts. Coordinate MUHC-specific integrations (Oracle/Cerner or Epic EHR, healthcare-specific HR/Finance interfaces) with the MUHC IT resources and leadership.

Coordinate with the Data & Analytics Lead to ensure Boomi and OIC/Studio integration outputs feed Microsoft Fabric Lakehouse and Power BI pipelines correctly. Partner with the Security/IAM Lead to enforce DCL1–4 data classification, OAuth 2.0/OpenID Connect authentication, and data masking requirements on all Boomi and ERP-native integration flows. Represent the Integrations pillar in Steering Committee updates, cross-workstream sessions, and SI partner design reviews.

This is a project-funded position aligned with the ERP Forward program timeline. All employment and pay decisions reflect UM System job architecture and compensation philosophy, including the ERP Salary & Wage Guidelines approved by the ERP Steering Committee. Opportunities for post-go-live support roles exist for strong performers.

Shift

Monday – Friday, 8:00 am - 5:00 pm

Minimum Qualifications

Bachelor’s degree or equivalent combination of education and experience, and five years of relevant experience.

Preferred Qualifications

Seven (7) or more years in enterprise application integration, middleware development, or ERP technical architecture.

Experience leading or managing a technical integration team in a complex, multi-system environment.

Proficiency in SQL/PL/SQL and at least one enterprise integration platform.

Boomi architecture and development experience: Boomi integration processes, Atoms (cloud and local), API Management, DataHub, and event services. Boomi Professional Developer or Architect certification preferred.

Experience with Azure API Management (APIM) and Azure API Center (APIC) for API gateway, lifecycle management, and catalog governance. Familiarity with PeopleSoft Integration Broker, Component Interface, and Application Engine in a migration/retrofit context.

Familiarity with Oracle Integration Cloud (OIC): REST/SOAP/File adapters, ERP Cloud adapter, FBDI/HDL file integrations, and OIC monitoring/error handling — relevant if Oracle Fusion is selected.

Familiarity with Workday integration tools: Studio, EIB, CoreConnectors, Cloud Connect, Orchestrate, PECI/PICO payroll connectors — relevant if Workday is selected.

Knowledge of FERPA, HIPAA, and UM System DCL1–4 data classification applied to integration data-in-motion.

Anticipated Hiring Range

Salary Range: $70,512 - $137,696 annually, commensurate with experience

Grade: GGS-12

University Title: ERP Pillar Lead

Internal applicants can determine their University title by accessing the Talent Profile tile in myHR.

Sponsorship Information

Employment visa sponsorship is not available for this position.

Benefit Eligibility

This position is eligible for University benefits. As part of your total compensation, the University offers a comprehensive benefits package, including medical, dental and vision plans, retirement, paid time off, short- and long-term disability, paid parental leave, paid caregiver leave, and educational fee discounts for all four UM System campuses. For additional information on University benefits, please visit the Faculty & Staff Benefits website at https://www.umsystem.edu/departments-staff/human-resources/benefits-retirement

Equal Employment Opportunity

The University of Missouri is an Equal Opportunity Employer.

To request ADA accommodations, please call the Director of Accessibility and ADA at 573-884-7278.