Supply Chain Coordinator: Data Team, HSSB

The University of Iowa; Iowa City (IA); Hybrid; USD 43,000 - 53,000; Full time

Job summary

The University of Iowa Health Care Supply Chain Department seeks a Supply Chain Coordinator to manage vendor pricing agreements and GPO contracts in PeopleSoft. You will generate reports, validate pricing, and support contract management across multiple systems including Epic and Chargemaster.

This role emphasizes data accuracy, cross-functional collaboration with Purchasing, and continuous process improvement. A 1–3 year background in data analysis or contract administration is preferred.

Qualifications

• Bachelor's degree in Business Administration or related field.
• 1–3 years of experience in data analysis, contract administration or related field.
• Excellent written and verbal communication skills.
• Proficiency in Microsoft Office with emphasis on Excel for data analysis, comparison and reporting.
• Strong interpersonal skills and ability to build effective working relationships.

Responsibilities

• Create and maintain vendor pricing agreements and GPO contracts in PeopleSoft.
• Develop contract reports to support pricing accuracy and contract management.
• Collaborate with supply chain product representatives and Purchasing to resolve pricing discrepancies and improve processes.
• Work with PeopleSoft, Epic, and Chargemaster to maintain data integrity across databases.
• Cross-train for item master maintenance and EDI processes as needed.
• Generate and analyze reports for items on contract/not on contract and identify savings opportunities.
• Provide backup support for item creation, item attributes, and system interfaces.
• Support bids, supplier evaluations and purchasing recommendations with data analysis.

Skills

Data analysis

Excel

Communication

Interpersonal skills

MS Office

Education

Bachelor's degree in Business Administration or related field

Tools

PeopleSoft

Epic

Power BI

Excel

Job description

Supply Chain Coordinator: Data Team, HSSB

The University of Iowa Health Care Supply Chain Department is seeking a Supply Chain Coordinator. This position will be responsible for creating and maintaining vendor pricing agreements and Group Purchasing Organization (GPO) contracts in PeopleSoft. Develop contract reports to support pricing accuracy and contract management. Collaborate with supply chain product representatives and the Purchasing department to resolve pricing and contract discrepancies and improve related processes. Work with PeopleSoft, Epic, and Chargemaster teams to maintain data integrity and consistency across all databases. Cross-train to provide backup support for item master maintenance, including creating item part numbers and updating item attributes, and Electronic Data Interchange (EDI) processes as needed.

Support procurement and contract management:

Coordinate the setup and maintenance of vendor pricing agreements and GPO contracts in PeopleSoft. Support supply chain product representatives and the Purchasing department through contract reporting, pricing validation, benchmarking, and competitive analysis. Identify and resolve contract and pricing discrepancies to support accurate purchasing and effective use of available agreements.

• a. Generate and analyze contract reports to identify pricing discrepancies and opportunities to ensure eligible items are covered by vendor pricing agreements or GPO contracts.
• b. Create and maintain vendor pricing agreements and GPO contracts in PeopleSoft, and develop tools and processes to support contract accuracy and reporting.
• c. Assist supply chain product representatives and the Purchasing department in evaluating contract pricing through benchmarking and competitive analysis.
• d. Provide backup support for item master maintenance, including creating item part numbers and updating item attributes to maintain data accuracy across systems.
• e. Build and maintain effective working relationships with supply chain product representatives, the Purchasing department, vendors, and other internal partners.

Analyze Product Data and Support Contract Management:

• a. Generate and create reports for items on contract/not on contract and continually search for process improvement and ensure accurate data in our systems.
• b. Use all available product/company data sources to provide value suggestions to end users and effectively guide negotiations.
• c. Adhere to the conflict of interest policies.
• d. Use PeopleSoft/PowerBI to run reports, as requested and to review spend by commodity.
• e. Build tools and utilize Excel for analyzing data.
• f. Knowledge of summary functionality, sorting data, data comparison, report creation.

Support Supply Chain Systems and Purchasing Analysis:

