Pharmacy Data Analyst

Lockton Companies; Kansas City (MO); On-site; USD 55,000 - 85,000; Full time

Benefits offered by this job

Health, vision and dental coverage

401(k) with match and immediate vestin

Competitive vacation plan

Job summary

Lockton Companies in Kansas City, MO seeks a data analytics professional to support client reporting from the internal pharmacy data warehouse. You will learn and perform pricing rebates, ensure data quality, and deliver actionable insights to consultants and account executives.

Collaboration with Operations and Consulting is essential. You will develop financial models, manage client data, and help maintain timelines for RFPs, renewals and project milestones, while interpreting contract terms

Qualifications

• A Bachelor’s Degree in a business-related field or equivalent experience in the insurance industry.
• 1-2 years’ experience in the insurance industry, specifically in employee welfare benefits or pharmacy data analytics.
• Knowledge of the Pharmacy Benefit Management (PBM) industry preferred.
• Advanced knowledge of PowerPoint, Word, and Excel.
• Strong verbal and interpersonal communication skills.
• Strong customer service skills with the ability to develop relationships with multiple clients.
• Ability to interact with vendors effectively.
• Excellent organizational and communication skills.

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 KPIs from the PBM vendor.
• Learn to perform pharmacy pricing guarantee reconciliations for clients quarterly and annually.
• Navigate Lockton’s internal pharmacy data warehouse and pull routine and ad hoc reporting.
• Develop financial models and reports for clients and consultants, provide interpretation and recommendations.
• Oversee servicing of a designated book of business across marketing, claims, reporting and administration.
• Track day-to-day client issues and assist team members in closing out open items.
• Build and maintain internal timelines for projects such as RFPs, renewals and reporting.
• Interpret client contracts, identify gaps and maintain Terms in database.

Skills

PBM industry knowledge

Communication skills

Customer service

Vendor management

Organizational skills

Team collaboration

Self-motivation

Education

Bachelor's degree in business-related field or equivalent

Tools

PowerPoint

Word

Excel

Job description

Kansas City, Missouri, United States of America

At Lockton, we’re passionate about helping our people achieve their ultimate potential. Our people are curious, action-oriented and always striving to make ourselves and those around us better. We’re active listeners working to ensure understanding and problem solvers developing innovative solutions. If you can see yourself delivering excellent service to clients, giving back to our communities and being a part of our caring culture, you belong here.

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

Qualifications

Qualifications

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

Knowledge of the Pharmacy Benefit Management (PBM) industry preferred

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

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.

#LI-DG2

#LI-MM4

Equal Opportunity Statement

Lockton Companies is proud to provide everyone anequal opportunity to grow and advance. We are committed to an inclusive culture and environment where our people, clients and communities are treated with respect and dignity.

At Lockton, supporting diversity, equity and inclusion is ingrained in our values, and we believe that we are at our best when we fully embrace everyone. We strive to cultivate a caring culture that learnsfrom, celebrates and thrives because of ourbreadth of differences. As such, we recognize that recruiting, developing and retaining people with diverse backgrounds and experiences is vital and enabling our people to thrive personally and professionally is critical to our long-term success.

About Lockton

Lockton is the largest privately held independent insurance brokerage in the world. Since 1966, our independence has allowed us to serve our clients, take care of our people and give back to our communities. As such, our 13,100+ Associates doing business in over 155 countries are empowered to do what’s right every day.

At Lockton, we believe in the power of all people. You belong at Lockton.

How We Will Support You

At Lockton, we empower you to be true to yourself in all that you do. Your success is our success, and we provide opportunities to help you grow and create a rewarding career path, however you envision it.

We are ready to meet you where you are today, and as your needs change over time. In addition to industry-leading health insurance, we offer additional options to support your overall health and wellbeing.

Any Employment Agency, person or entity that submits an unsolicited resume to this site does so with the understanding that the applicant's resume will become the property of Lockton Companies, Inc. Lockton Companies will have the right to hire that applicant at its discretion and without any fee owed to the submitting Employment Agency, person or entity. Employment Agencies, who have fee Agreements with Lockton Companies must submit applicants to the designated Lockton Companies Employment Coordinator to be eligible for placement fees.