Business Intelligence: Data and Reporting Analyst

Medical University of South Carolina

About The Position

The Data Analyst III reports to the Director of Business and Finance in support of MUSC’s academic, research and healthcare missions. Under direct supervision, the Data Analyst III provides a variety of operational, consultative and collaborative functions within the Information Solutions for MUSC Pharmacy System. This position assists with the development, implementation and maintenance of the analytics program supporting decision making, strategy, performance improvement, and other key operational goals through valid, relevant, and quality decision support reports, dashboards, and other analytic tools. Provides proactive and reactive support while maintaining a professional attitude and exhibiting excellent customer service skills. Participates in team and project meetings and provides input on intelligent solutions to improve efficiency. Entity Medical University Hospital Authority (MUHA) Worker Type Employee Worker Sub-Type Regular Cost Center CC005203 SYS - 340B Administration Pay Rate Type Salary Pay Grade Health-28 Scheduled Weekly Hours 40 Work Shift Job Description

Requirements

Bachelors Degree or equivalent
4-6 years
Must have at least 2 years of experience using SQL and Microsoft Office

Responsibilities

Compile, standardize, aggregate, and analyze data to develop strategies for process enhancements and program modifications.
Develop and build predictive models and databases as needed for program maintenance and analysis.
Process, clean and verify the integrity of the data used for analysis.
Identify and analyze risk as it pertains to program compliance and financial trends.
Analyze monthly, quarterly and annual trends to identify and investigate irregularities or variances in prescribing, compliance, financial and other identified metrics related across system pharmacy.
Validate 340B prices, supply chain contracts, and cost savings initiatives for related programs and internal processes.
Improve and automate current manual processes to increase accuracy, productivity and reduce errors for all related processes when needed.
Develop and maintain technical processes for management and optimization of pharmacy programs.
Performs detailed project gap analyses between current and future state of pharmacy systems and provides input to shape project plans that meet future state goals.
Create and distribute “scorecards” in key areas to member hospitals and system leadership, focusing on key areas of compliance and financial performance.
Assist and assess data submission request for 340B and other pharmacy related audits.
Create and maintain related standard operating procedures.
Apply analytical processes to evaluate large 340B and other data sets to provide actionable insights and drive decision making for senior executives.
Maintain and report monthly program dashboards for key metrics such as 340B prescription capture, financial savings, reconciliation, and contract pricing utilization.
Convert data analysis results in clear and compelling narratives to inform and educate other departments including finance and supply chain.
Assist with quarterly financial risk assessments for executive management and board committees to identify areas of potential exposure.
Keep abreast of 340B landscape to better contextualize 340B data and understand organization implications.
Respond to departmental analytical requests as it relates to pharmacy data and reporting solutions.
Collaborate with other departments to support cross-organizational projects and assist with quality improvement.