ERP Integrations Lead

Position Summary

Hello, we’re Metro ! Metro is dedicated to shaping a better future for the greater Portland region. The work the people of Metro do every day benefits the lives of the people who live here, today, and tomorrow.

The IT Department is looking for an Integrations Lead to support Metros transition to Workday as its new Enterprise Resource Planning (ERP) platform. This position will play a critical role in designing, building, testing, and supporting approximately 50 + identified system integrations between the new ERP platform and Metro’s existing business systems.

Working closely with implementation partners, internal IT staff, and business stakeholders, the Integrations Lead will analyze integration requirements, coordinate technical design, support development and testing activities, and help ensure that data flows between systems are accurate, reliable, and aligned with business needs. This role is essential to maintain operational continuity and data integrity throughout Metro’s ERP replacement, modernization initiative, and smooth ongoing operation post launch.

As the ERP Integrations Lead you will:

ERP Integration Design & Support

• Serve as the primary technical point of contact for ERP-related system integrations.

• Work with implementation partners to design, build, and test integrations between the ERP system and Metro’s internal and external applications.

• Support the build of approximately 50+ identified integrations, ensuring they meet business, technical, and data quality requirements.

• Analyze integration requirements and translate business needs into technical specifications.

• Post implementation, manage data mapping, transformation, and validation processes across inbound and outbound integrations ensuring accuracy, consistency, and compliance.

• On going work leading end-to-end integration design, development, and maintain complex, enterprise-grade Workday integrations using Workday Studio, alongside Core Connectors, EIBs, Prism, and Workday Web Services (REST/SOAP APIs).

Systems Analysis & Problem Solving

• Evaluate complex business processes and data flows to support effective integration design.

• Lead investigations to detect, analyze, and resolve integration issues, data discrepancies, and system errors.

• Rewrite, modify, or redesign integration components to correct problems and improve performance.

Data & Interface Management

• Support data mapping, transformation, and validation activities.

• Create detailed data mapping documents that define how data elements translate between source and target systems.

• Work with database structures, files, and data models to ensure accurate data exchange between systems.

• Partner with Report Strategist to design, build, and manage complex data flows to PRISM tool by blending Workday and external data, ensuring data integrity, optimizing performance, and providing strategic insights for HR/Finance.

• Assist in defining, developing, analyzing, and modifying data structures as needed to support integrations.

Partner & Stakeholder Coordination

• Partner with ERP implementation vendors and technical consultants to coordinate integration work.

• Work with business users and IT staff to gather requirements, validate solutions, and schedule integration activities.

• Translate business requirements into actionable integration plans.

• Coordinate dependency mapping across different workstreams.

• Participate in meetings, design sessions, and testing cycles related to ERP integrations.

Testing, Documentation & User Support

• Support integration testing, user acceptance testing, and issue resolution.

• Develop and maintain technical documentation related to integrations, data flows, processes, procedures and system interfaces

• Support vendor and third-party relationships related to Workday integrations and enterprise systems.

• Provide guidance and technical support to staff and stakeholders.

• Provide individual and group instruction as needed related to system interfaces and data flows gathering feedback for improvements

Project & Organizational Support

• Participate in large-scale ERP implementation and modernization projects.

• Support Workday biannual releases, including impact analysis, testing, validation, and post-release support.

• Provide guidance and coaching to less experienced staff as needed.

• Lead, mentor, and collaborate with Metro Integration team fostering a culture of innovation, accountability, and continuous improvement.

• Perform other duties as assigned.

Attributes for success, Knowledge, Skills and Abilities

• Knowledge of and ability to work in a variety of operating environments.

• Knowledge of system integration concepts, data exchange methods, and interface design.

• Skill in detecting and correcting complex system and data issues.

• Passionate about evaluating complex business practices to establish systems design and implementation.

• Ability to analyze and modify data structures to support application and integration requirements.

• Adept at working effectively with software developers, business analysts, data architects, security teams, and business stakeholders.

• Ability to research system problems and apply appropriate fixes such as program changes, data updates, or configuration changes.

• Skilled at translating complex technical concepts into accessible language for diverse audiences

• Ability to provide individual and group instruction on complex application concepts.

• Ability to participate in and support large-scale projects.

• Passionate to continue learning, be involved with professional networks, and experiment with emerging tools and approaches.

• Enjoys collaboration and building working relationships with staff, managers, vendors, and supported departments.

• Ability to maintain confidentiality.

DIVERSITY AND INCLUSION

At Metro, we strive to cultivate diversity, advance equity, and practice inclusion in all of its work. This means attracting and empowering a workforce that is inclusive of a broad range of human qualities. Workplace diversity is both a moral imperative and a business strength, essential to providing quality support and services to our region. Metro’s goal is to hire, develop and retain highly skilled and talented individuals across all departments and programs who best reflect the diversity of our community.

Learn more about Metro’s Diversity Action Plan

TO QUALIFY

We will consider any combination of relevant work experience, volunteering, education, and transferable skills as qualifying unless an item or section is labeled required. Please be clear and specific in your application materials on how your background is relevant.

Minimum qualifications

• 4-6 years of related professional experience in information systems, business intelligence, or data analytics, and

• Bachelor’s degree, or

• Any combination of education, professional, volunteer and lived experience that provides the necessary knowledge, skills, and abilities to perform the classification duties and responsibilities.

If this statement is true for you, then you may be ineligible to apply

If you were terminated for cause during any employment with Metro, or resigned in lieu of termination, you may be ineligible for rehire for a minimum of 3 years.

Hybrid Telework

