IND Consultant I Health-2

Posting Description: 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-4 year of relevant experience 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: Assist consultants and other stakeholders for Canada Health and Benefits domain, delivering RFP/Renewal reports to the Clients. Supporting client teams in the servicing of clients with respect to plan design, contract management and benchmarking. Working with senior team members you will be involved with a variety of client deliverables including but not limited to contract reviews, plan design summaries and prevalence benchmarking. Delivering reports based on various parameters i.e., premium, claims & Loss ratios. The process involves analysis of healthcare products information provided by vendors & onshore consultants pertaining to premium, claims, plan attributes. You will be involved with a variety of client deliverables that empower our clients to make informed decisions. JOB RESPONSIBILITIES (List 6-10 major responsibilities in the role): 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 - Lead the preparation and analysis of carrier marketing materials, benefit costings, financial statements, and RFI/RFP submissions to inform pricing strategy, optimize plan design, and support carrier selection. - Providing technical advice/expertise for client projects (plan design, financial and underwriting review, flexible benefits pricing, insurance carrier reviews, etc.), including preparing letters and reports. - Analyze claims and client data, identify anomalies and cost drivers, estimate future plan costs, and develop pricing/underwriting models and financial analyses. - Write/deliver reports that are well prepared and provide expert commentary and observations following the review of contract, amendments, financial agreements, following plan redesigns or changes in the carrier - Drafting client ready reports and correspondence - Maintain and review data collection and accuracy in Aon’s proprietary client information platform - Review, audit and maintain client plan information - Compare and review plan summaries working with onshore teams - Interpret, organize, and analyse client data for specialty insurance products. - Prepare clear, client-ready Excel and PowerPoint reports. - Collaborate with Aon colleagues to apply standard methodologies and processes. - Stakeholder management through regular status updates, query resolution, and proactive communication. - Staying current on group benefits industry trends, products, tools, and technology, and applying this knowledge in day-to-day work. - Act as a bridge between onshore consultants and insurance vendors to ensure smooth coordination. - Manage client and shared mailboxes, ensuring timely and professional responses. - Continuously enhance technical skills and consulting effectiveness through training and self-learning. - Contribute to training and capability development of Junior Analysts (e.g., classroom sessions, training material development). SKILLS‐ - Strong proficiency in Microsoft Excel (logical, financial, math, statistical, and information functions; lookups; pivot tables; dynamic pivots; dashboards) and VBA. - Advanced experience with VBA, SQL, or Python for process automation (certifications preferred). - Knowledge of the Health & Benefits domain. - Solid stakeholder management skills. - Flexible, proactive, accountable, and highly collaborative with colleagues. - Self-driven, with strong analytical thinking and 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 manage 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. #LI-RG2