Analytics Data Engineer

Aon
Singapore
Workplace: HybridFull timeFunction: Data Analytics & Business IntelligenceSkills: ["Attention to detail","Curiosity","Willingness to learn quickly"]

Work with business and actuarial stakeholders to define analytics methodology, data inputs, business rules, and expected outputs. Build analytics-ready datasets—derived tables, views, and curated lakehouse layers—using SQL, Python, and Databricks workflows. Perform statistical analysis, data profiling, exploratory work, and rigorous testing (reconciliation, edge cases, data quality). Support development and continuous improvement of modern data pipelines and document methodology and assumptions.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Aon
Aon
6 days ago

Analytics Data Engineer

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 18 hours agoStatus: Live

Job Summary

Work with business and actuarial stakeholders to define analytics methodology, data inputs, business rules, and expected outputs. Build analytics-ready datasets—derived tables, views, and curated lakehouse layers—using SQL, Python, and Databricks workflows. Perform statistical analysis, data profiling, exploratory work, and rigorous testing (reconciliation, edge cases, data quality). Support development and continuous improvement of modern data pipelines and document methodology and assumptions.
Location: Singapore
Workplace: Hybrid
Employment Type: Full time
Job Function: Data Analytics & Business Intelligence

Key Responsibilities

  • •Work with business, actuarial, analytical, and technical stakeholders to understand analytics methodology, data inputs, business rules, and expected outputs.
  • •Build and/or apply analytics methodology on structured and semi-structured datasets using SQL, Python, and Databricks-based workflows.
  • •Design derived tables, views, and curated data layers suitable for consumption by front-end applications, dashboards, reports, and downstream users.
  • •Perform statistical analysis, data profiling, exploratory analysis, and interpret results to support methodology design and validation.
  • •Test and validate methodology implementation and analytical outputs using reconciliation, edge-case testing, data quality checks, and comparisons against expected results; document mappings and assumptions.

Key Requirements

  • •Strong hands-on SQL skills, including complex queries, joins, aggregations, window functions, views, and analytical transformations.
  • •Practical Python experience for data analysis, transformation, validation, automation, or analytical implementation.
  • •Experience or strong interest working with Databricks and lakehouse-style data platforms, including Spark-based processing, notebooks, jobs, SQL warehouses, and Delta tables.
  • •Ability to understand, implement, and validate analytical or statistical methodology using data, business rules, and clearly defined assumptions.
  • •Good understanding of statistical analysis concepts, including descriptive statistics, distributions, segmentation, outlier handling, reasonableness checks, and interpretation of results.
Skills:Attention to detailCuriosityWillingness to learn quickly
Tech Stack:SQLPythonDatabricksSparkNotebooksJobsSQL warehousesDelta tablesLakehouseExcelPowerBITableau

Company Brief

Aon
Global professional services firm providing risk, retirement, human resources, and insurance brokerage solutions to clients worldwide, including consulting, reinsurance, and data-driven risk management services.
Industry: Insurance
Company Size: Enterprise (1,001+ employees)
Revenue: USD 1B+
Growth: Public Company
Valuation: Public Company (Market Cap in USD)
Funding: IPO / Publicly Listed
Headquarters: London, United Kingdom
Founded: 1982
Glassdoor
Glassdoor: 3.9
WebsiteLinkedInGlassdoor