Analytics Data Engineer

Aon; Singapore; On-site; SGD 60,000 - 100,000; Full time

Job summary

Aon is seeking a data analyst with strong modern data engineering capabilities to join our analytics team in Singapore. You will collaborate with business, actuarial, analytical, and technical stakeholders to translate requirements into reliable datasets, derived tables, and analytics-ready outputs.

You will apply SQL, Python, and Databricks to build and validate data pipelines, design data models, and support dashboards, reports, and downstream analytics users across the organization.

Qualifications

• Strong hands-on SQL skills with complex queries, joins, and analytics transformations.
• Practical Python experience for data analysis, transformation, validation, or automation.
• Experience with Databricks, Spark-based processing, notebooks, jobs, Delta tables or lakehouse platforms.
• Ability to implement and validate analytical or statistical methodology using data, rules, and assumptions.
• Data manipulation and analysis using Excel to demonstrate methodology/algorithms.
• Solid understanding of descriptive statistics, distributions, segmentation, outlier handling, reasonableness checks.
• Experience designing analytical data models, derived tables, reporting views, or curated datasets for dashboards or front-end consumption.
• Translate business or methodology requirements into data mappings, transformations, test cases, and production-ready datasets.
• Good understanding of ETL/ELT principles, data quality checks, and data lifecycle management.
• High attention to detail, curiosity, and quick learning in a fast-moving data environment.

Responsibilities

• Work with business, actuarial, analytical, and technical stakeholders to understand the analytics methodology, data inputs, business rules, and outputs.
• Build and/or apply analytics methodology on structured and semi-structured datasets using SQL, Python, and Databricks workflows.
• Design derived tables, views, and curated data layers aligned with methodology for dashboards, reports, and downstream users.
• Perform statistical analysis, data profiling, exploratory analysis, and result interpretation to support methodology design and validation.
• Test methodology implementation and outputs, including reconciliation, edge-case testing, data quality checks, and comparisons against expected results.
• Support data pipelines development, maintenance, and optimization using Databricks, SQL, Python and lakehouse patterns.
• Document data mappings, transformation logic, assumptions, and validation steps to ensure transparency and maintainability.
• Assist in support, enhancements, troubleshooting, and continuous improvement of data pipelines and analyses.

Skills

SQL

Python

Databricks

Statistical analysis

Data modeling

Data quality

Excel

ETL/ELT

Dashboarding

Tools

Databricks

Spark

Delta tables

SQL warehouses

Lakehouse patterns

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 team and we are passionate about helping our colleagues and clients succeed.

What The Day Will Look Like

• Work with business, actuarial, analytical, and technical stakeholders to understand the intended analytics methodology, data inputs, business rules, and expected outputs.
• Build and/or apply analytics methodology on top of structured and semi-structured datasets using SQL, Python, and Databricks-based workflows.
• Design derived tables, views, and curated data layers that align with analytical methodology and are suitable for consumption by front-end applications, dashboards, reports, and downstream users.
• Perform statistical analysis, data profiling, exploratory analysis, and result interpretation to support methodology design and validation.
• Test methodology implementation and analytical outputs, including reconciliation, edge-case testing, data quality checks, and comparison against expected business or statistical results.
• Support the design, development, maintenance, and optimization of modern data pipelines and transformation logic using Databricks, SQL, Python, and lakehouse patterns.
• Document data mappings, transformation logic, assumptions, methodology rules, validation steps, and known limitations so that outputs are transparent and maintainable.
• Assist in support, enhancements, troubleshooting, and continuous improvement of existing data pipelines, analytical datasets, and methodology implementations.

How This Opportunity Is Different

We are seeking a data analyst with strong modern data engineering capabilities who is keen to work at the intersection of analytics methodology, data modelling, and scalable data delivery. The right individual will have a meticulous eye for data, a strong foundation in SQL, Python, and statistical analysis, and the ability to translate business and methodological requirements into reliable datasets, derived tables, views, and analytics-ready outputs. This person will work closely with actuarial analysts, developers, data engineers, and business stakeholders to understand analytical needs, build or apply the required methodology, validate implementation results, and ensure that curated data assets can be consumed effectively by front-end applications, dashboards, and downstream analytics users. In this role, you will work with modern lakehouse technologies such as Databricks, SQL-based analytics, Python, and structured data modelling practices, while also applying robust analytical thinking to ensure that methodology outputs are accurate, explainable, and production-ready. In addition to hands-on delivery, this role is part of Aon’s talent growth strategy; success in this position can lead to broader opportunities in data engineering, analytics solution design, and technical leadership.

Skills And Experience That Will Lead To Success

• Strong hands-on SQL skills, including writing complex queries, joins, aggregations, window functions, views, and analytical transformations.
• Practical Python experience for data analysis, data transformation, validation, automation, or analytical implementation.
• Experience or strong interest in working with Databricks, Spark-based processing, notebooks, jobs, SQL warehouses, Delta tables, or lakehouse-style data platforms.
• Ability to understand, implement, and validate analytical or statistical methodology using data, business rules, and clearly defined assumptions.
• Experience in data manipulation and data analysis skills via Excel to demonstrate methodology/algorithms
• Good understanding of statistical analysis concepts, including descriptive statistics, distributions, segmentation, outlier handling, reasonableness checks, and interpretation of analytical results.
• Experience designing analytical data models, derived tables, reporting views, or curated datasets for dashboard, application, or front-end consumption.
• Able to translate requirements from business or methodology documents into data mappings, transformation logic, test cases, and production-ready datasets.
• Good understanding of ETL/ELT principles, data quality checks, pipeline maintainability, performance considerations, and data lifecycle management.
• Strong attention to detail, curiosity, and willingness to learn new technologies quickly in a fast-moving data and analytics environment.

Nice To Haves

• Experience with BI Visualization tools (PowerBI, Tableau, etc.) is an advantage
• Experience with software web development is an advantage