Job Title - IND Consultant I Wealth - PA - Technology Solution Line- Wealth Position type- Full Time Work Location- Gurgaon Working style- Hybrid Cab Facility- Yes Shift Time – 12PM to 9PM People Manager role: Yes Required education and certifications critical for the role- Bachelor’s degree computer science, Maths or equivalent work experience in an analytical area. Tech (any specialization), MTech, MCA is preferred. Required years of experience – 2-6 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 We leverage deep actuarial, plan design and pension administration expertise and tools to design retirement plans. We help employers mitigate risk by better understanding liabilities, building plans that enhance retirement readiness and serving participants with unmatched satisfaction. Our investment team provides a spectrum of services including Investment Consulting, Delegated Investments and Alternative Investments, helping clients to optimize their potential risk-adjusted performance in a volatile market environment. GENERAL DESCRIPTION OF ROLE: IND Consultant I Wealth - PA - Technology is responsible for converting client requirements into analysis artifacts and to design test plans (based on direction from the MANAGER) after the configuration of the Aon’s proprietary EQA System. The Consultant I delivers and maintains the different tools developed in VBA Excel/Access to provide data support to various teams. The Consultant I delivers clear analysis and test plans which accurately reflect the technical capacities of the system and address the requirements of the client along with participating in different Automation drive and implementation of innovative ideas by self-learning new techs as per requirement to provide best solutions. As well, the Consultant I is responsible for coordinating and coaching around the configuration and test execution of the technology platform for a client team’s service aligned benefits system. This can take the form of a new client implementation, an extension of services for a client, or an enhancement of current services. JOB RESPONSIBILITIES + Clarify Requirements—Works with Requirements team to clarify Requirements. + Design/Analysis—Provides service specific expertise for Data, Foundation, and Sr Consultant to create comprehensive analysis specifications, and incorporate recommended updates to analysis based on review. + Development – Database, VBA and Application support + Test Planning—Designs Test Plans (unit, integration, regression, acceptance) and incorporates. + recommended updates to Test Plan based on review. + Handoff—Hands off Analysis and Test Plans to CONSULTANT/ANALYST. + Coaching—Coaches CONSULTANT/ANALYST on configuration, VBA, SQL and testing work and defects + Review Configuration/Testing—Reviews Analysis and Test Plan documentation updates made by CONSULTANT/ANALYST and evaluates the results of the CONSULTANT/ANALYST test execution. + Coordinate Construction Work—Coordinates the work of aligned CONSULTANT/ANALYST, monitors task completion, and + communicates team schedule and status to MANAGER. + Deployment—Executes on assigned deployment activities. + Production Support—Supports production environment (defects and trends) and executes workflow and defect management. SKILLS/COMPETENCIES REQUIRED: + Flexible and adapt to changing priorities and deadlines. + Coaches and coordinates work activities for the Setup Configuration Specialists aligned to the configuration and testing of the technology platform for a client's service. + Develop and Maintain VBA Access/Excel/SQL based tools. + Should have good hands-on experience in VBA. + Able to independently gather the requirements and provide solutions for VBA related support. + Learn innovative technology and support application. + Provides Analysis/Test Plan Reviews for newer CONSULTANT I + Shares Service Specific Best Practices and supports adherence. + Works with MANAGER to identify training/information sharing needs. + Actively participate in general technical/service specific forums. 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 2562164 Job Title - IND Consultant I Wealth - PA - Technology Solution Line- Wealth Position type- Full Time Work Location- Gurgaon Working style- Hybrid Cab Facility- Yes Shift Time – 12PM to 9PM People Manager role: Yes Required education and certifications critical for the role- Bachelor’s degree computer science, Maths or equivalent work experience in an analytical area. Tech (any specialization), MTech, MCA is preferred. Required years of experience – 2-6 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 We leverage deep actuarial, plan design and pension administration expertise and tools to design retirement plans. We help employers mitigate risk by better understanding liabilities, building plans that enhance retirement readiness and serving participants with unmatched satisfaction. Our investment team provides a spectrum of services including Investment Consulting, Delegated Investments and Alternative Investments, helping clients to optimize their potential risk-adjusted performance in a volatile market environment. GENERAL DESCRIPTION OF ROLE: IND Consultant I Wealth - PA - Technology is responsible for converting client requirements into analysis artifacts and to design test plans (based on direction from the MANAGER) after the configuration of the Aon’s proprietary EQA System. The Consultant I delivers and maintains the different tools developed in VBA Excel/Access to provide data support to various teams. The Consultant I delivers clear analysis and test plans which accurately reflect the technical capacities of the system and address the requirements of the client along with participating in different Automation drive and implementation of innovative ideas by self-learning new techs as per requirement to provide best solutions. As well, the Consultant I is responsible for coordinating and coaching around the configuration and test execution of the technology platform for a client team’s service aligned benefits system. This can take the form of a new client implementation, an extension of services for a client, or an enhancement of current services. JOB RESPONSIBILITIES + Clarify Requirements—Works with Requirements team to clarify Requirements. + Design/Analysis—Provides service specific expertise for Data, Foundation, and Sr Consultant to create comprehensive analysis specifications, and incorporate recommended updates to analysis based on review. + Development – Database, VBA and Application support + Test Planning—Designs Test Plans (unit, integration, regression, acceptance) and incorporates. + recommended updates to Test Plan based on review. + Handoff—Hands off Analysis and Test Plans to CONSULTANT/ANALYST. + Coaching—Coaches CONSULTANT/ANALYST on configuration, VBA, SQL and testing work and defects + Review Configuration/Testing—Reviews Analysis and Test Plan documentation updates made by CONSULTANT/ANALYST and evaluates the results of the CONSULTANT/ANALYST test execution. + Coordinate Construction Work—Coordinates the work of aligned CONSULTANT/ANALYST, monitors task completion, and + communicates team schedule and status to MANAGER. + Deployment—Executes on assigned deployment activities. + Production Support—Supports production environment (defects and trends) and executes workflow and defect management. SKILLS/COMPETENCIES REQUIRED: + Flexible and adapt to changing priorities and deadlines. + Coaches and coordinates work activities for the Setup Configuration Specialists aligned to the configuration and testing of the technology platform for a client's service. + Develop and Maintain VBA Access/Excel/SQL based tools. + Should have good hands-on experience in VBA. + Able to independently gather the requirements and provide solutions for VBA related support. + Learn innovative technology and support application. + Provides Analysis/Test Plan Reviews for newer CONSULTANT I + Shares Service Specific Best Practices and supports adherence. + Works with MANAGER to identify training/information sharing needs. + Actively participate in general technical/service specific forums. 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