Senior H&B Consulting Analyst

Marsh McLennan; Calgary; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

Marsh seeks a Senior Health & Benefits Consultant Analyst to join our Calgary team in a hybrid role requiring three days in the office. You will help the consulting team gather, organize, and analyze data using Excel, review work of junior analysts, and prepare vendor data summaries in Excel or PowerPoint for client meetings.

You have a university degree in Business, Finance, Actuarial Science, or Mathematics and 1+ years of health and benefits experience, with strong Excel skills, analytical

Qualifications

• University degree with a major in Business, Finance, Actuarial Science, Mathematics or related field.
• 1+ years of health and benefits experience.
• Strong analytical skills; Excel proficiency required.
• Excellent oral and written communication skills.
• Ability to prioritize and manage multiple tasks in a demanding environment.
• Strong problem-solving and analytical thinking.
• Ability to work independently and as part of a team.
• Intermediate PowerPoint and MS Office knowledge.

Responsibilities

• Assist the consulting team in gathering, organizing, entering, and analyzing data using Excel for client projects.
• Review the work of lower-level analysts and manage portions of projects with results analysis.
• Gather utilization or rate data from vendors via RFPs and summarize in Excel or PowerPoint for client presentations.
• Develop cost projections and evaluate vendor renewal workups for client meetings.
• Demonstrate project management by ensuring quality and timeliness of deliverables and assisting in budget and billing reports.

Skills

Excel

Analytical skills

Communication

PowerPoint

MS Office

Teamwork

Independent work

Education

Business/Finance/Actuarial/Math degree

Tools

Excel

PowerPoint

MS Office

Job description

Company:

Marsh

Description:

Are you interested in being part of a world-class, innovative benefit consulting organization? Then this is the place for you.

We are currently looking for a Senior Health & Benefits (H&B) Consultant Analyst to join our team.This hybrid role requires working at least three days a week in our Calgary office.

We will count on you to:

• Assist the consulting team in gathering, organizing, entering, and analyzing data using Excel spreadsheets for various client projects.
• Review the work of lower-level analysts and manage portions of projects with a focus on results analysis.
• Gather utilization or rate data from vendors via Requests for Proposals (RFPs) and summarize responses in Excel or PowerPoint for client presentations.
• Develop cost projections and evaluate vendor renewal workups for client meetings.
• Demonstrate project management and consulting skills by managing the quality and timeliness of client deliverables, developing budget and billing reports, and participating in calls and meetings.

What you need to have:

• University degree with a major in Business, Finance, Actuarial Science, Mathematics or a related field
• 1+ years of health and benefits experience
• Strong understanding of health and employment benefits experience in Canada
• Strong analytical and mathematical skills; strong command of Excel required
• Excellent oral and written communication skills
• Ability to prioritize and handle multiple tasks in a demanding work environment
• Strong critical thinking and analytical problem-solving skills
• Ability to work independently and as part of a team
• Intermediate in PowerPoint and working knowledge of the MS Office suite

What makes you stand out?

• Previous consulting, underwriting and/or actuarial experience
• 3+ years’ experience in the consulting or healthcare industry, particularly with vendor/carrier markets.
• Familiarity with underwriting and financial skills related to healthcare plans.
• Ability to learn quickly and adapt to new tools and processes, with a proactive approach to problem-solving.
• Participation in relevant training courses or online learning to enhance skills and knowledge.

Why join our team:

• We help you be your best through professional development opportunities, interesting work and supportive leaders.
• We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues, clients and communities.
• Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being.

Marsh (NYSE: MRSH) is a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information, visit marsh.com, or follow us on LinkedIn and X.

Marsh is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law. In accordance with applicable legislation, Marsh will provide a reasonable accommodation to employees and prospective employees to the point of undue hardship upon request and as required in respect of the individual’s particular restrictions and limitations. If you require a specific accommodation because of a disability or medical need please contact [e-mail].

Marsh is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person.