Business Intelligence: Data and Reporting Analyst

Job Description Summary 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 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. Additional Job Description Education: Bachelors Degree or equivalent Work Experience: 4-6 years Must have at least 2 years of experience using SQL and Microsoft Office If you like working with energetic enthusiastic individuals, you will enjoy your career with us! The Medical University of South Carolina is an Equal Opportunity Employer. MUSC does not discriminate on the basis of race, color, religion or belief, age, sex, national origin, gender identity, sexual orientation, disability, protected veteran status, family or parental status, or any other status protected by state laws and/or federal regulations. All qualified applicants are encouraged to apply and will receive consideration for employment based upon applicable qualifications, merit and business need. Medical University of South Carolina participates in the federal E-Verify program to confirm the identity and employment authorization of all newly hired employees. For further information about the E-Verify program, please click here: http://www.uscis.gov/e-verify/employees