Pharmacy Data Analyst

Description - External

Our ideal candidate will demonstrate professionalism, organizational strength, and the ability to thrive in a fast-paced environment while adapting to changing priorities. This role is critical in ensuring our data processes run smoothly and client deliverables are met in a timely fashion so that Operations and Consulting teams can deliver timely, high-quality insights to clients.

• Produce and quality check monthly and quarterly report books for clients from our internal pharmacy data warehouse

• Review data for reasonableness, and validate data against key performance indicators collected from the Pharmacy Benefit Manager vendor (PBM)

• Learn to perform pharmacy pricing guarantee reconciliations for clients on both a quarterly and annual basis

• Learn to navigate Lockton's internal pharmacy data warehouse and reporting. Pull routine and ad hoc reporting from the data warehouse as requested by consulting team

• Develop financial models and reports for clients and account executive/consultants, provide interpretation and implication of analysis, as well as recommendations

• Oversee the servicing of a designated book or partial book of business as relating to marketing, claims, reporting and administration

• Track day-to-day issues related to clients' pharmacy plans and assist team members in closing out open items

• Build and maintain internal and external timelines for projects such as RFPs, renewals, reporting, and other projects

• Learn to interpret clients' current contract terms, pharmacy programs and identify/recommend gaps, alternatives, additional plan design changes, etc. and maintain contract terms in database.

• Assist in developing an implementation plan with client and help consulting teams on client deliverables

• Assist in the review of all agreements and/or documents related to best in class terms/provisions

• Help with upkeep of client CRM with all relevant client information.

• Work with internal data operations team to maintain client data quality.

• Other responsibilities as assigned and/or needed