Senior Data & Analytics Engineer (Azure Cloud Transition)

Randstad Malaysia; Kuala Lumpur; On-site; MYR 180,000 - 280,000; Full time

Job summary

Randstad Malaysia is seeking a Lead Data & Analytics Engineer to drive our full cloud transformation as we migrate to Azure and manage hybrid infrastructure. You will modernize data pipelines with Azure Data Factory and Microsoft Fabric, optimize Azure SQL Managed Instances, and translate legacy SSIS/SSAS to cloud solutions.

Strong Agile/SDLC governance will guide design, documentation, and sign-off processes.

Qualifications

• 5+ years in Data Engineering/BI or Cloud Architecture.
• Hands-on Azure Data Factory, Fabric, and Azure SQL.
• Experience with SSIS/SSAS in cloud migrations.
• Strong Power BI, DAX, and semantic modeling skills.
• Proficient in Agile/Scrum and SDLC governance.

Responsibilities

• Lead cloud migration and data engineering to support Azure transition by September.
• Develop and optimize pipelines and database schemas across Azure platforms.
• Maintain legacy SSIS/SSAS during transition on cloud VMs.
• Build scalable semantic models and Power BI reports for stakeholders.

Skills

Azure Data Factory

Microsoft Fabric

Azure SQL Managed Instance

SSIS

SSAS

Power BI

DAX

Agile/SDLC

End-to-end cloud migrations

Excel VBA

Education

Associate Degree/Diploma

Tools

Azure Data Factory

Microsoft Fabric

Azure SQL Managed Instance

SSIS

SSAS

Power BI

Job description

Department: Digital & Technology

Positions Available: 2 (Contract - Renewable)

About the Role

We are seeking an experienced Lead Data & Analytics Engineer to drive our full cloud transformation. Our organization is transitioning to a cloud environment on Azure, and we need a hands‑on technical lead to execute this migration while managing hybrid infrastructure and delivering end‑to‑end analytics.

In this role, you will modernize data pipelines using Azure Data Factory and Microsoft Fabric, optimize Azure SQL Managed Instances, and maintain legacy on‑premise solutions (SSIS, SSAS) migrated to cloud VMs. Beyond engineering, you will build robust semantic models in Power BI to deliver business‑ready insights following strict Agile and SDLC governance.

Key Responsibilities

• Cloud Migration & Data Engineering: Build, orchestrate, and optimize production ETL/ELT pipelines using Azure Data Factory and Microsoft Fabric to support our complete cloud migration by September.

• Database & Infrastructure Management: Develop and maintain schemas, performance, and procedures across Azure SQL Managed Instances.

• Legacy System Support: Maintain and support existing SSIS integration packages and SSAS tabular/multidimensional models hosted on Azure VMs during the transition.

• Analytics & Semantic Modeling: Build scalable, high‑performance semantic models, DAX measures, and reports in Power BI for cross‑functional stakeholders.

• SDLC & Delivery Management: Adhere to structured Agile/Scrum methodologies, producing thorough technical documentation, tracking pipeline deployment, and securing formal business sign‑offs.

• Process Automation: Develop targeted Excel VBA/macro automation tools to streamline manual assessment workflows for internal resolution specialists.

Technical Requirements

• 7+ years of progressive experience in Data Engineering, Business Intelligence, or Cloud Architecture.

• Deep hands‑on experience with Microsoft Azure, specifically Azure Data Factory (ADF), Microsoft Fabric, and Azure SQL Managed Instance.

• Proven track record working with legacy Microsoft SQL Server stacks, including SSIS and SSAS (tabular/multidimensional models).

• Advanced Power BI expertise, including enterprise semantic layer design, DAX, and report optimization.

• Proven ability to operate within an Agile/SDLC environment, including writing technical design docs, standard operating procedures, and managing deployment sign‑offs.

• Strong experience in end‑to‑end cloud migrations and infrastructure transition projects.

Desirable / Advantageous Skills

• Advanced Excel & VBA: Strong capability in writing complex VBA scripts and macros to automate operational assessment spreadsheets for resolution specialists.

Candidate Profile

• Full‑Stack Analytics: Able to build the pipeline, model the data layer, and deliver the final Power BI dashboard independently.

• Process‑Driven: Committed to code quality, documentation, testing, and formal sign‑off processes.

experience

5 years

skills

Azure Data Factory and Microsoft Fabric

qualifications

no additional qualifications required

education

Associate Degree/Diploma