Pharmacy Analyst

At Mercer, we make a difference in the lives of more than 110 million people every day by advancing their health, wealth, and careers. We're in the business of creating more secure and rewarding futures for our clients and their employees

- whether we're designing affordable health plans, assuring income for retirement or aligning workers with workforce needs. Using analysis and insights as catalysts for change, we anticipate and understand the individual impact of business decisions, now and in the future. We see people's current and future needs through a lens of innovation, and our holistic view, specialized expertise, and deep analytical rigor underpin each and every idea and solution we offer.

For more than 70 years, we've turned our insights into actions, enabling people around the globe to live, work, and retire well. We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. At Mercer, we say we Make Tomorrow, Today.

Visit for more information and follow us on LinkedIn and Twitter @Mercer

Mercer LLC and its separately incorporated operating entities around the world are part of Marsh & McLennan Companies, a publicly held company (ticker symbol: MMC).

The Pharmacy Consulting Analyst will support consultants in managing client accounts by researching, analyzing, and evaluating employers' pharmacy benefits plans and programs. To fulfill this role, the Pharmacy Consulting Analyst will:

- Assist the consulting team in gathering, organizing and entering data into Excel spreadsheets to be used for various client projects.

- Analyze the results and manage portions of projects

- Gather materials, benchmarking utilization data for a Request for Proposal (RFP) and interpret the meaning of the data and summarize the RFP responses in Excel or PowerPoint format for presentation to the client.

- Gather and analyze data from the client and vendors to populate Excel spreadsheets used for developing cost projections and evaluation of vendor renewal proposals.

- Obtain data from client and vendors; check for reasonability using independent judgment and critical thinking skills; follow up with vendors regarding missing or inaccurate data, analyze actual versus expected healthcare costs using an Excel template.

- Gain an understanding of vendor/carrier markets, basic underwriting and financial skills, Health & Benefit products, services and technical tools, and intranet resources, by participating in training courses, online learning, or through learning from more experienced colleagues

- Develop benchmarking reports by gathering and analyzing pharmacy benefits data from a database, input it into a standardized template and compare a client's pharmacy plan information to other companies by industry or geography and assist client lead with resenting data.


Meet Some of Marsh & McLennan Companies's Employees

Nancy K.

Contract Review Specialist

Nancy reviews the contracts her clients either offer or receive from vendors, taking care to monitor the insurance requirements on the provided services.

James S.

Partnership Certificate Supervisor

As supervisor of the North Central Team, James manages 24 direct reports in an operations environment and encourages high-quality production and professional development.

Back to top