Pharmacy Data Analyst

Lockton Companies; Plano (TX); On-site; USD 50,000 - 70,000; Full time

Benefits offered by this job

Health, vision, and dental coverage

401(k) with match

Competitive vacation plan

Job summary

Lockton Companies in Plano, Texas is seeking an individual to handle pharmacy data analytics and ensure the accuracy of client reports. The ideal candidate requires a Bachelor’s Degree and 1-2 years’ experience in the insurance industry, especially in employee welfare benefits.

Responsibilities include producing reports, validating data KPIs, and managing client relationships, along with a competitive benefits package.

Qualifications

• 1-2 years of experience in the insurance industry, especially in employee welfare benefits.
• Strong organizational and interpersonal skills.
• Ability to develop strong client relationships.

Responsibilities

• Produce and quality check monthly and quarterly report books for clients.
• Review data for reasonableness and validate against KPIs.
• Perform pharmacy pricing guarantee reconciliations.

Skills

Pharmacy Benefit Manager knowledge

Data analytics

Customer service skills

Verbal communication skills

Excel proficiency

Organizational skills

Education

Bachelor’s Degree in a business-related field

Tools

PowerPoint

Word

Excel

Job description

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).
• Perform pharmacy pricing guarantee reconciliations for clients on both a quarterly and annual basis.
• Navigate Lockton’s internal pharmacy data warehouse and reporting, pulling routine and ad‑hoc reporting from the data warehouse as requested by the consulting team.
• Develop financial models and reports for clients and account executive/consultants, providing interpretation and implication of analysis as well as recommendations.
• Oversee the servicing of a designated book or partial book of business as related 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.
• Interpret clients’ current contract terms and pharmacy programs, identify and recommend gaps, alternatives, and additional plan design changes, and maintain contract terms in the database.
• Assist in developing an implementation plan with the client and help consulting teams on client deliverables.
• Review all agreements and documents related to best‑in‑class terms and provisions.
• Maintain client CRM with all relevant client information.
• Work with the internal data operations team to maintain client data quality.
• Other responsibilities as assigned and/or needed.

Qualifications

• A Bachelor’s Degree in a business‑related field or equivalent experience in the insurance industry.
• 1‑2 years of experience in the insurance industry, specifically in employee welfare benefits or pharmacy data analytics.
• Knowledge of the Pharmacy Benefit Management (PBM) industry is preferred.
• Advanced knowledge of PowerPoint, Word, and Excel.
• Strong verbal and interpersonal communication skills.
• Strong customer‑service skills and 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 can also work well on a team.
• Legal right to work in the United States.

Lockton Companies, LLC is an equal opportunity employer. As a privately held company, we offer a competitive compensation and benefits package reflecting our commitment to attracting and retaining great individuals. This includes health, vision and dental coverage, which begins on your first day of work, 401(k) with match and immediate vesting, and a competitive vacation plan.