Consultant I/Sr Consultant (Health Ops & Rx Analytics)

Job Code: 125798

Job Title: IND Consultant I Health

Solution Line: Health & Benefits

Position Type: Full Time

Work Location: Gurgaon

Working Style: Hybrid

Cab Facility: Yes

Shift Time: 12PM to 9PM

People Manager Role: No

Required Education and Certifications Critical for the Role:

Graduate (Except technical graduates)

Required Years of Experience:

2.5-8 years of progressive, relevant experience in group insurance would be considered an asset.

Information About the Business:

Aon Health and Benefits takes a long-term view of benefits management that aims to help companies achieve a balance between using benefits as a retention tool and handling escalating costs.

These offerings include end-to-end solutions to benefits management, alignment of your benefit plans with corporate strategy and policies, considerable purchasing leverage, and a systematic and structured approach.

General Description of Role:

Support the Rx Solutions organization by producing standardized pharmacy analytics, reporting, and ROI insights using centralized data sources, automated reporting tools, and nationally aligned templates.

Operating within a centralized delivery model, this role executes recurring and ad-hoc analytics requests related to pharmacy claims, rebates, eligibility, and program performance.

This enables consulting and pharmacy teams to focus on strategic interpretation and client relationships.

Job Responsibilities:

• Produce standardized Rx analytics deliverables, including recurring and ad-hoc reports that support pharmacy consulting, pharmacists, and client success teams.
• Provide high-quality administration support for internal and external clients.
• Operate as part of a team under the supervision of Project Lead/Ops Manager.
• Support core pharmacy reporting outputs such as:
• Flash Reports
• Rx Trend Dynamics (RTD)
• Rebate forecasting and analysis
• Ensure reporting outputs are consistent, repeatable, and aligned to nationally agreed formats.
• Support intake of pharmacy claims, rebate, and eligibility data through:
• Vendor file feeds and data extracts
• Centralized data lake and downstream analytics tools (e.g., Power BI-based reporting)
• Perform data validation and reasonableness checks to ensure accuracy and alignment with client and consulting expectations.
• Assist with resolving data quality issues related to paid vs. incurred claims, eligibility discrepancies, and invoice variances.
• Execute analytics workflows using standardized queries, templates, and automated reporting processes to minimize manual intervention by consulting teams.
• Support ongoing optimization initiatives aimed at:
• Reducing manual reporting effort
• Increasing scalability of Rx analytics
• Improving consistency across clients and regions
• Support ad-hoc analytics requests routed from consulting teams, including:
• Rebate analysis
• Claims or eligibility deep dives
• Financial savings validation

Education & Skills:

• Bachelor’s degree or equivalent analytical experience preferred (analytics, finance, data, pharmacy, or related field).
• Prior experience with pharmacy analytics, healthcare claims data, or benefits analytics preferred.
• Strong analytical skills with the ability to work with large pharmacy claims and rebate datasets.
• High attention to detail and experience validating data across multiple sources and formats.
• Experience producing standardized analytics and reporting outputs (Excel, BI tools, or similar).
• Ability to manage recurring reporting cycles alongside ad-hoc analytics requests.
• Comfort working in an environment transitioning from manual processes to automation and centralized analytics.

How We Support Our Colleagues:

In addition to our comprehensive benefits package, we are proud to be an equal opportunity workforce.

At Aon, we believe a diverse workforce is an innovative workforce. Our agile, inclusive environment allows colleagues to handle their wellbeing and work/life balance while empowering them to be their authentic selves.

Furthermore, all colleagues enjoy two "Global Wellbeing Days" each year, encouraging them to take time to focus on themselves.

We offer a variety of workstyle options through our Smart Working model, recognizing that flexibility goes beyond just the place of work.

Our continuous learning culture inspires and equips colleagues to learn, share, and grow, helping them achieve their fullest potential.

As a result, Aon colleagues are more connected, more relevant, and more valued.