Analytics Data Engineer: Lakehouse & Data Pipelines

Aon Corporation; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

Aon is seeking an Analytics Data Engineer in Singapore to design and deliver analytics workflows. You will collaborate with actuarial, analytical, and technical stakeholders to specify methodologies, data inputs, rules, and outputs, and implement them in SQL, Python, and Databricks.

The role focuses on building curated data layers, validating outputs, and maintaining modern data pipelines across lakehouse architectures for dashboards and reports.

Qualifications

• Strong hands-on SQL skills with complex queries and analytics.
• Practical Python experience for data analysis and automation.
• Experience with Databricks or lakehouse platforms for analytics workflows.
• Ability to translate business and methodological requirements into datasets and mappings.
• Proficiency in data manipulation, validation, and statistical testing.
• Experience designing analytical data models, derived tables, and views.
• Understanding ETL/ELT principles and data quality checks.

Responsibilities

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

Skills

SQL

Python

Excel

Statistics

Data validation

Data mappings

ETL/ELT

Data models

Tools

Databricks

Spark

PowerBI

Tableau

Job description

Aon is seeking an Analytics Data Engineer in Singapore to design and deliver analytics workflows. You will collaborate with actuarial, analytical, and technical stakeholders to specify methodologies, data inputs, rules, and outputs, and implement them in SQL, Python, and Databricks.

The role focuses on building curated data layers, validating outputs, and maintaining modern data pipelines across lakehouse architectures for dashboards and reports.