Analytics Data Engineer: Databricks & Lakehouse Specialist

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