Lead Specialist / Manager - US Health Benefits Analytics

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:

• 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
• 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
• 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:

• 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)
• 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 - 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
• 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