• a. Provide backup support for item creation, item attribute updates, and related system interfaces to maintain data integrity across PeopleSoft, Epic, and Chargemaster databases.
• b. Maintain working knowledge of supply chain systems and how item, pricing, and contract data affect purchasing and inventory processes.
• c. Develop reports and tools to help identify and resolve receipt and invoice matching exceptions in collaboration with responsible departments.
• d. Provide relevant data and trend analysis to support bids, supplier evaluations, and purchasing recommendations.
• e. Assist with financial analysis of supplier contracts and proposals.
• f. Provide backup support for Electronic Data Interchange (EDI) processes, including identifying issues and coordinating resolution with appropriate teams.
• g. Communicate clearly and professionally with internal partners and vendors, respond to questions accurately and promptly, and select appropriate communication methods based on the issue.

Vendor and Customer Relations:

• a. Review vendor pricing and contract data to identify discrepancies and support vendor performance evaluations.
• b. Support competitive contract negotiations through data analysis and coordinate resolution of pricing and contract concerns.
• c. Coordinate communication and follow-up among vendors, supply chain product representatives, and the Purchasing department.
• d. Provide responsive, professional customer service to departmental customers and vendors.

Data Management and Systems Support:

• a. Analyze pricing, contract, and purchasing data to identify potential cost savings and process improvements.
• b. Combine data across departments and systems to identify opportunities for product and contract standardization.
• c. Use system queries to develop reports and tools that help resolve end user issues and support purchasing decisions.
• d. Provide backup support for item master maintenance and EDI processes, coordinating with appropriate teams to resolve data and system issues.

Fiscal Responsibility:

• a. Develop reports to help supply chain product representatives and the Purchasing department evaluate pricing and identify savings opportunities.
• b. Conduct benchmarking analyses using available internal and external data sources.
• c. Identify and investigate pricing discrepancies and coordinate corrections with appropriate teams and vendors.

Professionalism and Customer Service:

• a. Partner with hospital customers to understand current and future needs and coordinate appropriate support.
• b. Provide guidance to supply chain end users on pricing agreements, contract information, and related processes.
• c. Communicate clearly and respectfully, follow through on commitments, and coordinate resolution of customer concerns.
• d. Use Outlook email and calendar tools effectively and respond to emails and meeting requests in a timely manner.
• e. Perform other duties as assigned.

Education Requirements

A Bachelor's degree in Business Administration or related field or an equivalent combination of education and experience is required.

Experience Requirements

1–3 years of experience in data analysis, contract administration, or a related field preferred. Supply chain experience is beneficial but not required.

Excellent written and verbal communication skills.

Proficiency in Microsoft Office, with an emphasis on Excel for data analysis, comparison, and reporting.

Strong interpersonal skills and the ability to build effective working relationships with team members, hospital departments, supply chain product representatives, Purchasing staff, and vendors.

Desired Qualifications

Knowledge of University policies, procedures, and regulations.

Strong collaboration skills and experience working across teams to resolve issues and improve processes.

Knowledge of supply chain management and operational improvement in a hospital setting.

Experience developing data tools, reports, or analyses to support contract management and end users.

Experience using Power BI for reporting and data analysis.

Experience with PeopleSoft and/or Epic.

Experience working with databases, including querying, maintaining, and validating data.

Successful candidates will be required to self-disclose any conviction historyand will be subject to a criminal background check and credential/education verification.

Additional Information

• Classification Title: Supply Chain Coordinator
• Appointment Type: Professional and Scientific
• Schedule: Full-time
• Work Modality Options: Hybrid within Iowa

Compensation

• Starting Salary Minimum: 47,858
• Starting Salary Maximum: Commensurate

Contact Information

• Contact Name: Jonathan Wiley
• Contact Email: [e-mail]

Equal opportunity employer

The University of Iowa is an equal opportunity employer. All qualified applicants are encouraged to apply and will receive consideration for employment free from discrimination on the basis of race, creed, color, religion, national origin, age, sex, pregnancy (including childbirth and related conditions), disability, genetic information, status as a U.S. veteran, service in the U.S. military, sexual orientation, or associational preferences.

Persons with disabilities who need assistance or accommodations with the application or interview process may contact University Human Resources/Faculty and Staff Disability Services, [phone] or [e-mail] . For jobs in UI Health care, please contact UI Health care Leave & Disability Administration at 319-356-7543 .

Additional questions, please reach out to Jonathan Wiley at [e-mail]