Pharmacy Data Analyst

The Pharmacy Data Analyst will help the operation of Pharmacy Services run more effectively and efficiently through analyzing data from multiple sources (e.g., Express Scripts, Databytes, Ipro) as well as extract trends and business insights to improve health and financial outcomes of The Health Plan's population. The Pharmacy Data Analyst will also assist the unit with the plan benefit management and coding of multiple lines of business (Commercial, Exchange, Medicaid, and Medicare) within the pharmacy benefit adjudication platform.

Required:

1. Must possess a bachelor’s or master’s degree related to data analytics or at least one year experience in pharmacy and medical claim data reporting.
2. Proficient Microsoft Excel skills, including pivot tables, graphing, and complex formulas.
3. Experience in data collection, analysis, and visualization methods.
4. Must possess a working knowledge of quality improvement principles, theory, study design and statistical modeling.
5. Flexible and able to multi-task, work in a fast-paced environment and adapt to changing processes.
6. Self-motivated and goal oriented.
7. Ability to work effectively as part of a team and independently.
8. Proficient keyboarding skills and computer literacy with the ability to navigate through multiple systems.
9. Ability to exercise independent and sound judgment in decision making, utilizing all relevant information and data.

Desired:

1. Excellent oral, written, telephonic and interpersonal skills, balancing an independent and team working environment.
2. Working knowledge of the PBM industry and pharmacy benefit claims.
3. Certified Pharmacy Technician (CPhT)
4. Experience creating automated reports, self-service tools and integrating multiple data inputs into a single dashboard (PowerBI).
5. Skilled with mathematic problem solving and graphing.
6. Intermediate to proficient skills working with SQL to extract data.
7. Previous experience working in PBM environment, health plan, or managed care service organization.

Responsibilities:

1. Integrate data from multiple sources to produce requested or required data elements which support continuous quality improvement leading to actionable information.
2. Assist pharmacy team members with complex, detailed data needed projects.
3. Interpret, analyze, and provide recommendations regarding data accuracy and data collection needs and processes.
4. Research and identify data quality issues and work with internal and external partners to create a resolution.
5. Work with business unit(s) to identify opportunities to enhance existing processes and to develop new data information processes and tools. Continuously assess and improve data collection and reporting processes.
6. Interfacing with, gathering information from, and preparing data for presentations to various levels of management, committees, internal and external.
7. Work with designated department to assess, define, and develop report deliverables to meet internal and customer requirements.
8. Reconcile daily eligibility file report with PBM and ensure that the eligibility reporting procedure aligns with HEDIS measures.
9. Understand and calculate client drug price guarantees, admin fees, rebates and other terms related to pharmacy client and vendor contracts.
10. Review files received for PBM compliance with data needs, assist with the development of reports, testing files and configuring data in mapping tool.
11. Create and maintain the pharmacy executive management funds dashboard (drug spends, rebates, savings, PMF, etc.)
12. Assist with auditing the PBM plan benefit coding and plan materials to ensure pharmacy benefits reflect the intent and/or client expectations.
13. Assist in submitting and updating benefit material for internal and external teams, such as customer service applications.
14. Assist with creating and recording impact reports from internal audit findings and work with PBM for solutions via corrective action plan.