HireFT
Browse JobsHow it worksPricingSuccess Stories
    Back to jobs
    LO

    Lockton

    Insurance Brokerage

    Pharmacy Data Analyst

    Kansas City, Macao SAR ChinaOn-SiteFull-time1–2 yrs experiencePosted 4d ago
    All Lockton jobs

    Job description

    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

    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

    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

    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

    Job details are sourced from the employer's original posting.

    Open job posting
    LO

    About the company

    Lockton

    A privately held insurance brokerage and risk management consulting firm providing commercial insurance, employee benefits, and related services.

    View all Lockton jobs
    Industry
    Insurance Brokerage
    Open roles
    251

    Interested in this role?

    Apply with HireFT

    Free to start — no card required.

    Your fit

    How well do you match?

    Sign in to see how your résumé lines up with this role.