Data & Reporting Automation Associate - Power BI & Python

AIA Shared Services; Putrajaya; On-site; MYR 94,000 - 166,000; Full time

Job summary

AIA Shared Services is hiring to deliver operational reporting and automation across Hong Kong Insurance Operations. The Associate will build, maintain and automate recurring reports and dashboards using Excel, Power BI and Python to improve accuracy and efficiency.

You will collaborate with cross-functional teams to understand requirements, transform data from multiple sources and ensure timely, transparent reporting that supports business decisions and oversight.

Qualifications

• Experience building and maintaining automated reports and dashboards in Excel, Power BI, and Python.
• Ability to collect, validate, and transform data from multiple sources.
• Collaborate with business users to understand reporting requirements.

Responsibilities

• Prepare and maintain scheduled reports and dashboards for operational teams and management.
• Automate repetitive reporting tasks using Excel macros, Power BI automations, and Python scripts.
• Collect, validate, and transform data from multiple sources to ensure data integrity.
• Collaborate with business users to understand reporting requirements and ensure timely delivery.
• Troubleshoot issues in reporting tools and automation processes to maintain accuracy.
• Document reporting processes and automation workflows for transparency.
• Work with cross-functional teams to ensure data collection and reporting alignment.
• Provide first-level support for reporting requests and assist senior team members.
• Participate in backlog grooming to prioritize enhancements.

Skills

Excel

Power BI

Python

Tools

Excel macros

Power BI automations

Python scripts

Job description

AIA Shared Services is hiring to deliver operational reporting and automation across Hong Kong Insurance Operations. The Associate will build, maintain and automate recurring reports and dashboards using Excel, Power BI and Python to improve accuracy and efficiency.

You will collaborate with cross-functional teams to understand requirements, transform data from multiple sources and ensure timely, transparent reporting that supports business decisions and oversight.