Job Title- Data Architect- Reporting & BI Position type- Full Time Work Location- Bangalore/Gurugram/Noida Working style- Hybrid People Manager role: No Required education and certifications critical for the role- Any Graduate or Post-Graduate (full time) Required years of experience – Minimum 10+ years 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 united through trust as one inclusive, diverse team, and we are passionate about helping our colleagues and clients succeed. Specifically, within Commercial Risk Solutions we offer risk advisory, risk transfer and structured solutions that help organisations and individuals identify, quantify and manage their risk exposure through insurance. Responsibilities of this role This role will provide the candidate an opportunity to work as part of our CRS Ecosystem Reporting & BI Product Team. You will be responsible for delivering a databricks data lakehouse that will drive a range of internally focused reporting and business intelligence solutions to colleagues across multiple regions. The role demands a strong technical background with exceptional analytical skills. We are looking for a self-starter with the ability to solve complex problems. Day-to-day responsibilities include: Design, develop, and maintain scalable data pipelines and ETL processes using Testing, monitoring, and maintenance of existing pipelines. Optimise data processing workflows to ensure high performance and reliability Work closely with cross-functional teams, including business analysts, data architects, BI analysts, stakeholders and clients to support data-related needs. Implement data quality checks and validation processes to ensure the integrity and accuracy of data. Create and maintain comprehensive documentation for data processes, ensuring knowledge transfer and system transparency as well as contribute to development of the data migration playbook. Make improvement and process recommendations that have an impact on the business How this opportunity is different Aon has transitioned to a product-oriented model and is investing in capabilities like never before. This role will give the chosen candidate a unique opportunity to shape the architecture for our Commercial Risk Ecosystem to drive significant revenue and efficiency opportunities across all countries where Aon operates. Skills and experience that will lead to success Extensive experience (5+ years) as a Data Engineer or a similar role Proficiency in SQL, Python, and PySpark for data processing and transformation. Proven track record in using Databricks for data engineering, including cluster management, Delta Lake, Unity Catalog and other Databricks-specific features. Strong understanding of data processing, data warehousing, data lakehouse and data modelling concepts Ability to understand and address data implementation challenges Good understanding of CI/CD process and DevOps model of deploying code Excellent communication skills with the ability to simplify complex information effectively Ideally some experience with Oracle to understand the business logic for the legacy data warehouse. College Degree qualified in Business, Information Technology, Economics, Statistics, Computer Science or related field. Experience in the insurance or financial services industry is a plus How we support our colleagues In addition to our comprehensive benefits package, we encourage a diverse workforce. Plus, our agile, inclusive environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions, but we also recognise that flexibility goes beyond just the place of work... and we are all for it. We call this Smart Working! Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued. Aon values an innovative, diverse workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace. Aon provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status. We welcome applications from all and provide individuals with disabilities with reasonable adjustments to participate in the job application, interview process and to perform essential job functions once onboard. If you would like to learn more about the reasonable accommodations we provide, email ReasonableAccommodations@Aon.com #LI-RK2 2552836