IND Consultant I – Reporting & Analytics (SQL, ETL & Power BI)

Aon plc; Gurugram District; Hybrid; INR 900,000 - 1,300,000; Full time

Benefits offered by this job

Global Wellbeing Days

Smart Working model

Job summary

Aon plc is seeking a Law, Compliance and Risk Reporting and Technology Analyst in Gurugram to develop and maintain reporting, analytics, and data integrity for legal, compliance, and risk tools.

You will work with Compliance, Legal, Risk, Internal Audit, and business teams to deliver accurate insights, automate reports, and ensure data quality across systems in a hybrid work environment.

Qualifications

• Bachelor’s degree or higher in Business Admin, Finance, Risk Management, Compliance, Law, Data Analytics or related field.
• 2+ years of experience in compliance reporting, regulatory reporting, risk management, data analytics or related role.
• Strong proficiency in reporting and BI tools (Excel, Power BI, Tableau, SQL).
• Experience with legal, compliance, risk, governance, or regulatory management systems.

Responsibilities

• Develop, maintain, and distribute recurring and ad hoc compliance reports, dashboards, and metrics.
• Design and build reporting dashboards showing compliance performance, legal data, control effectiveness, policy adherence, and risk indicators.
• Collaborate with Compliance, Legal, Risk, Internal Audit, and stakeholders to deliver actionable insights.
• Ensure accuracy, completeness, and integrity of compliance and risk data across reporting systems.
• Perform data validation, QA, and audits of compliance reporting outputs.
• Manage data collection, migration, imports, updates, reconciliation, and cleansing for management reporting.
• Partner with Compliance SMEs, IT, and system owners to ensure systems meet requirements and support low-code configurations.
• Identify opportunities to automate reporting and improve data quality and efficiency.
• Support implementation of new reporting capabilities, regulatory requirements, and system enhancements.
• Monitor and troubleshoot reporting issues and data discrepancies.
• Serve as SME for law and compliance reporting and reporting controls.
• Develop technology and reporting process documentation.

Skills

Excel

Power BI

Tableau

SQL

Data analytics

Education

Bachelor’s degree in related field

Tools

Regulatory management systems

Job description

Job Code- 12132
Job Title- IND Consultant I - Compliance
Solution Line- Legal & Compliance

Position type-

Full Time

Work Location-

Gurugram

Working style-

Hybrid

Sub ARL-

C25

Shift Time-

8 AM to 5 PM

People Manager role:

No

Required education and certifications critical for the role-

Graduates

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

Aon is a leading global professional services firm providing a broad range of risk, retirement, and health solutions. Our colleagues provide clients in over 120 countries and sovereignties with advice and solutions that give them the clarity and confidence to make better decisions to protect and grow their business.

General description of role:

We are seeking a Law, Compliance and Risk Reporting and Technology Analyst to develop and maintain the reporting, analytics, data integrity and functionality for our legal, compliance and risk tools. This role involves working closely with cross-functional teams to ensure accurate data, generate insightful reports, and optimize law, compliance, and risk tools to meet reporting and technology needs.

Job responsibilities:

1. Develop, maintain, and distribute recurring and ad hoc compliance reports, dashboards, and metrics to support legal, risk, and compliance oversight activities.
2. Design and build reporting dashboards that provide visibility into compliance performance, legal data, control effectiveness, policy adherence, and key compliance risk indicators.
3. Collaborate with Compliance, Legal, Risk, Internal Audit, and business stakeholders to understand reporting requirements and deliver actionable insights.
4. Ensure the accuracy, completeness, integrity, and consistency of compliance, risk and legal data across reporting systems.
5. Perform regular data validation, quality assurance reviews, and audits of compliance reporting outputs.
6. Manage data collection, migration, imports, updates, reconciliation, and cleansing processes to support management reporting.
7. Partner with Compliance SMEs, IT, and system owners to ensure law- and compliance-related systems and reporting tools are configured effectively and aligned with business requirements. This may include drafting requirements, evaluating tools against defined requirements, and configuring in low-code environments.
8. Identify opportunities to automate reporting processes, improve data quality, and enhance reporting efficiency.
9. Support the implementation of new compliance reporting capabilities, regulatory requirements, system enhancements, and reporting solutions.
10. Monitor and troubleshoot reporting issues, data discrepancies, and system-related challenges affecting law and compliance reporting.
11. Serve as a subject matter resource for law and compliance reporting, data management, and reporting controls.
12. Develop technology and reporting process documentation.

Skills/competencies required:

1. Bachelor’s degree in Business Administration, Finance, Risk Management, Compliance, Law, Data Analytics, or a related field.
2. 2+ years of experience in compliance reporting, regulatory reporting, risk management, data analytics, audit, or a related role.
3. Strong proficiency in reporting and business intelligence tools (e.g., Excel, Power BI, Tableau, SQL, or similar platforms).
4. Experience working with legal, compliance, risk, governance, or regulatory management systems.
5. Knowledge of data governance, data quality management, and reporting controls.
6. Strong analytical and problem-solving skills with the ability to identify trends, anomalies, and emerging compliance risks.
7. Experience translating complex data into clear, actionable insights for business and compliance stakeholders.
8. Strong written and verbal communication skills, including the ability to prepare executive-level reporting and presentations.
9. Ability to manage multiple priorities, work independently, and collaborate effectively across Compliance, Legal, Risk, Technology, and business teams.

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.

2586131