Lead Specialist Manager - US Health Benefits Analytics

Marsh McLennan; Gurugram District; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

Marsh is seeking a Senior Analyst based in the GGN / Noida office for a hybrid role, requiring at least three days in the office weekly. The candidate will own end-to-end analytics workflows for a portfolio of client accounts in health benefits analytics, beyond just running reports.

The Senior Analyst will develop analytical narratives, design custom analyses, mentor junior analysts, and serve as the primary analytics partner to consulting leads, translating complex data questions into

Qualifications

• Proficiency in Excel with pivot tables, VLOOKUP/XLOOKUP, data validation.
• Experience with health analytics data and healthcare domain.
• Familiarity with SQL or data querying.
• Ability to translate analytic outputs into structured narratives.

Responsibilities

• Run standard and custom reports across medical, pharmacy, and eligibility data.
• Build PMPM, trend, and benchmark analyses for client accounts.
• Support executive summaries, financial overviews and high-cost claimant reports.
• Translate data outputs into client-ready narratives for consultants.

Skills

Excel proficient

SQL basics

Data analysis

BI platforms

Tools

Artemis

Meratives

HDMS

Truven

Job description

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 upscale 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

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.