> Markdown version of [/jobs/ext/234551-pharmacy-data-analyst-ii](https://www.wearedevelopers.com/jobs/ext/234551-pharmacy-data-analyst-ii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Pharmacy Data Analyst II - **Company:** Lockton - **Location:** Kansas City, MO, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Microsoft Access, Microsoft Word, Microsoft Excel, Data Analysis, Data Files, Microsoft PowerPoint, Presentation Programs, SQL Databases - **Published:** May 31, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=e4fbb554c2c65a3a ## About the Role Do you have experience in Presentation software?, Do you have a Bachelor's degree?, 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., · 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. ## Description 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., · 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. ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Introduction to TXT](https://www.wearedevelopers.com/videos/30-introduction-to-txt) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [Implementing continuous delivery in a data processing pipeline](https://www.wearedevelopers.com/videos/73-implementing-continuous-delivery-in-a-data-processing-pipeline) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)