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

• 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. Bachelors 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.