Supply Chain Coordinator Data Analytics Team

The University of Iowa Health Care Supply Chain Department is seeking a Supply Chain Coordinator to utilize various data software to support supply chain initiatives. Provide value analysis and ongoing metrics to end users. Resolve enduser issues. Generate reports for key departmental areas. Maintain and provide analysis of item master. Item updates within Epic and PeopleSoft. Other duties as assigned.

Duties will include:

Procure and deliver goods and services: Coordinate the daytoday operation of a retail or nonretail operation and/or may assist college/divisions departments and units in evaluation negotiation and procurement of goods and services. Responsibilities may include sales controllable expenses cash management and merchandising identification of supply options inventory control loss prevention and store appearance. Make recommendations on what and where to buy product and/or service.

• • Generate reports for contracts and make suggestions on ensuring items are on contract.
  • Create data tools and processes in regards to contract management.
  • Assist product representatives in attaining ideal contract pricing by providing benchmarking and competitive analysis.
  • Maintain item master.
  • Develop strong customer based relationships.

Research Products; Prepare Product/Equipment Specifications and Contract Management: Perform product research and utilization analysis. Prepare product or equipment specifications. Make recommendations and procure product or service and prepare product or equipment specifications. Assist with the implementation of policies. Monitor contracts. Support product negotiations contract pricing and terms and conditions within established guidelines on behalf of unit dept. and/or organization.

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

Inventory Management and Marketing: Oversee inventory controls; determine reorder amounts. Manage merchandise assortment and new production information. Analyze sales trends and make recommendations to optimize sales utilizing merchandising strategies.

• • Receive inventory return and account for vendor tray/instrumentation usage.
  • Make software interface item updates.
  • Knowledge of inventory management software.
  • Create data tools to monitor and resolve receipt and match exceptions.
  • Marketing: Assist in new bid process by providing relevant data sets and information. Analyze trends and make recommendations.
  • Assist with financial analysis of supplier contracts and proposals.
  • Communicate professionally proficiently clearly and influentially verbally and in writing with customers.
  • Answer questions accurately and timely.
  • Understand appropriate use of email versus live communication.

Vendor and Customer Relations: Interact with vendors/suppliers to determine product selection and negotiate terms of the purchase. Resolve customer concerns.

• • Analyze vendor performance.
  • Facilitate competitive contract negotiation and resolve disputes.
  • Enable vendor/end user interactions and follow up.
  • Maintain excellent customer service with departmental customers and vendors.

Data Management or Data Systems Development: Assess and enhance production software support for inventory management.

• • Analyze inventory systems and suggest potential cost savings opportunities.
  • Create multidepartment data sets to suggest opportunity for standardization.
  • Generate data sets using system queries to provide tools/reports to resolve end user issues.

Fiscal Responsibility: Determine inventory investments; administer the budget recommend operational policies and procedures. May assist in budget development and provide projects and recommendations.

• • Build data reports to assist Product Representatives in achieving best possible pricing.
  • Create benchmarking analyses utilizing various data software.
  • Develop data sets to locate/resolve pricing discrepancies.

Leadership/Supervision: May provide functional and/or administrative supervision of staff. Provide direction assignments feedback coaching and counseling to assure outcomes are achieved.

• • Consult and partner with hospital customers to discuss evaluate and plan for current and future needs.
  • Provide training to hospital supply end users on procurement process.
  • May provide functional and/or administrative supervision of staff.
  • All other duties as assigned.
  • Full understanding and utilization of Outlook email and calendar system. (See employee manual)
  • Respond to emails and meeting requests appropriately and timely.

University of Iowa Health Carerecognized as one of the best hospitals in the United Statesis Iowas only comprehensive academic medical center and a regional referral center. Each day more than 12000 employees students and volunteers work together to provide safe quality health care and excellent service for our patients. Simply stated our mission is: Changing Medicine. Changing Lives.

Percent of Time:100

Schedule: Monday Friday 8:00am 4:30pm

Pay Grade: 3B Highlights:

• Regular salaried position located in Iowa City Iowa
• Fringe benefit package including paid vacation; sick leave; health dental life and disability insurance options; and generous employer contributions into retirement plans