IND Consultant II - Wealth - PA Technology

Aon Corporation; Gurugram District; Hybrid; INR 1,200,000 - 2,400,000; Full time

Job summary

Aon plc in Gurgaon is seeking an IND Consultant II Wealth – PA – Technology to convert client requirements into analysis artifacts and design test strategy for Aon’s EQA System and VBA/Excel/Access-based tools. The role includes coordinating Analysts, delivering clear analyses, test plans, and SOPs with minimal supervision.

The incumbent will participate in client implementations, service extensions, and enhancements, leveraging VBA, Excel, SQL, and QA best practices to ensure high-quality

Qualifications

• Bachelor’s degree in CS/Maths or equivalent.
• Tech specialization (BCA/MCA preferred).
• Experience in US/Canada benefits domain preferred.
• Strong VBA/Excel with SQL knowledge.
• Ability to write complex VBA code for tools.
• Knowledge of system testing and QA best practices.
• Translate client requirements into technical specs.
• Strong analytical and problem-solving skills.
• Ability to coach and coordinate teammates.
• Understanding resources/tools to support responsibilities.
• Experience with in-house methodology.

Responsibilities

• Provide high-quality admin support for internal and external clients.
• Create analysis specs and update analyses as needed.
• Support pricing estimation and effort for config/data pieces.
• Influence design of changes and modules for efficient solutions.
• Coordinate handoffs and transition responsibilities to Operations.
• Participate in project kickoffs and status meetings.
• Learn and apply in-house methodologies.
• Assist deployment of system updates to production.

Skills

VBA

Excel

SQL

System testing

Analytical thinking

Coaching

Requirements analysis

Education

Bachelor’s degree in Computer Science, Maths or equivalent

Tech (any specialization)

BCA

MCA

Tools

VBA

Excel

Access

SQL

Job description

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

Required education and certifications critical for the role-

Graduate / Postgraduate

Required years of experience –

4-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 II Wealth - PA - Technology is responsible for converting client requirements into analysis artifacts and to design test strategy, scope and plans for Aon’s proprietary EQA System along with the different tools developed in the VBA Excel/Access. The Consultant II independently delivers clear and accurate analysis, test plans, and SOPs of complex modules/activities which accurately reflect the technical capacities of the system and address the requirements of the client along with participating in different Automation drives and implementations of innovative ideas by self-learning new techs as per requirements to provide best solutions. The Consultant II is also responsible for coordinating and coaching the Analysts I and II on configuration/test execution/process flows and new senior Analyst on analysis/test planning 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. The Consultant II is proficient in the functional and technical knowledge of the aligned service and delivers the responsibilities of the role independently with minimal support from the aligned Senior Manager.

JOB RESPONSIBILITIES:

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

• Provides service specific expertise for Data, Foundation, and Systems Analysis to create comprehensive analysis specifications, and incorporate recommended updates to analysis based on review.
• Provides support to Senior Manager in conducting Gap/Risk & Impact analysis of Change Order/defects and doing pricing analysis & effort estimation for related Config/Data/PCS pieces
• Influences the solution and design of Change Order/modules using prior experience to develop the most effective and efficient solution
• Provides support to new client implementation, an extension of services for a client, or an enhancement of current services.
• Ability to understand resources (tools, databases, associates) available to support self and team.
• Completes requirement hand-offs from Senior Manager and converts client business requirements to clear technical requirements and provides clarification(s) as required.
• Participate in iteration/project kickoffs and project status meetings
• Ability to learn and apply in-house methodology.
• Apply relational database concepts
• Assists with the deployment (or migration) of new system updates to the production environment.
• Responsible for converting client requirements into analysis artifacts
• Delivers clear analysis, test plans, and SOPs which accurately reflect the technical capacities of the system and address the requirements of the client.
• Transition & Ongoing Support
• Ensures smooth transition to production.
• Completes all technical documentation updates, completes production simulations and production verifications on all new work within iteration until it is determined to be stable,
• Supports Senior Manager to complete one-time handoff meeting with all interested parties to turn over stable work projects to Operations for ongoing support
• Participate in onshore meetings, Status Meetings along with the service aligned Manager

SKILLS/COMPETENCIES REQUIRED:

• Bachelor’s degree computer science, Maths or equivalent work experience in an analytical area.
• Tech (any specialization), BCA, MCA is preferred.
• Preferred relevant experience in US/Canada (preferred) Benefits Domain and Benefits Administration.
• Strong knowledge in VBA Access/Excel along with SQL.
• Can write complex code in VBA to develop tools and achieve required results.
• Knowledge of system testing and software quality assurance best practices and methodologies.
• Ability to translate client requirements and/or legislation into system specifications and test plans;
• Strong analysis skills related to service specific tasks and troubleshoot complex system defects and errors.
• Ability to learn and apply in-house methodology;
• Ability to understand resources (tools, databases, associates) available to support you in your responsibilities;
• Proven skills to use/coach others on technical and proprietary tools required to configure, test, debug, monitor, and report on system specifications.
• Deep knowledge of system capabilities, functionality, and development life cycle.
• Ability to coach and coordinate the work of others when balancing multiple tasks.
• Works with Senior Manager to identify training/information sharing needs
• Conducts info shares and remains available for clarification on topic
• 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

2584472