Aon sp. z o.o. Data Engineer 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. What the day will look like This role will provide the candidate an opportunity to deliver enterprise-scale data workloads following a data lakehouse architecture on a modern cloud-based data stack for our new Commercial Risk Solutions Ecosystem. These data workloads represent strategic feeds to support our BI/Analytics solutions that are essential to the value proposition of our ecosystem. Responsibilities of this role include: + Cross-functional Team: Work within a cross-functional Agile team alongside Product Owner, Data Architect and Data Analysts to deliver on release goals for a global program + Data Workload Design: Design scalable and efficient data workloads architectures that integrate our transactional systems with a new lakehouse data model. + Data Integration: Develop, test and maintain data pipelines (ETL) for integrating diverse data sources into a unified format embedding best practices and standards. + Data Management: Manage and optimize data to ensure efficient data storage, retrieval, and processing. + Data Quality Management: Implement automated data quality checks and ensure data integrity throughout the migration process. + Documentation: Create and maintain comprehensive documentation for data processes, ensuring knowledge transfer, observability and supportability. + Performance Monitoring: Monitor and optimize data performance to meet defined service-level agreements. + Troubleshooting: Identify and resolve data-related issues in a timely manner, collaborating with relevant teams. 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 product and data delivery model 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 + Advanced Technical Skills: + In-depth knowledge in programming languages such as Python incl. Spark/Scala. + Experience with ETL tools and lakehouse architectures (3+years) through Databricks, Apache SparkSql and similar + Strong SQL skills for data manipulation and querying Pipeline efficiency optimization skills + Hands on experience with Agile technical practices, source versioning and Agile project management tools (Azure Repos, GitLab, Azure DevOps, Jira, Confluence, other) + Database Knowledge: Familiarity with relational and non-relational databases (Oracle, MSSQLServer). + Agile planning skills – Kanban and Scrum release/sprint planning. + Problem-Solving: Proven ability to solve complex data engineering challenges and optimize system performance. + Good communication and interpersonal skills to collaborate effectively with team members and stakeholders + College degree in STEM-related discipline. How we support our colleagues In addition to our comprehensive benefits package, we encourage a inclusive 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 Please attach CV in English only. #LI-MK1 #LI-HYBRID 2562179 Aon sp. z o.o. Data Engineer 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. What the day will look like This role will provide the candidate an opportunity to deliver enterprise-scale data workloads following a data lakehouse architecture on a modern cloud-based data stack for our new Commercial Risk Solutions Ecosystem. These data workloads represent strategic feeds to support our BI/Analytics solutions that are essential to the value proposition of our ecosystem. Responsibilities of this role include: + Cross-functional Team: Work within a cross-functional Agile team alongside Product Owner, Data Architect and Data Analysts to deliver on release goals for a global program + Data Workload Design: Design scalable and efficient data workloads architectures that integrate our transactional systems with a new lakehouse data model. + Data Integration: Develop, test and maintain data pipelines (ETL) for integrating diverse data sources into a unified format embedding best practices and standards. + Data Management: Manage and optimize data to ensure efficient data storage, retrieval, and processing. + Data Quality Management: Implement automated data quality checks and ensure data integrity throughout the migration process. + Documentation: Create and maintain comprehensive documentation for data processes, ensuring knowledge transfer, observability and supportability. + Performance Monitoring: Monitor and optimize data performance to meet defined service-level agreements. + Troubleshooting: Identify and resolve data-related issues in a timely manner, collaborating with relevant teams. 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 product and data delivery model 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 + Advanced Technical Skills: + In-depth knowledge in programming languages such as Python incl. Spark/Scala. + Experience with ETL tools and lakehouse architectures (3+years) through Databricks, Apache SparkSql and similar + Strong SQL skills for data manipulation and querying Pipeline efficiency optimization skills + Hands on experience with Agile technical practices, source versioning and Agile project management tools (Azure Repos, GitLab, Azure DevOps, Jira, Confluence, other) + Database Knowledge: Familiarity with relational and non-relational databases (Oracle, MSSQLServer). + Agile planning skills – Kanban and Scrum release/sprint planning. + Problem-Solving: Proven ability to solve complex data engineering challenges and optimize system performance. + Good communication and interpersonal skills to collaborate effectively with team members and stakeholders + College degree in STEM-related discipline. How we support our colleagues In addition to our comprehensive benefits package, we encourage a inclusive 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 Please attach CV in English only. #LI-MK1 #LI-HYBRID