Health & Benefits Analyst

Marsh McLennan•Ottawa, ON

6d•CA$71,500 - CA$107,500•Hybrid

About The Position

Mercer Canada is seeking a Health & Benefits Analyst to join their H&B consulting department in their Ottawa office. This is a hybrid role that requires being in the office at least 3 days a week. The analyst will participate in delivering impactful solutions for organizations of any size and varied industries, working in a collaborative environment on a wide variety of client teams. The role involves supporting clients in the financial and strategic management of their employee benefit programs through analysis and communication, performing calculations related to employee benefit plans and insurance arrangements, and developing project management and consulting skills. The analyst will also develop a deeper understanding of Mercer's Health and Benefits products, services, technical tools, vendor/carrier markets, underwriting skills, and budget/rate setting through various training methods. The position requires providing accurate and timely data and financial analysis for medical, dental, life, and disability programs, validating and comparing premiums, producing quarterly experience monitoring reports, analyzing financial statements of group insurance plans, analyzing cost drivers, performing in-depth analyses for complex situations, gathering and validating data, and working with client teams to develop recommendations and reporting. Reviewing amendments, contracts, and booklets is also part of the responsibilities.

Requirements

Strong organizational skills
Strong oral and written communication skills
Ability to handle multiple tasks in a demanding fast-paced work environment
Ability to work in a team environment where the priorities and requirements may change quickly
Time management skills
Proficiency with Microsoft Office (Excel, Word, PowerPoint)
Will be required to obtain and maintain appropriate licenses as required by provincial regulations and Mercer policies.

Nice To Haves

Post-secondary degree or equivalent experience in business, mathematics, statistics, finance or a related field.
Previous work-related experience
Bilingual (French/English)
Familiarity or experience with group insurance benefits (through work experience, CEBS GBA designation or working towards it)
3 to 4 years of relevant experience.
LLQP or equivalent based on Province

Responsibilities

Participate in delivering impactful solutions for organizations of any size and varied industries and have a direct impact on their employees.
Work in a collaborative environment on a wide variety of client teams with any number of our Health colleagues.
Support clients in the financial and strategic management of their employee benefit programs through analysis and communication.
Perform basic or complex calculations with respect to the costs of our clients’ employee benefit plans and insurance arrangements, including using Mercer’s internal tools to price plan design changes and prepare future cost projections.
Develop project management and consulting skills including managing the quality and timeliness of client deliverables, participating in client calls and meetings as appropriate and assisting with the preparation of client-friendly communications.
Develop deeper understanding of the following, through online training, group sessions, or one-on-one training with colleagues: Health and Benefits products, services and technical tools offered by Mercer, vendor/carrier markets, basic underwriting skills, budget-setting, rate-setting and evaluation.
Provide accurate and timely data and financial analysis on various projects for medical, dental, life and disability programs.
Validate and compare premiums for group benefit plans under vendor renewals, quotes or benchmarking exercises with other companies in the industry.
Produce quarterly experience monitoring reports for clients and analyze the impact of any recent changes.
Analyze financial statements of group insurance plans and review the financial agreement to suit the client needs.
Analyze cost drivers by reviewing client's 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.
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.
Work with your client teams to develop recommendations and reporting for clients based on your analysis.
Review amendments, contracts, and booklets.