IND Analyst II - CRM GCC

Aon Corporation; Bengaluru; Hybrid; INR 700,000 - 1,100,000; Full time

Benefits offered by this job

Cab facility

Job summary

Aon is seeking an Analyst II to support Sales Enablement and Marketing as an Oracle CRM Specialist. The role focuses on ensuring system operations, data integrity, UAT, and delivering actionable CRM insights to drive business growth.

Responsibilities include requirements gathering, data transformation, and creating dashboards. Hybrid work from Bangalore with cab facility available and 2–4 years CRM experience expected.

Qualifications

• Experience with multiple CRM platforms and data models.
• Strong skills in Power BI, Excel, and dashboard design.
• Ability to translate business requirements into CRM actions.

Responsibilities

• Support Sales Enablement and Marketing as a CRM specialist.
• Maintain data integrity and perform UAT for CRM changes.
• Create storytelling dashboards and actionable insights for stakeholders.
• Manage user access, security roles, workflows, and routines.
• Collaborate with development teams to resolve complex CRM issues.
• Provide user training and document processes for CRM usage.

Skills

CRM platforms

CRM objects

Data visualization

Pivot tables

Data transformation

Excel proficiency

Stakeholder communication

Problem solving

Tools

Power BI

Job description

Posting Description

Solution Line- GSMS

Position type- Full Time

Work Location- Bangalore

Working style- Hybrid

Cab Facility- Yes

Shift Time – 5.30 PM- 2.30 AM

People Manager role: No

Required years of experience –

2-4 years of CRM platform 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 to our purpose as one firm, united through trust as one inclusive, diverse team and we are

passionate about helping our colleagues and clients succeed.

General description of the role:

“Analyst II” will play a key role in supporting Sales Enablement and Marketing as an Oracle CRM Specialist, ensuring seamless system operations and maintaining data integrity. This position demands a proactive approach to data quality management, technical issue resolution, and effective project execution. Responsibilities include gathering business requirements, translating them into CRM terminology, conducting User Acceptance Testing (UAT), and assisting users in leveraging CRM data to drive business growth. The Consultant will also provide guidance to optimize system utilization and address user requirements or application-related issues through case management, delivering timely and efficient support for business needs.

Job responsibilities:

• Strong experience across multiple CRM platforms.
• Expertise in CRM objects such as Accounts, Contacts, Opportunities, Leads, and Activities.
• Proficient in Power BI for developing interactive dashboards, custom visuals, and connecting to various data sources (CRM systems, Excel, etc.).
• Advanced skills in pivot tables, Power Pivot, and complex formulas (e.g., INDEX-MATCH, VLOOKUP).
• Skilled in data visualization using charts and conditional formatting.
• Ability to automate reporting through macros and VBA.
• Experienced in extracting, cleaning, and transforming CRM data for reporting purposes.
• Knowledgeable in customer segmentation and sales pipeline analysis.
• Capable of converting raw data into actionable insights to support business decisions.
• Solid understanding of critical metrics related to sales, marketing, and customer engagement..
• Adept at identifying data inconsistencies and resolving reporting issues.
• Ability to optimize dashboards for speed and accuracy.
• Skilled in presenting insights clearly to stakeholders and creating storytelling dashboards that highlight trends and opportunities.
• Serve as the primary point of contact for business‑specific CRM capabilities.
• Ensures timely resolution of CRM cases within agreed service levels through prioritization and follow‑up.
• Handles all CRM functions, including user profile maintenance, security roles, workflows, and routine tasks.
• Assist in user training and provide guidance to enhance CRM proficiency across the organization.
• Establish and document processes to support all responsibilities.
• Deliver day‑to‑day CRM functionality and end‑user support aligned with Aon Global Standards.
• Provide ongoing recommendations, documentation, training, and updates on CRM protocols.
• Implements structured steps for documenting, communicating, and testing functionality releases from sandbox to production environments..
• Maintain and improve system access for all users and roles.
• Collaborate with the CRM development team to resolve complex issues.
• Communicate optimally with customers regarding project status and delivery timelines.
• Support data quality and data management initiatives.

Behavioral skills

• Exceptional attention to detail with thorough documentation of all activities.
• Positive, flexible, and adaptable perspective with the ability to respond quickly and creatively to changing requirements.
• Strong investigative and analytical skills for data interpretation and problem-solving.
• Regular engagement with customers to build and maintain effective working relationships.
• Determined individual who proactively.
• Good communication and customer service skills.
• Collaborative teammate with a willingness to contribute to broader organizational initiatives.
• Solid analytical capabilities combined with strong business acumen.

Skills/competencies required:

• Expertise in CRM objects such as Accounts, Contacts, Opportunities, Leads, and Activities.
• Proficient in Power BI for designing interactive dashboards, custom visuals, and connecting to various data sources (CRM systems, Excel, etc.)
• Advanced skills in pivot tables, Power Pivot, and complex formulas (e.g., INDEX-MATCH, VLOOKUP).
• Skilled in data visualization using charts and conditional formatting, CRM Administrator, Exposure to Power BI, Reports & Dashboards

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 well‑being and work/life balance while empowering them to be their authentic selves.

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.

Commitment to sustainability

“Aon is dedicated to integrating sustainability into our core business practices. We strive to minimize our environmental impact through innovative solutions and responsible stewardship, ensuring a sustainable future for our clients and communities.”