Senior Supply Chain Analyst -Pharmacy Procurement Operations Full Time Days

Northwestern Memorial Healthcare•Grayslake, IL

32d•$43 - $56•Onsite

About The Position

The Senior Supply Chain Analyst reflects the mission, vision, and values of Northwestern Medicine (NM), adheres to the organization's 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 data-driven 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 cross-departmental 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 sub-committees.

Requirements

Master's 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 multi-tasking 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 team-based environment, contributing ideas, participating in team decisions, and achieving team outcomes
Ability to be flexible and adaptable in a rapidly changing environment

Nice To Haves

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

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 cost-saving opportunities.
Partner with Strategic Sourcing, Value Analysis, and Contracting Services teams by creating ad-hoc vendor-specific, 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 non-financial 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.