Associate Data Engineer

Job description

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.

About ACIA

Aon’s Centers for Innovation and Analytics are at the heart of delivering Aon’s Data & Analytic Services team’s mission to:

  • Accelerate the rate of innovation through digital solutions to help better respond to clients’ evolving needs
  • Provide foundational data and analytics capabilities in one place for 50,000 Aon colleagues and our global clients who use our risk and people solutions

Established in 2012, there are over 150 colleagues in Singapore’s Centre today including actuaries, software developers, data scientists, financial analysts and accountants. We are expanding rapidly and looking for dedicated individuals who can leverage emerging technologies and collaborate across Aon’s solution lines to help clients and colleagues make better, data-driven decisions today and tomorrow.

What The Day Will Look Like

  • Collaborate with teams of experienced actuaries, data analysts, data engineers and business experts to deliver projects.
  • Participate in the design, development of a scalable end-to-end data pipelines (ingestion to storage to consumption) for data projects as well as databases to support web-based applications.
  • Perform data analysis required to troubleshoot data related issues and assist in the resolution of data issues.
  • Implementation of data warehouse and lake house solutions to support data & analytics initiatives.
  • Assist in support and enhancements of existing data pipelines and databases.
  • Participate in database design and modelling.

How This Opportunity Is Different

Aon’s breadth of product offerings and global reach give us massive access to data and information, which in turn provides a unique opportunity to innovate and build and differentiating solutions for clients. But for Aon to capitalize on these opportunities, it requires a globally coordinated effort, an effort that the Aon Centre for Innovation and Analytics (ACIA) in Singapore is heavily investing towards.

We are seeking a associate 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.

As an associate 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.

Skills And Experience That Will Lead To Success

  • 2+ years of experience in working with a relational database system (eg. MSSQL, PostgreSQL)
  • Working knowledge on SQL and Python to perform data querying, building data models and conducting data analysis.
  • Basic knowledge in ETL/ELT processes, and implementation via SSIS or some other ELT/ETL tool.
  • Have 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.
  • Basic experience/knowledge in building the data warehouses/data marts.
  • Ability to work collaboratively with both technical and non-technical colleagues.
  • 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.
  • Some hands-on experience developing data pipelines within a Hadoop-based or Apache Spark environment (solution stack is preferably Databricks or Snowflake, but similar stacks considered) is a big advantage.
  • Some experience developing data solutions using native IaaS and PaaS solutions on AWS (Redshift, RDS, S3) will be an advantage.
  • Experience in any object oriented or functional programming language is a plus
  • Experience in any BI tools Tableau or Power BI 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


Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.