Job Title- IND Consultant I Health Solution Line- Canada H&B 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. Working on the internal client data base tool to update policy information related to Canada health and benefit plans. Providing clients with market insights and a measure of how their benefit programs compare to the competition. 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. 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 + Project execution in-line with SLA requirements, timelines and quality standards while ensuring high level of internal & external client satisfaction. + Interprets, organizes, and analyzes client data for specialty insurance products + Prepares Excel and PowerPoint reports for the clients + Collaborates with peers at Aon to understand methodologies and follow the process. + Responsible for stakeholder management (including status updates on project/activities, query resolution, etc.) + Enhance technical skills and personal effectiveness through training, education. + Bridging the communication gap between onshore consultant and insurance Vendors + Managing client/shared mailboxes + Contributes to training and capability development for Jr. Analyst in collaboration (classroom trainings, training material development etc.) SKILLS ‐ + Proficient with MS Excel logical, financial, math, statistical and information functions Lookups, Pivot Table, Dynamic Pivots, Dashboards along with VBA coding + Advanced experience with VBA coding/SQL/Python for process automation (certification is preferred) + Knowledge of Health & Benefits domain + Stakeholder Management + Should be flexible, keen on taking initiatives, accountable and have a collaborative approach with colleagues. + Self-Driven & analytical bend of Mind, 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 2562715 Job Title- IND Consultant I Health Solution Line- Canada H&B 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. Working on the internal client data base tool to update policy information related to Canada health and benefit plans. Providing clients with market insights and a measure of how their benefit programs compare to the competition. 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. 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 + Project execution in-line with SLA requirements, timelines and quality standards while ensuring high level of internal & external client satisfaction. + Interprets, organizes, and analyzes client data for specialty insurance products + Prepares Excel and PowerPoint reports for the clients + Collaborates with peers at Aon to understand methodologies and follow the process. + Responsible for stakeholder management (including status updates on project/activities, query resolution, etc.) + Enhance technical skills and personal effectiveness through training, education. + Bridging the communication gap between onshore consultant and insurance Vendors + Managing client/shared mailboxes + Contributes to training and capability development for Jr. Analyst in collaboration (classroom trainings, training material development etc.) SKILLS ‐ + Proficient with MS Excel logical, financial, math, statistical and information functions Lookups, Pivot Table, Dynamic Pivots, Dashboards along with VBA coding + Advanced experience with VBA coding/SQL/Python for process automation (certification is preferred) + Knowledge of Health & Benefits domain + Stakeholder Management + Should be flexible, keen on taking initiatives, accountable and have a collaborative approach with colleagues. + Self-Driven & analytical bend of Mind, 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