Analytics Data Engineer: Lakehouse & Databricks Expert

Aon plc; Singapore; On-site; SGD 90,000 - 140,000; Full time

Job summary

Aon plc in Singapore is seeking an Analytics Data Engineer to join our data and analytics team. You will collaborate with business, actuarial, and technical stakeholders to design, implement, and validate analytics-driven data pipelines and outputs.

You will leverage SQL, Python, and Databricks to build robust data models, derived tables, and dashboards, ensuring outputs are understandable, auditable, and production-ready.

Qualifications

• Strong hands-on SQL skills with complex queries, joins and window functions.
• Practical Python experience for data analysis and transformation.
• Experience with Databricks, Spark, notebooks, or lakehouse platforms.
• Ability to translate business rules into reliable datasets.
• Excel-based data manipulation and analysis experience.
• Solid statistical analysis concepts and interpretation.
• Analytical data models and curated datasets for dashboards.
• Translate requirements into data mappings and production data.
• Understand ETL/ELT, data quality checks, and maintainable pipelines.
• Attention to detail and quick learning in a fast-moving environment.

Responsibilities

• Work with stakeholders to understand analytics methodology, data inputs, and outputs.
• Build and apply analytics methodology on structured datasets using SQL, Python, and Databricks workflows.
• Design derived tables, views, and curated data layers for dashboards and reports.
• Perform statistical analysis, data profiling, and result interpretation.
• Test methodology implementation and outputs with quality checks.
• Support design, development, maintenance, and optimization of data pipelines.
• Document data mappings, transformation logic, assumptions, and validation steps.
• Assist in support, enhancements, troubleshooting, and continuous improvement of pipelines.

Skills

SQL

Python

Databricks

Statistical analysis

Excel

Data modeling

ETL/ELT

Data quality

Data visualization

Testing/validation

Tools

Databricks

Spark

Delta tables

Notebooks

SQL warehouses

Lakehouse

Job description

Aon plc in Singapore is seeking an Analytics Data Engineer to join our data and analytics team. You will collaborate with business, actuarial, and technical stakeholders to design, implement, and validate analytics-driven data pipelines and outputs.

You will leverage SQL, Python, and Databricks to build robust data models, derived tables, and dashboards, ensuring outputs are understandable, auditable, and production-ready.