This position is based at the Metro Regional Center (MRC) and is expected to work onsite at MRC as well as at Metro’s external venues throughout the Portland metropolitan area. Due to the high level of collaboration and system activity associated with Metro’s ERP replacement and modernization efforts, this role will require frequent onsite presence over the next 18 months.

This position is designated as “hybrid telework.” You will be required to work onsite and at times have the option to work away from your assigned work location. The specific schedule and balance of onsite and telework will be discussed with the hiring manager at the time of offer. Employees must reside in Oregon or Washington to work at Metro. Please note, the designation of hybrid telework may be subject to change at a future time.

Like to have qualifications

You do not need to have the following preferred qualifications/transferable skills to qualify. However, keep in mind we may consider them when identifying the most qualified candidates. Your transferable skills are any skills you have gained through education, work experience, including the military, or life experience that are relevant for this position.

• Strong experience with flat file integrations (CSV, TXT, TBL, LIS, and Excel based file formats)

• Experience with automated and scheduling integrations

• Experience with EDI integrations

• Previous experience with PeopleSoft or Workday

• ERP integration experience supporting inbound and outbound interfaces between ERP systems and external/ internal applications.

• Data Mapping and transformation experience

• Strong troubleshooting skills

SCREENING AND EVALUATION

The application packet: The application packet consists of the following required documents. Please ensure that you upload these documents in your online application. Make sure your application is complete, missing any part of these items could result in an incomplete application and will not be moved forward in the recruitment.

• A completed resume that includes the details for each employer

  • Name of employer, working title

  • Dates of employment; including if the work was full-time or part-time your title,

  • Number of employees supervised

  • Summary of your responsibilities

• Responses to supplemental questions

The selection process: We expect to evaluate candidates for this recruitment as follows. The selection process is subject to change.

• Initial review of minimum qualifications

• In-depth evaluation of application materials to identify the most qualified candidates

• Consideration of top candidates/interviews

• Testing/assessments

• Reference check

• Background records check for finalist candidate

COMPENSATION, BENEFITS AND REPRESENTATON

The full-salary range for this position is step 1: $91,400.94 to step 7: $122,515.70. However, unless a candidate’s qualifications justify, based on the Oregon Pay Equity Act requirements and Metro’s internal equity review process, the appointment will likely be made between step 1: $91,400.94 to the equity range step 4: $105,815.81.

This position is not eligible for overtime and is represented by AFSCME 3580. It is classified as a Systems Analyst III position.

Classification descriptions are typically written broadly and do not include the specific duties and responsibilities of the positions. View the classification description.

Questions?

Recruiter: Carrie Gundermann

Email: [email protected]

Additional Information

Equal employment opportunity

All qualified persons will be considered for employment without regard to race, color, religion, sex, national origin, age, marital status, familial status, gender identity and expression, sexual orientation, disability for which a reasonable accommodation can be made, or any other status protected by law.

Accommodation

Metro will gladly provide a reasonable accommodation to anyone whose specific disability prevents them from completing this application or participating in this recruitment process. Please contact the recruiter outlined in the job announcement in advance to request assistance.

Veterans' preference

Under Oregon Law, qualified veterans may be eligible for veterans' preference when applying for Metro positions. If you are a veteran and would like to be considered for a veterans' preference for this job, please provide qualifying documents as instructed during the application process.

Hybrid Telework

Positions designated as “hybrid telework,” meaning you will have the option to work away from the office, although there may be times that coming into the office will be required. The designation of Hybrid Telework may be subject to change at a future time. All employees must reside in Oregon or Washington; Metro cannot support ongoing telework from other locations.

Pay equity at Metro

No matter who you are or where you work at Metro, you deserve to be paid fairly for the work you do. Every worker must get equal pay for equal work regardless of your gender, race, age, or other protected characteristics. Metro has established processes and conducts routine pay equity reviews as part of the hiring process to ensure compliance with the 2017 Oregon Pay Equity Act.

Online applications

Metro accepts job applications online. If you need assistance or accommodation with your application, or access to a computer, please contact the recruiter outlined in the job announcement in advance to request assistance.

How to Apply

For tips on how to apply and more information on what the application process looks like, visit Metro’s “How to apply” page.

Government Jobs

For assistance with your account or to reset your password please visit GovernmentJobs "Help and Support" page.

Metro

Led by an elected council, this unique government gives all residents of greater Portland a voice in shaping the future and provides parks, venues, services, and tools at a regional scale. We find solutions for our area’s garbage and recycling that protect clean air and water; help plan land use and development to provide jobs and safe transportation; manage local venues that provide a connection to arts and culture and help keep the economy growing; protect 17,000 acres of parks and natural areas, and run the Oregon Zoo, to keep nature close to home.

As part of the Metro family, you play a vital role in serving the people of the greater Portland region.


Family members, including eligible spouses, domestic partners, and children, are covered under most of our benefits programs. Benefits vary depending on position and full-time, part-time, and variable hour status.


This is a budgeted, regular status position with a full-time schedule. The position is eligible for these benefits:

• Medical, dental and vision health insurance
• Paid sick leave
• Paid vacation, holiday, and other leave
• Paid parental leave
• Full contribution to Oregon PERS retirement
• No-cost TriMet Hop Pass
• Employee Assistance Program
• Training opportunities
• Flexible schedules depending on position and department
• Hybrid/Telework living in Oregon /Washington depending on position and department

Metro also offers a variety of perks for all employees, including free admission to the Oregon Zoo (including ZooLights!), Oxbow and Blue Lake Regional Parks, membership discount at Lloyd Athletic Club, credit union eligibility and more. Employees also receive access to financial wellness and legal consultation services, as well as first-time home buying and ownership counseling.


Learn more about employee benefits.


Some positions are represented by a union and have additional benefits.
View union contracts here.