Health & Benefits Analyst

Mercer•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 role involves participating in delivering impactful solutions for organizations of any size and varied industries, working in a collaborative environment on a wide variety of client teams with Health colleagues. The analyst will support clients in the financial and strategic management of their employee benefit programs through analysis and communication, perform calculations related to employee benefit plans and insurance arrangements, and develop project management and consulting skills. The role also includes developing a deeper understanding of Mercer's Health and Benefits products, services, and technical tools, vendor/carrier markets, underwriting skills, and budget/rate setting.

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

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 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 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 client teams to develop recommendations and reporting for clients based on analysis.
Review amendments, contracts, and booklets.