Data Engineering, Consultant

AIA Shared Services; Kuala Lumpur; Hybrid; MYR 180,000 - 320,000; Full time

Job summary

AIA Shared Services in Kuala Lumpur is seeking a hands-on Senior Data Engineer to design, implement, and integrate advanced data pipelines and AI solutions across the enterprise. You will act as technical lead for data engineering initiatives, manage end-to-end delivery, govern security and governance, and collaborate with application teams for scalable platforms.

Required: 8–10 years in data engineering, PySpark, SQL, Delta Lake, Databricks, Azure Databricks, and cloud skills; insurance domain

Qualifications

• 8–10 years in data engineering design and development.
• Experience planning end-to-end delivery across projects.
• Strong engagement with business users and stakeholders.
• Proven Azure Databricks data engineering experience.

Responsibilities

• Design, build, and optimize scalable data pipelines and architectures.
• Lead integration with Enterprise data platforms for digital applications.
• Define BAU support model post-implementation and drive continuous improvement.
• Manage vendor relationships and governance for security and performance.
• Stay current with data engineering tech and champion best practices.

Skills

PySpark

SQL

Delta Lake

Databricks Platform

Lakehouse Architecture

Education

Bachelor of Science in Computer Science or related

Tools

Azure Databricks

ADLS Gen2

Azure Data Factory

Azure DevOps

Structured Streaming (Kafka/Event Hub)

Job description

At AIA we’ve started an exciting movement to create a healthier, more sustainable future for everyone. As pioneering innovators for over 100 years, we’re now transforming our organisation to be faster, simpler and more connected. Because we want to be even better equipped to develop digital solutions and experiences that help more people live Healthier, Longer, Better Lives. To get there, we need people with tech/digital/analytics expertise and passion to help develop positive, sustainable change through digitally enhanced experiences that will impact the lives of millions of people and create a healthier future for everyone. If you believe in developing a better tomorrow, read on.

About the Role

This role is hands-on and will focus on designing, implementing, and integrating advanced data engineering with AI solutions integration across the enterprise.

Roles and Responsibilities:

• Technical Leadership Act as the technical lead for data engineering initiatives. Design, build, and optimize scalable data pipelines and architectures using enterprise tools and software. Drive integration of API services and components together with enterprise data platforms for digital applications.
• Project Delivery & Integration Collaborate with internal application teams to align on project deliverables, timelines, integration requirements, and implementation strategies. Ensure adherence to company processes for services and infra provisioning, including user access management and compliance with governance standards. Oversee end-to-end project execution, from design through deployment.
• Operation Excellence Define and establish the Business-As-Usual (BAU) support model post-project implementation. Participate in BAU support activities as needed, ensuring smooth operations and issue resolution. Drive continuous improvement in data engineering practices and operational processes.
• Vendor & Stakeholder Management Serve as the primary technical liaison with external vendors, ensuring deliverables meet quality, security, and performance standards. Manage vendor relationships to align with project goals, budgets, and timelines. Communicate effectively with stakeholders across business and technology teams.
• Innovation & Best Practices Stay current with emerging Data Engineering technologies and assess their applicability to enterprise data solutions. Champion best practices in data engineering, cloud architecture, and AI integration. Contribute to the development of enterprise standards, frameworks, and reusable components.
• Governance & Compliance Adhere to company governance processes for Azure service provisioning, access management, and security compliance. Work closely with the Group CCoE and technical counterparts for component provisioning, user access, and platform governance.

Minimum Job Requirements:

• Min 8-10 years of data engineering design and development.
• Plan and manage end-to-end delivery and work assignments within the assigned projects.
• Excellent skills in Business user engagement and stakeholder management.
• Experienced in engaging business stakeholders for requirement analysis and discussions.
• Strong experience in Azure Databricks Data Engineering in the following context.

Must-Have Skills:

• 1) PySpark Building data pipelines Data transformations Spark performance tuning
• 2) SQL Complex queries Joins, window functions Data modeling
• 3) Delta Lake MERGE (upsert) Time Travel Partitioning OPTIMIZE and VACUUM
• 4) Databricks Platform Notebooks Workflows/Jobs Cluster management Git integration
• 5) Lakehouse Architecture Bronze, Silver, Gold layers ETL/ELT design

Important Skills:

• 1) Cloud Knowledge Azure Databricks (preferred for many enterprises) ADLS Gen2 ADF Azure DevOps
• 2) Streaming Auto Loader Structured Streaming Kafka or Event Hub
• 3) Governance & Security Unity Catalog Access control Data lineage

Nice-to-Have Skills:

• 1) DevOps/DataOps CI/CD pipelines Terraform Databricks Asset Bundles
• 2) Programming Python (mandatory) Scala (optional) - Sound experience in execution of IT projects with high level of expertise in system application and technology implementation delivery.
• 3) Strong communication skills with ability to communicate with stakeholders.
• 4) Strong analytical and problem-solving skills.
• 5) Domain proficiency in insurance business and its operations.
• 6) Able to work independently and highly self-motivated.
• 7) Able to work with peers and other stakeholders, a team. player experience and best practices in financial industries.
• 8) Bachelor of Science Degree in Computer Science or related.
• #LI-DNI

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.

"Better" starts with people who reimagine what is possible and turn ideas into meaningful action. At AIA, you will contribute in your own way, help shape outcomes that matter and collaborate with colleagues across disciplines, teams, markets and levels. We will support you to broaden your perspective, strengthen your capabilities and grow your impact. Together, we challenge assumptions, learn from one another and find better ways forward. Bring your ambition, experience and ideas to AIA, and help shape what “better” looks like.

View our AIA LinkedIn page Bring your difference to AIA