Data Architect & Modeller - Reporting & Business Intelligence 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 drive our Reporting & Business Intelligence architecture strategy for our new Commercial Risk Solutions ecosystem. Overarching responsibilities include helping to define the architecture and data models for delivering global and country-specific reports, and overseeing delivery as part of a global strategic multi-workstream programme. On a day-to-day level this will require the candidate to: Engage country-level Finance and Operational teams to understand the gap between local needs and global reporting capabilities, truly understanding how data is used in the field. Collaborate with Product Manager to refine the vision for a global Reporting & BI capability within the Commercial Risk Solutions Ecosystem covering financial and operations reporting (incl. regulatory). Define the data flows, the data models (entity relationships) and data technology stack requirements that will ensure successful delivery on our vision. Work with Business/Technical Analysts on creating the required user stories and ensuring they are clearly defined, well understood and properly estimated. Support a cross-functional Agile team consisting of Finance SMEs, Data Analysts, Data Engineers, Business Analysts, Scrum Master etc. to deliver with quality. Act as a key contributor and collaborator on Aon’s common data standards to support the exchange of data within and across Aon solution lines and geographies Ensure successful data integration with regional and global warehouses, internal financial systems and external fiduciary/regulatory bodies. Adhere to and advance Aon’s approach to data quality improvement as it relates to reporting for the Commercial Risk Solutions ecosystem. Collaborate with other architects within the ecosystem to ensure collective delivery of the programme. Collaborate with internal Data & Analytics functions to advance the adoption of BI and AI within Aon. How this opportunity is different Aon is investing in it’s ecosystem of products and capabilities like never before. This role will give the chosen candidate a unique perspective to shape the data and analytics strategy within this ecosystem as part of our product-oriented delivery model. Skills and experience that will lead to success 8-10 years experience in a Data Engineering/Modeller/Architecture role, with at least 3 years experience in designing data flows and models. Strong proficiency with relational databases, warehousing and medallion lake-house technology - SQL Server, Oracle, Databricks, Snowflake, Azure Blob Storage / AWS S3. Strong understanding of database normalisation, dimensional (star schema) models, NoSQL Strong proficiency in logical and physical data model design and broader data architecture patterns for batch and (near) real-time jobs. Strong proficiency in most of: SQL, python incl. spark data processing on Databricks/Jupyter/Airflow, PowerBI (or Tableau/Qlik), AI/ML incl. GenAI. Perspectives and principles on how to implement and govern enterprise data standards. Familiarisation and some proficiency in all areas of data-related disciplines: data analysis and visualisation, data quality, data warehousing, (big) data engineering, financial reporting. Experience with Azure cloud services – IaaS, DBaaS and PaaS offerings. Agile knowledge – Scrum, Kanban, TDD and other practices. Certification desirable. Experience in technical accounting solutions for insurance policy management, or in financial systems a plus. College degree in IT-related discipline. 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 2024-83835