Lead Analyst, Actuarial and Finance ETL Application Support

AIA (Vietnam) Life Insurance

Kuala Lumpur

On-site

MYR 120,000 - 180,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

AIA Digital+ is an innovation hub within AIA dedicated to technology, digital and analytics across Asia-Pacific. The role focuses on end-to-end ETL BAU operations, production support, incident management and data integrity across data pipelines.

You will own batch runs in Autosys, monitor data flows, and collaborate with cross-functional teams to resolve issues and improve processes. The ideal candidate has hands-on experience with SQL-based data validation, RCA, and strong communication with

Qualifications

  • Hands-on experience with end-to-end ETL BAU operations.
  • Ability to monitor batch jobs and data pipelines.
  • Experience in incident management and RCA using SQL.

Responsibilities

  • Own end-to-end ETL BAU operations, ensuring batch stability and SLA adherence.
  • Oversee execution and monitoring of Autosys batch jobs, ETL workflows, and data pipelines.
  • Act as incident lead for ETL production issues and coordinate recovery strategies.
  • Perform root cause analysis using SQL (T‑SQL / PL/pgSQL) to validate data issues.
  • Communicate with business users and cross-functional teams during incidents and service disruptions.
  • Maintain operational documentation (SOPs, runbooks) and drive continuous improvement.

Skills

ETL Operations
SQL (T-SQL/PLpgSQL)
Incident Management
Data pipelines

Tools

Autosys
SQL Server
PostgreSQL

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Analyst, Actuarial and Finance ETL Application Support
Lead Analyst, Actuarial and Finance ETL Application Support

AIA • Kuala Lumpur

On-site
MYR 120,000 - 180,000
Lead Analyst, ETL Support (BAU L2 Support)
Lead Analyst, ETL Support (BAU L2 Support)

AIA Digital+ • Kampung Malaysia Tambahan

On-site
MYR 120,000 - 180,000
Assistant Manager, Data Engineering
Assistant Manager, Data Engineering

Amplify Health (AIA Digital) • Kuala Lumpur

On-site
MYR 60,000 - 110,000
Lead Analyst, Technology Centre
Lead Analyst, Technology Centre

AIA (Vietnam) Life Insurance • Kuala Lumpur

On-site
MYR 90,000 - 130,000
Assistant Manager, ETL Support (BAU L2 Support)
Assistant Manager, ETL Support (BAU L2 Support)

AIA Digital+ • Kampung Malaysia Tambahan

On-site
MYR 90,000 - 140,000
Assistant Manager, Data Engineering
Assistant Manager, Data Engineering

AIA IT (M) Sdn Bhd • Kuala Lumpur

On-site
MYR 60,000 - 100,000
Assistant Manager, Data Platform Engineer
Assistant Manager, Data Platform Engineer

AIA (Vietnam) Life Insurance • Kuala Lumpur

On-site
MYR 110,000 - 160,000
Assistant Manager, Data Platform Engineer
Assistant Manager, Data Platform Engineer

AIA • Kuala Lumpur

On-site
MYR 60,000 - 90,000
Lead Analyst, HRIT
Lead Analyst, HRIT

AIA (Vietnam) Life Insurance • Kuala Lumpur

On-site
MYR 67,000 - 112,000
Lead ETL Operations Analyst – Actuarial & Finance
Lead ETL Operations Analyst – Actuarial & Finance

AIA • Kuala Lumpur

On-site
MYR 120,000 - 180,000