Lead Analyst, Actuarial and Finance ETL Application Support

AIA; Kuala Lumpur; On-site; MYR 120,000 - 180,000; Full time

Job summary

AIA Digital+ in Kuala Lumpur is seeking an ETL Production Support professional to ensure stability, reliability, and timely delivery of ETL BAU operations across all data pipelines. You will own production support, oversee batch jobs with Autosys, and communicate with stakeholders during incidents.

You will analyze data flows, perform root cause analysis, drive improvements, and contribute to governance and documentation.

Responsibilities

• Own end-to-end ETL BAU operations across all ETL modules and data pipelines, ensuring batch stability and data availability.
• Oversee execution and monitoring of Autosys batch jobs and data pipelines.
• Act as incident lead for ETL production issues, including high-severity incidents and RCA.
• Coordinate with stakeholders and cross-functional teams for issue resolution and recovery.
• Identify risks, drive improvements, and contribute to governance, SOPs and runbooks.

Job description

Are you ready to shape a better tomorrow? AIA Digital+ is a Technology, Digital and Analytics innovation hub dedicated to powering AIA to be more efficient, connected and innovative as it fulfils its Purpose to help millions of people across Asia-Pacific live Healthier, Longer, Better Lives. If you are hungry and driven to play an active role in shaping a better tomorrow, we want to hear from you. Because the work we do at AIA Digital+ makes a difference in the lives of millions of people, every day. We will equip you with the critical skills, tools and technology, and endless opportunities to learn, contribute and thrive in a dynamic and exciting environment. If you want to shape a brighter future at AIA Digital+, please read on.

About the Role

• Ensure end-to-end stability, reliability, and timely delivery of ETL BAU operations across all ETL modules and data pipelines, ensuring seamless data processing and availability for business consumption.
• Own ETL production support in alignment with SLAs.
• Act as operational leads in incidents and stakeholder communication.
• Requires operational ownership and decision-making.

Operational Ownership & Delivery

• Own end-to-end ETL BAU operations, ensuring batch stability, data availability, and SLA adherence.
• Oversee execution and monitoring of Autosys batch jobs, ETL workflows, and data pipelines.
• Ensure data accuracy, completeness, reconciliation, and timely delivery for downstream business consumption.
• Proactively identify potential risks and operational weaknesses to prevent service disruption.

Incident Management & Decision Making

• Act as incident lead for ETL production issues, including high-severity and cross-system incidents.
• Perform impact assessment and determine recovery strategies (reruns, workarounds, data correction).
• Serve as escalation point for complex issues beyond L1/L2 support.
• Oversee troubleshooting activities, ensuring accurate root cause identification and effective resolution approach.
• Conduct deep-dive investigations using SQL (T‑SQL / PL/pgSQL) to validate, trace, and correct data issues.
• Analyse end-to-end data flows and system dependencies to accurately identify root causes.
• Lead Root Cause Analysis (RCA) and ensure implementation of preventive and corrective actions.

Stakeholder & Communication Management

• Act as the primary operational contact for business users and internal stakeholders on ETL-related matters.
• Provide clear, timely, and structured communication during incidents and service disruptions.
• Collaborate closely with Infrastructure, AIA Group teams, and cross-functional partners to resolve issues efficiently.
• Coordinate with external vendors and third-party providers for issue resolution and system recovery.
• Support internal and external audits by providing accurate operational evidence and responses.

Process Governance & Continuous Improvement

• Ensure ETL operational activities comply with security, audit, and IT governance standards.
• Identify process gaps and drive continuous improvement initiatives, including automation and monitoring enhancements.
• Maintain, enhance, and enforce operational documentation such as SOPs, runbooks, and knowledge bases.
• Contribute to DR drills, validation activities, and recovery assurance processes.

Build a career with us as we help our customers and the community live healthier, longer, better lives.

You must provide all requested information, including Personal Data, to be considered for this career opportunity. Failure to provide such information may influence the processing and outcome of your application. You are responsible for ensuring that the information you submit is accurate and up-to-date.

At AIA we’ve started an exciting movement to create a healthier, more sustainable future for everyone. It's about finding new ways to not only better people's lives, but to better the communities and environments we live in. As the largest listed company on the Hong Kong Stock Exchange, we’ve been proudly making a difference for people and communities across Asia for over a century. And we build on this every day with our ambition to engage one billion people to live Healthier, Longer, Better Lives by 2030. If you work at AIA, you play an important part in this movement. Which is why we give you every opportunity to learn, grow and shape your career - your way. Inspiring and supporting you to thrive - not just at work, but in life. Believe in better with AIA.

View our AIA LinkedIn page Bring your difference to AIA