CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile

Lead Specialist / Manager - US Health Benefits Analytics

Marsh McLennan

Full time Hybrid
Location
India
Work mode
Hybrid
Posted 4 hr ago

You apply on Marsh McLennan's website. CoreHRx takes you there after you sign in.

CoreHRx never asks candidates for money. If anyone does, .

Role at a glance

Must-have skills
MS ExcelPivot TablesVLOOKUP/XLOOKUP
Work mode
Hybrid

How well do your skills match this job?

Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.

Job description

Company:

Marsh

Description:

Marsh is seeking candidates for the following position based in the GGN / Noida office

This is a hybrid role that has a requirement of working at least three days a week in the office.

What can you expect?


Power User is a subject matter expert in Health Benefits analytics who owns the end-to-end analytical workflow for a portfolio of client accounts. This role goes beyond running reports — the Senior Analyst is expected to independently develop analytical narratives, design custom analyses, mentor junior analysts, and act as the primary analytics partner to consulting leads.

The Senior Analyst is the person in the room who the consultant turns to when a client asks a complex data question. Deep platform knowledge, strong healthcare domain understanding, and the ability to connect data to strategy are the defining characteristics of this role


We will count on you for:


Analytics & Reporting

· Run standard and custom reports within the analytics platform across medical, pharmacy, and eligibility data

· Build PMPM, trend, and benchmark analyses for assigned client accounts

· Support production of Executive Summary, Financial Overview, and High-Cost Claimant reports

· Perform condition-level drill-downs to identify cost drivers across inpatient, outpatient, professional, and pharmacy categories

· Conduct utilization vs. unit cost decomposition to differentiate pricing inefficiency from volume-driven spend

Data Interpretation & Insight Development

· Translate raw analytics output into structured narratives for consultant review

· Identify population-level trends — chronic condition prevalence, high-cost claimant patterns, specialty pharmacy utilization

· Flag anomalies in data outputs and escalate for data quality review where needed

· Support benchmarking analysis — compare client metrics against the broader book of business by industry, region, and employer size

Client Support & Collaboration

· Prepare data packages and slide-ready analytics outputs for consultant use in client presentations

· Respond to ad hoc data requests from consulting team with accuracy and within agreed turnaround times

· Collaborate with the Data Operations team to understand data scope, coverage dates, and known limitations for each account

· Maintain account-level documentation including data source inventory, report run logs, and analysis notes

What you need to have:


Technical Skills

· Proficiency in Microsoft Excel — pivot tables, VLOOKUP/XLOOKUP, data validation, charting

· Ability to work with large, structured datasets and identify patterns across multiple data dimensions

· Data warehouse like Artemis, Meratives, HDMS, Truven etc.– preferred

· Basic SQL or data querying ability preferred — not mandatory

· Familiarity with analytics or BI platforms (experience with health analytics tools is an advantage)


Domain Knowledge

· Strong command of US health benefits landscape — self-insured vs. fully-insured, stop-loss, TPA/PBM ecosystem

· Basic understanding of claims data structure — medical and pharmacy claim fields, adjudication logic, allowed vs. billed vs. paid amounts

· Awareness of key metrics key metrics — PMPM, PEPM, trend rate, utilization vs. unit cost decomposition, episode cost benchmarking

· Awareness of common employer cost intervention strategies — point solutions, COE programs, disease management, Rx formulary strategy


Behavioural Competencies

· Analytical ownership — takes full responsibility for accuracy and completeness of outputs

· Proactive communication — does not wait to be asked, flags issues and opportunities early

· Consultative thinking — connects analytical findings to business implications and action

· Coaching mindset — invests in the development of junior team members

What makes you stand out?

  • Adaptable communicator, facilitator, influencer and problem solver
  • High attention to detail
  • Good relationship skills, Proven ability to work on own initiative as well as in a team
  • Ability to multi-task and prioritize time effectively
  • undefined

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, caste, disability, ethnic origin, family duties, gender orientation or expression, gender reassignment, 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.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.

Key skills

Required

MS ExcelPivot TablesVLOOKUP/XLOOKUP

Preferred

SQL

Soft skills

Attention to Detail

Job market insights

939active MS Excel jobs in India
225active Pivot Tables jobs in India
18active VLOOKUP/XLOOKUP jobs in India
48 more open jobs at Marsh McLennan

Jobs asking for MS Excel in India also ask for

  • MS PowerPoint23%
  • Accounting16%
  • SAP16%
  • Stakeholder Management16%
  • Power BI14%

From live job posts on CoreHRx, updated 2 Nov 2026. Skill figures count posts that list their skills; salary figures only posts that show a salary.

Questions about this job

What kind of job is this?

It is a full time job.

How do I apply?

You apply on Marsh McLennan's website. CoreHRx takes you there after you sign in.

This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.

Questions you may be asked

  1. What is the difference between WHERE and HAVING?
  2. What is the difference between DELETE, TRUNCATE and DROP?
  3. What is the difference between an INNER JOIN and a LEFT JOIN?
  4. What is the difference between a primary key and a unique key?

Get accounting & finance jobs by email

Create a free profile and we email you new accounting & finance jobs, at most once a week.

Similar jobs

Benefits Operations Administrator

Alight Solutions LLC
Gurgaon, noida
Payroll ProcessingPivot TablesStandard Operating Procedures (SOP)VLOOKUP/XLOOKUP+3
Full time On-site 1 day ago