Business Intelligence 340B - Data Analyst II

Job Description Summary

The 340B Data analytics and reporting analyst conducts complex analyses and reporting solutions to support the 340B Program decision making. Leveraging data from different platforms, the 340B data analytics and reporting analyst is responsible for normalizing, aggregating, and reporting pharmacy, financial, and prescribing data to support the 340B team and other stakeholders throughout the organization.

Entity

Medical University Hospital Authority (MUHA)

Worker Type

Employee

Worker Sub-Type​

Regular

Cost Center

CC005026 CHS - 340B Oversight

Pay Rate Type

Salary

Pay Grade

Health-27

Scheduled Weekly Hours

40

Work Shift

Day (United States of America)

Job Description

• Role and 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 to the 340B Program.
• Validate 340B prices for related programs and internal processes.
• Improve and automate current manual processes to increase accuracy, productivity and reduce errors for 340B related processes when needed.
• Develop and maintain technical processes for management and optimization of the 340B program.
• Performs detailed project gap analyses between current and future state of 340B 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 related audits.
• Create and maintain related standard operating procedures.
• Apply analytical processes to evaluate large 340B 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 pharmacy utilization.
• Convert data analysis results into clear and compelling narratives to inform and educate other departments including finance.
• Assist with quarterly 340B compliance 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.
• Represent the hospital at internal and external professional meetings
• 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.
• Familiar with data contained and required on Medicare Cost Report, Trial Balance and OPAIS.

Additional Job Description

Requirements:

• Bachelor’s degree in related field and / or high competency level and significant experience with pharmacy information systems or 340B compliance / operations work
• Advanced knowledge and use of Excel.

Preferred:

Experience working with Epic and multiple EMR 340B split-billing software (e.g., MacroHelix, Wellpartner, Verity, Walgreens). 340B Apexus Certified Expert (ACE)

• Advanced skills in data aggregation, cleaning, and analysis.  Demonstrated ability to create, maintain, and query large data sets to create concise executive management reports and guidance.
• Excellent organizational skills and demonstrated ability to work independently.
• Must possess strong communication and written skills.
• Ability to create and maintain relationships with multiple business partners and stakeholders.
• Minimum of 3+ years applicable work experience with managing large data sets
• 
   

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