Lead Analyst, Actuarial and Finance ETL Application Support (Azure Cloud)

AIA Digital+; Kuala Lumpur; On-site; MYR 180,000 - 240,000; Full time

Job summary

AIA Digital+ is seeking a Lead Analyst for Actuarial and Finance ETL Application Support (Azure Cloud) to ensure end-to-end stability and timely delivery of ETL BAU operations across data pipelines, enabling reliable data for business consumption.

The role requires strong incident leadership, hands-on SQL, Autosys batch knowledge, and ITIL-aligned governance. Collaboration with Infrastructure and partner teams is essential to maintain data quality and audit readiness.

Qualifications

• Minimum 5+ years in application support, data support, or ETL production environments.
• End-to-end ETL production support and service ownership.
• Incident leadership and operational decision-making.
• Stakeholder communication during business-critical incidents.

Responsibilities

• Own end-to-end ETL BAU operations, ensuring batch stability, data availability, SLA adherence, and reliable execution of batch jobs and data pipelines.
• Lead ETL production incidents, including high-severity issues, performing RCA to prevent recurrence.
• Provide functional leadership to the L2 ETL support team and oversee issue resolution and workload coordination.
• Coordinate with Infrastructure, AIA Group teams, vendors, and partners for issue resolution and audit evidence.
• Maintain SOPs, runbooks, and knowledge bases; drive automation and monitoring improvements; support DR drills and recovery validation.

Skills

ETL production support

SQL (T-SQL / PostgreSQL)

Azure data platforms (HDInsight, Synp​

Linux / Windows familiarity

Education

Bachelor's Degree in IT, Computer Science, or related discipline

Tools

ETL tools: Informatica, DataStage

Job description

Lead Analyst, Actuarial and Finance ETL Application Support (Azure Cloud)

Position Objective

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.

Roles and Responsibilities

• Operational Ownership & Delivery: Own end-to-end ETL BAU operations, ensuring batch stability, data availability, SLA adherence, and the reliable execution of Autosys batch jobs, ETL workflows, and data pipelines, while maintaining data quality and minimizing operational risks.
• Incident Management & Decision Making: Lead ETL production incident resolution, including high-severity issues, by performing impact assessments, driving recovery actions, troubleshooting complex problems, conducting SQL (T-SQL / PL/pgSQL) investigations, and leading Root Cause Analysis (RCA) to prevent recurrence.
• Team Leadership & Oversight: Provide functional leadership to the L2 ETL support team through oversight of issue resolution, workload coordination, critical-cycle support coverage, and guidance on complex troubleshooting and operational decisions.
• Stakeholder & Communication Management: Serve as the primary contact for ETL operations, managing stakeholder communications, coordinating with Infrastructure, AIA Group teams, vendors, and partners for issue resolution, and supporting audit activities with required operational evidence.
• Process Governance & Continuous Improvement: Ensure compliance with security, audit, and IT governance standards by maintaining SOPs, runbooks, and knowledge bases, driving automation and monitoring improvements, and supporting DR drills, validation, and recovery assurance activities.

Requirements

Education

Bachelor’s Degree in IT, Computer Science, or related discipline.

Experience

Minimum 5+ years in application support, data support, or ETL production environments.

Demonstrated experience in:

• End-to-end ETL production support and service ownership.
• Incident leadership and operational decision-making.
• Stakeholder communication during business-critical incidents.

Technical skills

• Strong hands-on experience with ETL tools (e.g., Informatica, IBM DataStage).
• Proficiency in SQL (T-SQL / PostgreSQL) for data investigation, validation, and correction.
• Solid understanding of Data warehouse concepts.
• Solid understanding of Batch scheduling tools (e.g., Autosys).
• Experience supporting ETL in cloud and distributed environments.
• Exposure to Azure data platforms (HDInsight, Synapse Analytics).
• Familiarity with Linux and Windows operating systems.
• Knowledge of ITIL processes (Incident, Problem, Change); certification is an advantage.
• Experience with DR drills and recovery validation is an advantage.

Soft Skills

• Strong analytical and problem-solving abilities in high-pressure environments.
• Sound judgment and decision-making during time-critical incidents.
• Clear, confident communication with technical and non-technical stakeholders.
• Strong ownership mindset with accountability for service outcomes.
• Ability to guide and influence team members to achieve quality results.