Senior Health & Benefits Consulting Analyst

Mercer; Chicago (IL); Hybrid; USD 54,000 - 108,000; Full time

Benefits offered by this job

Professional development

Inclusive culture

Benefits and rewards

Tuition assistance

Job summary

Marsh Health & Benefits in Chicago seeks a data-focused analyst to support client projects. You will gather, organize, enter, and analyze data in Excel to drive results and project management.

Requirements include a Bachelor's degree and 0–3 years in health HR, with strong analytical, organizational, and communication skills. Hybrid work; three days in office or at client sites, with MS Office proficiency emphasized.

Qualifications

• Bachelor's degree required.
• 0–3 years in health industry or HR; internship preferred.
• Strong quantitative analytical skills.
• Excellent organizational, interpersonal, and written communication.
• Proficiency with Microsoft Office (Word, Excel, PowerPoint).

Responsibilities

• Gather, organize, enter, and analyze data in Excel for client projects.
• Collect and interpret vendor offerings and proposals for client presentations.
• Develop cost projections and vendor renewal evaluations for meetings.
• Ensure quality and timeliness of deliverables; assist with budgets and calls.
• Build knowledge of products, markets, underwriting, and financial tools through training.

Skills

Quantitative analysis

Microsoft Excel

Communication skills

Time management

Independent thinking

Education

Bachelor's degree

Tools

Excel

PowerPoint

Word

Job description

We are seeking a talented individual to join our Health & Benefits team at Marsh People & Investments (formerly known as Mercer). This role can be based in Chicago and offers a hybrid work arrangement, requiring a minimum of three days per week either in the office or at a client site.

We will count on you to:

• Support the consulting team by gathering, organizing, entering, and analyzing data in Excel for client projects, with an emphasis on results analysis and project management
• Collect and interpret vendor network offerings and financial proposals via RFPs, summarizing findings in Excel or PowerPoint for client presentations
• Develop cost projections and vendor renewal evaluations to inform client meetings
• Manage the quality and timeliness of client deliverables, assist with budget reports, participate in client and vendor calls, prepare clear communications, and resolve most issues, escalating complex matters as needed
• Build foundational knowledge of products, services, vendor markets, underwriting, financial skills, and technical tools through training, online courses, and mentorship

What you need to have:

• Bachelor's degree
• 0-3 years of experience in the health industry or HR; professional internship experience at the minimum
• Demonstrated quantitative analytical skills
• Strong business acumen paired with intellectual curiosity
• Excellent organizational, interpersonal, verbal, and written communication skills
• Capacity to multitask, manage competing priorities with strong time management skills
• Ability to exercise independent thinking
• Ability to work at a fast pace, both independently and in a team environment
• Proficiency using Microsoft Office - Word, Excel, and PowerPoint

What makes you stand out?

• Prior experience with benefits, insurance, underwriting, and/or risk management
• Advanced Excel skills; VLOOKUP and other formulas, pivot tables

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 an impact on 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, veteran status (including protected veterans), or any other characteristic protected by applicable law. If you have a need that requires accommodation, please let us know by contacting [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.

The applicable base salary range for this role is $54,000 to $108,000.

The base pay offered will be determined on factors such as experience, skills, training, location, certifications, education, and any applicable minimum wage requirements. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.

We are excited to offer a competitive total rewards package which includes health and welfare benefits, tuition assistance, 401K savings and other retirement programs as well as employee assistance programs.