Investment Data & Analytics Engineer

AIA Hong Kong and Macau; Singapore; On-site; SGD 70,000 - 110,000; Full time

Job summary

AIA Investment Management in Singapore is seeking a Data & Analytics Analyst to develop, maintain, and enhance analytical datasets, data models, and transformation workflows supporting investment reporting and KPI monitoring.

You will work with stakeholders across Front Office, Middle Office, Operations, and Risk to deliver dashboards in Power BI, automate data workflows in Python, and contribute to AI-enabled analytics initiatives, while ensuring data quality and governance.

Qualifications

• Degree in Data Science, Computer Science, Information Systems, Engineering, Mathematics, Statistics, Finance, or related discipline.
• Min 1 year of relevant experience in analytics engineering, business intelligence, automation, data analytics, or related disciplines.
• Strong proficiency in Python, SQL, Power BI, and Microsoft Excel.
• Experience working with data transformation, ETL/ELT concepts, and data quality validation processes.
• Experience developing dashboards, reporting solutions, and analytical datasets.
• Strong analytical, problem-solving, and stakeholder engagement skills.
• Ability to translate business requirements into practical analytics and reporting solutions.
• Experience with Azure Databricks, Unity Catalog, Power Automate, REST APIs, Git, cloud data platforms, or AI-assisted development tools is advantageous.

Responsibilities

• Develop, maintain, and enhance analytical datasets, data models, and transformation workflows supporting investment and operational reporting requirements.
• Support ingestion, integration, validation, and documentation of investment and business data while ensuring datasets are scalable and reusable.
• Implement data quality controls, reconciliation checks, and validation processes for reliability of outputs.
• Design, develop, and maintain Python-based automation solutions to improve efficiency and enable AI-enabled analytics.
• Develop and maintain Power BI dashboards, management reports, and analytical solutions for stakeholders.

Skills

Python

SQL

Power BI

Excel

ETL/ELT concepts

Data analysis

Stakeholder engagement

Education

Degree in Data Science, Computer Science, Information Systems, Engineering, Mathematics, Statistics, Finance, or related discipline

Tools

Azure Databricks

Unity Catalog

Power Automate

REST APIs

Git

Cloud data platforms

AI-assisted development tools

Job description

AIA Investment Management in Singapore is seeking a Data & Analytics Analyst to develop, maintain, and enhance analytical datasets, data models, and transformation workflows supporting investment reporting and KPI monitoring.

You will work with stakeholders across Front Office, Middle Office, Operations, and Risk to deliver dashboards in Power BI, automate data workflows in Python, and contribute to AI-enabled analytics initiatives, while ensuring data quality and governance.