Pharmacy Data Analyst II
Kansas City, Missouri, United States of America
Data Analytics
2600X9
Pharmacy Data Analyst II
Kansas City, Missouri, United States of America
Data Analytics
2600X9
Working at Lockton
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.
Dallas
Your Responsibilities
Lockton Dunning Benefits is currently seeking a Pharmacy Analyst II, who will help with client Request for Proposals, Reconciliations, audits, data file management, financial analysis, reporting, and operations related to Pharmacy Analytics. Your team provides support for Pharmacy Benefit analytics to Health and Welfare teams assisting with RFP activities, reporting and reconciliations.
Our ideal candidate will demonstrate a high level of professionalism, an ability to embrace our friendly and ambitious culture, the capability to thrive in a fast-growing - fast-paced environment, and the flexibility to easily adapt to changing priorities. You will be an important contributor in the realization of our mission to revolutionize insurance to protect what matters.
ESSENTIAL JOB DUTIES AND RESPONSIBILITIES
· Provide pharmacy prospect diagnostics including comprehensive pricing and contract analysis for producers and team leads
· Assist with releasing pharmacy Request for Proposal to market
· Conduct comparative pricing analyses for pharmacy benefit Requests for Proposal
· Collaborate with internal account teams and vendors to create financial analysis
· Assist with pharmacy financial performance reconciliation, analysis, and audits
· Run ad hoc report queries including detailed analysis and insight
· Support the ongoing Lockton pharmacy data collection and reporting initiatives
· Assist in the prospect pharmacy data collection process; analyze pharmacy claims data and provide detailed pricing and contract savings analysis
· Understand data sources, processes, formulas and output
· Prepare standard and ad hoc pharmacy reports and presentations for pharmacy consulting team to present to clients
· Collaboratively analyze client data to identify areas of concern and recommendations for strategies to manage pharmacy spend
· Continuous quality improvement on processes, policies, and reporting to improve efficiency and innovation
· Maintains a high level of professionalism and sense of urgency to ensure client and account team expectations are consistently met.
· Assists Level I analysts with training.
· Helps document processes and identifies areas of improvement.
· Performs other duties as assigned or requested.
Qualifications
EDUCATION, EXPERIENCE, AND SKILLS REQUIRED
· Relevant industry knowledge of Pharmacy Analytics coverage’s and services.
· Basic understanding of Pharmacy financial concepts including Discounts, Rebates, Fees and Cost plus.
· Must have strong internal and external customer service skills, along with the ability to develop sound internal client relationships.
· Demonstrates the ability to instill confidence and comfort with clients and representatives.
· Must have strong verbal, written, and interpersonal skills to interact with associates at all levels of responsibility, along with the ability to communicate with tact and diplomacy.
· Demonstrates professional, tactful negotiation and persuasion skills to achieve objectives.
· Organizational and time management skills to prioritize workload and meet deadlines required. Must be results oriented with the ability to change priorities as needed.
· Efficient in multi-tasking (managing workload and timeliness).
· Self-motivated and a team player.
· Adept at problem solving and making critical decisions.
· Ability to interpret and implement company and state policies and processes.
· Ability to grasp new and complex concepts.
· Bachelor’s Degree (preferred) not a requirement
· Minimum 2 – 4 years of experience in a data analysis role.
· 3+ years of Pharmacy industry experience
· Legal right to work in the United States.
· Proficiency in the use of Microsoft Word, Excel, and PowerPoint. MS Access and SQL experience desired.
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-MM4
#LI-DG2
Equal Opportunity Statement
Lockton Companies is proud to provide everyone an equal 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 learns from, celebrates and thrives because of our breadth 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.
No Agencies Please
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.
Similar Vacancies
View allLife at Lockton

March 10, 2026

February 3, 2026

January 21, 2026

January 13, 2026