Analytics Architect

Perbadanan Insurans Deposit Malaysia; Kuala Lumpur; On-site; MYR 180,000 - 240,000; Full time

Job summary

Perbadanan Insurans Deposit Malaysia seeks an Analytics Architect to lead the delivery and optimisation of enterprise data and analytics platforms in Kuala Lumpur. You will drive data integration, BI development, and cloud-based analytics, ensuring scalable, reliable solutions aligned with strategy and governance.

The role requires a hands-on leader with 7+ years in BI/data warehousing, strong SQL, and experience with Azure PaaS, ADF, Power BI, and SSAS.）

Qualifications

• Bachelor’s degree in Computer Science, Information Technology or related field.
• Minimum 7 years of experience in BI / data warehouse / analytics development.
• Experience across end-to-end BI or data warehouse lifecycle.
• Strong knowledge in data modelling and analytics solution implementation and delivery.

Responsibilities

• Delivering data warehouse, analytics, and business intelligence solutions across the full lifecycle.
• Supporting solution architecture and translating approved designs into implementable components.
• Designing and developing data pipelines using ADF and related tools.
• Building dashboards and reporting solutions using Power BI and related tools.
• Enhancing data models and system performance for scalable data solutions.
• Leading cross-functional teams and managing delivery timelines and risks.
• Ensuring coding standards, version control, and DevOps practices.
• Supporting testing activities (unit, SIT, UAT) and quality assurance.
• Providing technical guidance to the team.

Skills

Azure PaaS

Data modelling

ETL/ELT

Power BI

SQL

SSIS

SSAS

DevOps

Data governance

Education

Bachelor’s degree in Computer Science/Information Technology or related field

Tools

ADF (Azure Data Factory)

Microsoft Fabric

SQL Server

Job description

The purpose of this role is to support the delivery and implementation of enterprise data and analytics platforms for corporate strategy and mandate-driven initiatives.

The role focuses on enabling data integration, enterprise analytics and insight-driven dashboarding capabilities, ensuring solutions are reliable, scalable, and aligned with organisational and stakeholder requirements.

This position will support the evolution and optimisation of enterprise cloud-based analytics platforms ensuring performance, scalability, and alignment with business and organisational requirements

Job Description

The role is responsible for delivering and supporting enterprise data and analytics solutions. Key responsibilities include:

• Delivering data warehouse, analytics, and business intelligence solutions across the full lifecycle
• Supporting solution architecture and translating approved designs into implementable components
• Designing and developing data pipelines and integration workflows using Azure Data Factory (ADF) and related tools/solutions
• Building and maintaining data models, dashboards, and reporting solutions using Power BI, Microsoft Fabric, and related analytics tools/solutions
• Enhancing data models, system performance, and existing data structures to optimise efficiency, scalability, and reliability of data solutions
• Leading and guiding cross-functional team members, while managing delivery timelines, dependencies, and risks, and maintaining appropriate technical documentation to support delivery and ongoing operations
• Ensuring adherence to coding standards, version control, and DevOps practices
• Supporting testing activities (unit, SIT, UAT) and overall quality assurance
• Providing technical guidance and support to the team
• Executing solutions in alignment with defined architecture and standards

Education & Professional Experience

• Bachelor’s degree in Computer Science, Information Technology or related field
• Minimum 7 years of experience in BI / data warehouse / analytics development
• Experience across end-to-end BI or data warehouse lifecycle
• Strong knowledge in data modelling and analytics solution implementation and deliveryExperience in project delivery and leading cross-functional teams

Core (Must-Have)

• Strong foundation in Azure PaaS environment, including understanding of landing zone and cloud governance concepts
• Experience in data engineering (ETL/ELT, pipelines, integration) using ADF, SQL and related technologies
• Strong SQL skills, including stored procedures and optimisation
• Experience with SSIS and working in hybrid/cloud environments
• Experience in Power BI, DAX and related analytics tools/solutions
• Experience with SSAS (Tabular and Multidimensional models)

Added Advantage

• Experience with PowerShell for automation
• Exposure to C# or similar programming languages
• Knowledge in Data Science or Data Governance concepts

Summary

This role is suited for a hands-on Analytics Architect with strong implementation and delivery capabilities, who can lead technical delivery, coordinate teams effectively and support the organisation’s ongoing cloud and analytics platform optimisation and maturity.

This position is open to Malaysian citizens only.