Pharmacy Data Analyst

Your Responsibilities

Lockton is a global professional services firm with 7,500 Associates who advise clients on protecting their people, property and reputations. Lockton has grown to become the world's largest privately held, independent insurance broker by helping clients achieve their business objectives. For eleven consecutive years, Business Insurance magazine has recognized Lockton as a Best Place to Work in Insurance .

Lockton is known throughout the insurance industry as an entrepreneurial, progressive and successful insurance broker. As a result of continued individual and group accomplishments, Lockton has a record of steady and substantial growth. If you are a committed professional with a passion for delivering unparalleled service, Lockton is interested in hearing from you.

Job Duties:

• Provide pharmacy prospect diagnostics including comprehensive pricing and contract analysis for producers and team leads
• Run ad hoc report queries including detailed analysis and insight
• Support the ongoing Lockton pharmacy data collection and reporting initiatives
• Troubleshoot pharmacy data issues and work with the PBMs and carriers to resolve
• Assist in the prospect pharmacy data collection process; analyze pharmacy claims data and provide detailed pricing and contract savings analysis
• Conduct comparative pricing analyses for pharmacy benefit Requests for Proposal
• Understand data sources, processes, formulas and output
• Execute ongoing pharmacy data collection and management with Pharmacy Benefit Managers (PBMs) and carriers for client reporting
• Implement data collection enhancements with the PBMs and carriers
• Perform quality control and data validation checks on the various client data sets
• Integrate data from multiple data sets into relevant client reports
• 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
• Assist with designing enhanced reporting to meet the evolving client needs
• Continuous quality improvement on processes, policies, and reporting to improve efficiency and innovation
  
  

Qualifications

Requirements:

• Bachelor's degree required. Major in Actuarial Science, Mathematics, Statistics, Finance, Economics, or Health Care Management
• Demonstrate advanced knowledge using MS Excel and MS Access, SQL experience desired
• Ability to understand data integrity and validity
• Statistical reporting and analysis experience
• Knowledge of healthcare issues and their associated impacts on plan sponsors and plan members; knowledge of pharmacy-related issues and associated impacts from a utilization and budgetary perspective preferred
• Experience working with a pharmacy benefit manager or pharmacy-focused occupation a plus
• Excellent written and oral communication skills to effectively present information
• Proven ability to manage multiple projects simultaneously