Responsible to manage analytics across the assigned service lines including category management. Works collaboratively with Pharmacy Value Added Teams (VATs) and Pharmacy & Supply Chain leadership to ensure maximum value in the acquisition of new technology, utilization management, supply standardization and maximizing GPO services and opportunities. The analyst prepares comprehensive Category Analytics summaries that aid the Pharmacy Team in determining the best approach to achieve financial savings and support the needs of the organization. Develops visual analytics and reporting tools using Tableau, SQL, Business Objects, etc. to capture business trends within Pharmacy Supply Chain and other areas as required. Responsible for analyzing cost data by collecting, monitoring and creating cost models to directionally guide Pharmacy supply chain contractual, equipment and supply saving decisions.  Actively tracks projected savings to actual savings post contractual award. Improves cost status by analyzing results; monitoring variances; identifying trends; recommending actions to Pharmacy Manager, Supply Chain Leadership and Strategic Sourcing.  Works closely with Supply Chain Analysts to ensure compliance with contract pricing and maximizes the use of informatics, benchmarking, and GPO membership resources.  

Essential Functions and Responsibilities of the Job

Data Analytics

1. Mines big data through the use of SQL, other available resources and utilizes in-depth understanding of data and data relationships.
2. Recommends actions by analyzing and interpreting data and making comparative analyses; study changes in product utilization, variability in supplier performance related to supplies and services.
3. Analyzes inventory productivity usage and product obsolescence and patterns.
4. Solves problems quickly, managing expectations, and communicating clearly.
5. Increases productivity by developing automated reporting/forecasting tools.
6. Recommend data-driven solutions to key stakeholders.
7. Test, validate, and implement system solutions in collaboration with System I.S. and Supply Chain across MemorialCare through design and enhancement of databases to support reporting.

Data Visualization

1. Turn abstract information into appealing, revealing and understandable visualizations that clearly explain the results of the analysis.
2. Challenges conventional thinking and uses data visualization in new and novel ways.
3. Applies the right Visual Analytics and Reporting capabilities to the right business problem.
4. Assists in the creation and maintenance of Pharmacy supply chain metrics and dashboard reports.

Cost Analysis

1. Assists with Pharmacy annual and quarterly addressable spend forecasting.
2. Identifies cost status by comparing and analyzing actual results with plans and forecasts.
3. Guides cost analysis process by establishing and enforcing policies and procedures; providing trends and forecasts; explaining processes and techniques; recommending actions.
4. Develops return on investment (“ROI”) analysis (total cost of ownership associated with supply contracts, equipment and services).
5. Conducts cost assessment of responses to Request for Proposals (“RFP”), Information or Quotations and Capital Equipment.
6. Performs cost analysis for product category or classification comparison.  Analyzes addressable organizational spend to identify fragmented patterns to inform Strategic Sourcing.
7. Performs lease/buy analysis for capital equipment.
8. Maintains professional knowledge of current trends, practices, and developments and growth through participation in educational programs, professional organizations and activities to maintain knowledge.

Process Improvement

1. Identifies process improvement and cost saving opportunities and communicates those to Manager, Supply Chain Operations and assists in implementation.

Business Process Adherence

1. Adheres to all established Supply Chain Management Enterprise Business Processes (EBPs) as defined and routinely audited.  Is responsible for seeking clarification of processes as necessary to ensure standard of work continuity.