Senior Data Engineer We are seeking a data engineer who is a team player and extremely keen in pushing themselves to learn new skills on the job or off the job. The right individual for this role will need to have a meticulous eye for data and appreciates the process of wrangling, storing and understanding data. This person will work with a team of experienced actuarial analysts, developers and business resources to build databases, warehouses and ETL/ELT pipelines to fuel modern web applications and visualizations that deliver insightful analytics to the users. 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 team and we are passionate about helping our colleagues and clients succeed. What the day will look like + Collaborate with teams of experienced actuaries, developers and business experts to deliver projects + Design and propose end-to-end data pipelines ((ingestion to storage to consumption) for data projects as well as databases to support web-based applications + Design and implement data warehouses and data marts to serve data consumers + Execute implementation of the designs and bring it from design stages to implementation followed by operationalization to maintenance + Database design and modelling. To be able to organize data at both macro and micro level and provide logical data models for the consumers + Database performance tuning and data lifecycle management + Assist in support and enhancements of existing data pipelines and databases How this opportunity is different As a data engineer in the Singapore Aon Innovation Centre, you will have an opportunity to work with newer modern technologies as well as tried and tested traditional technologies in the data ingestion/wrangling/storage toolchain. In addition to the hands-on opportunities, this is a role that will be part of the talent growth strategy of Aon. Being successful in this role would lead to technical and people leadership opportunities in the future. Skills and experience that will lead to success + 6+ years of total experience working in data engineering. + 2+ years of in-depth experience developing data pipelines within an Apache Spark environment (preferably Databricks). + 1+ years of active hands-on work with Databricks, demonstrating in-depth experience. + Good experience in building data pipelines that ingests various types of data sources into a database or data lake and populating a structured warehouse or data mart that fuels the data consumer. + Fluent in both complex SQL query performance tuning and database performance tuning + Good knowledge of data modelling, database technologies, data warehousing. + Have experience in building and designing data warehouses/data marts + Understand the importance of performance and able to implement best practices in ensuring performance and maintainability for data-centric projects + This person is required to be dynamic and be a quick eager learner as knowledge about new technologies will need to be acquired on the spot + Experience with BI and analytics tools like Power BI or Tableau. Nice to haves: + Experience integrating AI into data engineering. + Certifications in Databricks, cloud computing or database management. + Experience developing data solutions using native IaaS and PaaS solutions on AWS (RDS, S3). + Experience in any object-oriented programming language. How we support our colleagues In addition to our comprehensive benefits package, we encourage an inclusive workforce. Plus, our agile 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 for our colleagues as well. 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 and inclusive 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 are committed to providing equal employment opportunities and fostering an inclusive workplace. If you require accommodations during the application or interview process, please let us know. You can request accommodations by emailing us at ReasonableAccommodations@Aon.com or your recruiter. We will work with you to meet your needs and ensure a fair and equitable experience. #LI-PC1 2566200 Senior Data Engineer We are seeking a data engineer who is a team player and extremely keen in pushing themselves to learn new skills on the job or off the job. The right individual for this role will need to have a meticulous eye for data and appreciates the process of wrangling, storing and understanding data. This person will work with a team of experienced actuarial analysts, developers and business resources to build databases, warehouses and ETL/ELT pipelines to fuel modern web applications and visualizations that deliver insightful analytics to the users. 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 team and we are passionate about helping our colleagues and clients succeed. What the day will look like + Collaborate with teams of experienced actuaries, developers and business experts to deliver projects + Design and propose end-to-end data pipelines ((ingestion to storage to consumption) for data projects as well as databases to support web-based applications + Design and implement data warehouses and data marts to serve data consumers + Execute implementation of the designs and bring it from design stages to implementation followed by operationalization to maintenance + Database design and modelling. To be able to organize data at both macro and micro level and provide logical data models for the consumers + Database performance tuning and data lifecycle management + Assist in support and enhancements of existing data pipelines and databases How this opportunity is different As a data engineer in the Singapore Aon Innovation Centre, you will have an opportunity to work with newer modern technologies as well as tried and tested traditional technologies in the data ingestion/wrangling/storage toolchain. In addition to the hands-on opportunities, this is a role that will be part of the talent growth strategy of Aon. Being successful in this role would lead to technical and people leadership opportunities in the future. Skills and experience that will lead to success + 6+ years of total experience working in data engineering. + 2+ years of in-depth experience developing data pipelines within an Apache Spark environment (preferably Databricks). + 1+ years of active hands-on work with Databricks, demonstrating in-depth experience. + Good experience in building data pipelines that ingests various types of data sources into a database or data lake and populating a structured warehouse or data mart that fuels the data consumer. + Fluent in both complex SQL query performance tuning and database performance tuning + Good knowledge of data modelling, database technologies, data warehousing. + Have experience in building and designing data warehouses/data marts + Understand the importance of performance and able to implement best practices in ensuring performance and maintainability for data-centric projects + This person is required to be dynamic and be a quick eager learner as knowledge about new technologies will need to be acquired on the spot + Experience with BI and analytics tools like Power BI or Tableau. Nice to haves: + Experience integrating AI into data engineering. + Certifications in Databricks, cloud computing or database management. + Experience developing data solutions using native IaaS and PaaS solutions on AWS (RDS, S3). + Experience in any object-oriented programming language. How we support our colleagues In addition to our comprehensive benefits package, we encourage an inclusive workforce. Plus, our agile 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 for our colleagues as well. 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 and inclusive 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 are committed to providing equal employment opportunities and fostering an inclusive workplace. If you require accommodations during the application or interview process, please let us know. You can request accommodations by emailing us at ReasonableAccommodations@Aon.com or your recruiter. We will work with you to meet your needs and ensure a fair and equitable experience. #LI-PC1