Lead Analyst, Actuarial and Finance ETL Application Support

AIA Digital+; Kuala Lumpur; On-site; MYR 100,000 - 167,000; Full time

Job summary

AIA Digital+ in Kuala Lumpur seeks a hands-on ETL Operations Lead to ensure end-to-end stability and timely delivery of ETL BAU jobs across data pipelines. You will own production support, manage Autosys jobs, and act as the interface for incidents and stakeholders.

Responsibilities include data accuracy, reconciliation, root cause analysis using SQL, and driving governance, automation, and continuous improvement to support business users and audits.

Qualifications

• End-to-end ETL BAU operations ownership.
• Incidents ownership and RCA in data environments.
• Proactive data quality, reconciliation, and delivery to business units.

Responsibilities

• Own end-to-end ETL BAU operations, ensuring batch stability and data availability.
• Oversee Autosys batch jobs, ETL workflows, and data pipelines.
• Act as incident lead for high-severity ETL production issues and coordinate recovery.

Skills

ETL operations

SQL (T-SQL/PL/pgSQL)

Incident management

Data pipelines

Tools

Autosys

SQL tooling

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.