Lead Specialist – US Health Benefits Analytics

Marsh McLennan

. Own the end-to-end analytical workflow for a portfolio of client accounts .

Posted 10/30/2026full-timeGurugram • IndiaSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in analytical workflows, data reporting, and health benefits landscape, with a strong focus on translating complex data into actionable insights. Proficient in utilizing analytics tools and methodologies to support client needs and drive decision-making.

Highest-signal resume keywords

Microsoft Excel ProficiencyData Warehouse ExperienceHealth Analytics Tools FamiliarityUnderstanding of PMPM and Trend RateAnalytical Ownership

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisSQLData QueryingReport GenerationData ValidationTrend AnalysisCost BenchmarkingUtilization DecompositionData Pattern IdentificationMedical Claims Data Understanding

Soft Skills

Proactive CommunicationCoaching MindsetAdaptable CommunicationProblem-Solving SkillsRelationship Skills

Tools & Technologies

ArtemisMerativeHDMSTruvenBI Platforms

Industry Keywords

US Health Benefits LandscapeSelf-Insured PlansFully-Insured PlansTPA/PBM EcosystemCost Intervention Strategies

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

Own the end-to-end analytical workflow for a portfolio of client accounts
Run standard and custom reports across medical, pharmacy, and eligibility data
Build PMPM, trend, and benchmark analyses
Support Executive Summary, Financial Overview, and High-Cost Claimant reports
Perform condition-level drill-downs to identify cost drivers
Conduct utilization versus unit cost decomposition
Translate analytics output into structured narratives for consultant review
Identify population-level trends, including chronic condition prevalence, high-cost claimant patterns, and specialty pharmacy utilization
Flag anomalies and escalate data quality issues
Support benchmarking against the broader book of business by industry, region, and employer size
Prepare data packages and slide-ready analytics outputs for client presentations
Respond to ad hoc data requests from the consulting team
Collaborate with Data Operations on data scope, coverage dates, and account limitations
Maintain account-level documentation, including data source inventories, report run logs, and analysis notes
Mentor junior analysts and serve as a primary analytics partner to consulting leads

Requirements

What you’ll need

Proficiency in Microsoft Excel, including pivot tables, VLOOKUP/XLOOKUP, data validation, and charting
Ability to work with large, structured datasets and identify patterns across multiple data dimensions
Data warehouse experience such as Artemis, Merative, HDMS, or Truven preferred
Basic SQL or data querying ability preferred but not mandatory
Familiarity with analytics or BI platforms; health analytics tools are an advantage
Strong command of the US health benefits landscape, including self-insured vs. fully-insured plans, stop-loss, and the TPA/PBM ecosystem
Basic understanding of medical and pharmacy claims data structure and adjudication logic
Understanding of PMPM, PEPM, trend rate, utilization vs. unit cost decomposition, and episode cost benchmarking
Awareness of employer cost intervention strategies such as point solutions, COE programs, disease management, and Rx formulary strategy
Analytical ownership and responsibility for output accuracy and completeness
Proactive communication and early issue escalation
Consultative thinking connecting analytical findings to business implications and action
Coaching mindset
Adaptable communication, facilitation, influencing, and problem-solving skills
High attention to detail
Good relationship skills
Ability to work independently and in a team
Ability to multitask and prioritize time effectively