IND Sr. Consultant II - Health Ops & Analytics

Job Code-125802

Job Title-IND Senior Consultant II 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 -

9-11 years of dynamic, relevant experience in group insurance would be considered an asset.

Aon is in the business of better decisions

At Aon, we shape decisions for the better to protect and enrich the lives of people around the world.

As an organization, we are committed as one firm to our purpose, united through trust as one inclusive, diverse team and we are passionate about helping our colleagues and clients succeed.

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 managing 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, systematic and structured approach.

General description of role:

Produce standardized financial reporting, claims/utilization insights, and projections for self‑insured clients using nationally aligned tools, templates, and visualization standards. This role is responsible for end‑to‑end execution of core analytics deliverables-including carrier data collection, source file updates, validation, and output generation-while supporting the consulting/financial team by preparing client-ready materials and ensuring reporting consistency across regions. Unlike client-facing consultant roles, this role supports delivery without owning primary client-facing responsibilities.

JOB RESPONSIBILITIES:

This role is accountable for analytics execution and delivery (data collection, source file updates, validation, reporting outputs, and presentation financial sections).

The Colleague provides high quality administration support for internal and external clients by:

Operates as part of team under supervision of Project Lead/Ops Manager

• Produce recurring financial/claims reporting deliverables aligned to nationally agreed templates and standardized client report outputs.
• Support renewal and projection cycles by generating consistent reporting packages that align to national visualization expectations (e.g., standardized outputs across regions).
• Collect required financial and claims/enrollment data from carriers (manual pull or receipt of carrier files/feeds where available) to support monthly reporting and projections.
• Coordinate data intake activities across carrier sites and shared repositories as part of a nationally aligned data flow.
• Enter claims information and related financial data into the standardized source file that feeds nationally agreed visualizations and reporting outputs.
• Perform data validation and reasonableness checks (e.g., comparing to monthly reporting) to ensure accuracy and reliability of analytics outputs.
• Support movement toward standardized Excel templates and future-state data drops into NFP Connect as the operating model evolves.
• Support projection and renewal review deliverables by preparing inputs, running standardized tools/templates, and summarizing results for consulting teams.
• Update and maintain financial slides/sections within standardized presentation materials (financial workbooks used with presentations), coordinating with the consulting/financial team on which slides are applicable in national presentations.
• Provide second-seat support when needed by preparing analytics content and ensuring outputs are client-ready, while primary client-facing ownership remains with the consulting lead.
• Support continuous movement away from manual processes by leveraging standardized data practices and participating in adoption of scalable tools (e.g., Power Query / automation initiatives referenced as part of future optimization).

Education & Skills‐

• Bachelor's degree or equivalent analytical experience preferred (finance, economics, mathematics, statistics, or related discipline).
• Experience supporting employee benefits analytics and/or insurance financial reporting preferred, including experience with self‑funded claims reporting and projections.
• Strong analytical skills with proven ability to validate, reconcile, and interpret financial and claims data.
• Advanced proficiency with structured Excel-based templates/source files and comfort producing standardized visualizations and outputs (e.g., Excel/PDF/BI-enabled formats).
• Ability to complete repeatable monthly and renewal cycles, meeting timelines and maintaining quality standards.
• Comfortable operating in an environment evolving toward improved automation, standardized file feeds/data extracts, and shared repositories.
• Dedicated, with a strong analytical approach and robust problem-solving skills

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 you to be your authentic self.

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, but we also recognize that flexibility goes beyond just the place of work... and we are all for it!

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.