Sr. Actuarial Analyst

The Sr. H&B Actuarial Analyst will provide accurate and timely data and financial analysis on various actuarial/financial projects for pricing of medical, dental, life and disability programs. To fulfill this role, the Actuary will:

  • Perform basic cost projections by entering the client's cost and enrollment data into an Excel spreadsheet and projecting costs for the next plan year
  • Analyze vendor renewals by checking carrier or vendor's plan rates for reasonableness and by analyzing claims and enrollment data, trend rates, administrative expenses and other charges
  • Price medical and prescription drug plan designs by entering plan design information into Mercer's internal pricing model to develop the relative cost differences between plan designs, in order to compare the client's current plan to alternative designs
  • Develop employee contributions scenarios by entering current employee medical contribution data into an Excel spreadsheet and project contributions to the next plan year, taking into account the cost-sharing goals of the client
  • Gain an understanding of basic project management and consulting skills such to include: managing the quality and timeliness of client deliverables, helping to develop budgets and billing reports, participating in client calls and meetings as appropriate and assisting with the preparation of clear and concise client-friendly communications
  • Gain an understanding of the following, through online training, group sessions, or one-on-one training with others in a more senior role: Health and Benefits products, services and technical tools offered by Mercer, vendor/carrier markets, basic underwriting and actuarial skills, budget-setting, rate-setting and evaluation

The Sr. H&B Acturial Analyst may:
  • Perform pricing and evaluation of consumerism plans using Mercer's internal pricing model to compare designs where consumers have a greater ownership in costs
  • Analyze cost drivers by reviewing client's cost/utilization data and looking for year-over-year trends or comparisons to external benchmarks using data provided from client's vendor reports or raw data from external databases
  • Project retiree medical costs by entering the client's retiree cost and enrollment data for both pre-Medicare and post-Medicare
  • Estimate the impact of Medicare part D legislation by entering retiree prescription drug data into Mercer's Part D pricing model and performing tests to determine whether a federal government subsidy is available to the client
  • Perform analyses for larger, more complex clients, including more in-depth analysis for complex situations that may require additional research or discussion with Mercer subject matter experts
  • Gather necessary data from the vendor or client; review to ensure it is complete, accurate and reasonable; and prepare data in a particular template or format for use in basic or advanced financial analyses or valuations.


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