Pharmacy Data Analyst

Lockton • Kansas City, MO

1d

About The Position

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.

Requirements

• A Bachelor’s Degree in a business-related field or equivalent experience in the insurance industry
• A minimum of 1-2 years’ experience in the insurance industry, specifically in employee welfare benefits or pharmacy data analytics
• Demonstrate advance knowledge of PowerPoint, Word, and Excel
• Strong verbal and interpersonal communication skills
• Strong customer service skills, with the ability to develop strong client relationships with multiple clients
• Ability to interact with vendors effectively
• Excellent organizational and communication skills
• Motivated self-starter who is also able to work well on a team
• Legal right to work in the United States

Nice To Haves

• Knowledge of the Pharmacy Benefit Management (PBM) industry preferred

Responsibilities

• 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

Benefits

• health, vision and dental coverage, which begins on your first day of work
• 401(k) with match and immediate vesting
• a competitive vacation plan

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level