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

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

Job summary

AIA Digital+ Malaysia seeks a Lead Analyst to own end-to-end ETL BAU operations across data pipelines and Azure Cloud. You will lead high-severity incidents, perform SQL investigations, and drive problem resolution while guiding the L2 ETL support team.

Ideal candidates will have 5+ years in ETL/support, strong data warehousing knowledge, and experience with Informatica, IBM DataStage, and Autosys. The role requires collaboration with multiple stakeholders and adherence to IT governance.

Qualifications

• Minimum 5+ years in application support, data support, or ETL production environments.
• Experience with end-to-end ETL production support and service ownership.
• Strong incident leadership and operational decision-making.
• Excellent stakeholder communication during critical incidents.

Responsibilities

• Own end-to-end ETL BAU operations, ensuring data availability and SLA adherence.
• Lead production incidents, perform RCA, and drive recovery actions.
• Provide functional leadership to L2 ETL support and coordinate workloads.
• Coordinate with Infrastructure, vendors, and partners for issue resolution.
• Ensure SOPs, runbooks, and knowledge bases are maintained and improved.

Skills

ETL Production

Incident Leadership

Stakeholder Communication

Automation & Monitoring

Team Guidance

Education

Bachelor’s Degree in IT/CS

Tools

Informatica

IBM DataStage

Autosys

Azure Synapse

HDInsight

Job description

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

In AIA Digital+, we serve as AIA’s Group-led Technology, Digital & Analytics hub by evolving innovative technology to shape the future. We aim to design & develop a detailed, human centered experiences to positively impact the lives of millions of people.

Join us as a part of AIA Group today!

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.
• 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.

AIA Digital+ Malaysia (AIA IT (M) Sdn. Bhd. (202201010550)(1456247-A)) 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.

AIA Digital+ Malaysia (AIA IT (M) Sdn. Bhd. (202201010550)(1456247-A)) 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.