Associate Data Engineer

Associate Data Engineer

**Associate 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.

**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.
- 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.

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.

LI-HT1

2541981

Job ID 76896