The Senior Supply Chain Analyst reflects the mission vision and values of Northwestern Medicine (NM) adheres to the organizations Code of Ethics and Corporate Compliance Program and complies with all relevant policies procedures guidelines and all other regulatory and accreditation standards.
The Senior Supply Chain Analyst will work as an integral member of the Supply Chain Management team to analyze and present product utilization data and associated financial data create and deliver customized departmental status reports as well as perform other tasks to enable NM to make datadriven decisions regarding product and services utilization. Responsibilities include formulating and executing the necessary analytical plans to support the use of data analysis to improve strategic sourcing and value analysis projects.
This role will be the functional expert in determining the best methods to obtain the necessary data and to determine how it should be analyzed in order to support the achievement of the organizations savings goals in an efficient and timely manner. Experience and skills in data extraction analysis report development as well as the development and delivery of presentations is critical. This includes the necessary crossdepartmental coordination to ensure that the data required from other departments is consistent with our standards/requirements.
The NM Sourcing and Contracting departmental mission is to ensure the preservation and improvement of the quality of patient care while reducing costs and risks related to the procurement and the use of products and services at all NM business units and facilities through collaborative efforts and effective communication by a mode of service line steering teams and specialty subcommittees.
Responsibilities:
- Compile and analyze reports to identify opportunities for cost savings improved supply utilization standardization and process improvement; evaluate findings and make recommendations to leadership.
- Identify potential cost savings opportunities for products currently in use through review and analysis of group purchasing contracts and market data.
- Design and development of metrics dashboards and reports for all Supply Chain areas that measure performance and drive efficiencies and costsaving opportunities.
- Partner with Strategic Sourcing Value Analysis and Contracting Services teams by creating adhoc vendorspecific competitor and industry reports throughout the vendor negotiation process.
- Work with clinical managers and Strategic Sourcing Managers to track compliance with supply utilization protocols for high dollar specialty items i.e. knee & hip implants spine implants and cardiac pacemakers.
- Review and/or support the maintenance of the PeopleSoft master item file and approve item additions/deletions to ensure they are current.
- Test and audit contract performance to ensure that accurate pricing data is maintained in Vendor Purchasing and patient billing systems.
- Identify via audit process opportunities to recover payments based on inconsistencies in pricing or other nonfinancial terms (e.g. shipping fees restocking fees).
- Assist in the development of systems policies and procedures for the effective management and control of supply expenditures.
- Gather data and conduct analyses to prepare Request for Proposal and Competitive Market Assessment documents including PeopleSoft usage data and vendor information. Analyze vendor responses and prepare summary documents for use during vendor negotiations and contract award.
- Gather data and conduct analysis to review utilization of new products.
- Review and verify detail of analyses by the NMHC designated Group Purchasing Organization (GPO) and prepare recommendations for further action.
- Prepare financial indicator reports for review by physicians and clinical management including detailed analysis of utilization and trends by procedure and physician. Work with NM Finance to review utilization data where appropriate.
- Coordinates the flow of information between appropriate parties to accomplish customers and supply management objectives.
- Act as a change agent and lead/drive process improvement initiatives that are enabled by technologies throughout NM. This entails creative thinking strategic vision and leadership to translate various business/process/data requirements into effective and efficient applications with supporting processes.
- Evaluate NMHCs existing supply chain processes using (amongst others) interviews document analysis surveys business process descriptions cases scenarios process maps task and workflow analysis; develop and present any necessary improvements or modifications.
- Serve as subject matter expert auxiliary on Supply Chain solutions such as Spend Analytics and Business Intelligence tools.
- In cooperation with Strategic Sourcing Managers and Contracting Services communicate new technologies to be incorporated into new and existing contracts.
Qualifications :
Required:
- Masters degree in Supply Chain Management Business Administration Industrial Engineering Finance Accounting or other relevant discipline
- 3 years experience in a role analyzing and/or reporting data in a Supply Chain Management Finance or Clinical area
- Demonstrated expertise in Microsoft PowerPoint Access and Excel (including formulas pivot tables Macros/VBA)
- Demonstrated competency with PeopleSoft ERP Supply Chain modules
- Demonstrated competency in using SQL for data extraction manipulation and reporting
- Demonstrated competency in using Tableau or similar data visualization tools
- Demonstrated competency in lean business process improvement statistical process control workflow design and project management
- Effective problem solving critical thinking and multitasking skills
- Ability to communicate complex quantitative analysis in a clear precise and actionable manner
- Excellent verbal and written communication skills
- Ability to work in a collaborative teambased environment contributing ideas participating in team decisions and achieving team outcomes
- Ability to be flexible and adaptable in a rapidly changing environment
Preferred:
- Ability to think strategically and provide actionable insights for senior management
- Ability to manage upwards
- Lean Six Sigma Green or Black Belt Certificate
- Demonstrated ability to proactively assist customers with their immediate and long term needs
Additional Information :
Northwestern Medicine is an affirmative action/equal opportunity employer and does not discriminate in hiring or employment on the basis of age sex race color religion national origin gender identity veteran status disability sexual orientation or any other protected status.
Remote Work :
No
Employment Type :
Fulltime