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.

This position is eligible for hybrid work within Iowa and will require a work arrangement form to be completed upon the start of your employment. Per policy, work arrangements will be reviewed annually, and must comply with the remote work program and related policies and employee travel policy when working at a remote location.  Specific details regarding the hybrid work schedule will be discussed during the interview process.

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: Analyze product, pricing, and purchasing data to support contract evaluation and purchasing decisions. Monitor contract pricing and item coverage, identify discrepancies and savings opportunities, and provide information to support negotiations led by supply chain product representatives and the Purchasing department. Follow established policies and guidelines for contract management and data accuracy.

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: Support accurate supply chain data and purchasing processes through system maintenance, reporting, and analysis. Provide data for bids and supplier proposals, help resolve purchasing discrepancies, and provide backup support for item master and EDI processes through cross-training.

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: Collaborate with vendors, supply chain product representatives, and the Purchasing department to obtain contract information, clarify pricing, and resolve discrepancies. Provide timely, accurate support to internal customers and vendors.

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: Improve data accuracy, reporting, and processes that support pricing agreements and contract management in PeopleSoft. Collaborate with internal teams to identify system issues and opportunities for improvement.

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: Support responsible spending through pricing validation, benchmarking, and contract analysis. Provide accurate data to help supply chain product representatives and the Purchasing department evaluate costs, identify savings opportunities, and ensure purchases reflect established pricing agreements.

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: Demonstrate professionalism, accountability, and a customer-focused approach when working with internal departments and external partners. Build effective working relationships and provide responsive support for pricing, contract, and purchasing needs.

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.