Data Analytics Engineer 35-45K

Michael Page International (Hong Kong) Limited; Hong Kong; On-site; HKD 600,000 - 980,000; Full time

Benefits offered by this job

Competitive monthly salary

All-inclusive benefits package

Temporary role in Kowloon

Job summary

Michael Page International (Hong Kong) Limited is seeking a seasoned Data Analytics Engineer to strengthen the Data Warehouse team and lead enterprise-scale analytics initiatives in Hong Kong. You will partner with business users, architects, and developers to deliver scalable analytics solutions and robust data pipelines.

The role requires 5+ years IT experience in data warehouse/BI projects, strong SQL and ETL skills, and fluency in English and Chinese (Cantonese/Mandarin).

Qualifications

• 5+ years IT experience in data warehouse/BI or data migration.
• 3+ years hands-on Oracle or SQL Server development.
• Strong SQL, Stored Procedures, DDL and DML skills.
• Experience with Power BI, SSAS and dimensional modelling.
• Fluent in English and Chinese (Cantonese and Mandarin).

Responsibilities

• Translate requirements into scalable analytics solutions with business users and stakeholders.
• Design, develop and optimise ETL data pipelines, data models and integration frameworks.
• Support data warehouse architecture improvements and governance.
• Conduct data quality assessments and reconciliation controls.
• Troubleshoot data discrepancies across upstream and downstream systems.
• Gather, analyse and validate business requirements through workshops.
• Prepare technical documentation for functional and non-functional requirements.
• Evaluate new data sources and assess integration impact.
• Develop dimensional models using Star Schema and Snowflake Schema designs.
• Ensure scalability, maintainability and security of enterprise data platforms.
• Support Power BI and SSAS environments including deployment and performance tuning.

Skills

SQL

Stored Procedures

DDL/DML

Data Modelling

Data Architecture

ETL

Power BI

SSAS

Star Schema

Snowflake Schema

Stakeholder Mgmt

Analytics

Hadoop

Python

Java Spring Boot

Docker

OpenShift

English

Cantonese

Mandarin

Education

Degree in CS/Engineering/Statistics/Math

Related disciplines

Tools

Power BI

SSAS

Oracle

SQL Server

JSON APIs

Power Query M

Hadoop

Python

Java Spring Boot

Docker

OpenShift

Job description

Overview

• Drive enterprise-scale data warehouse and BI initiatives
• Exposure to modern analytics and ETL technologies

About Our Client

Our client is a leading telecommunications organisation in Hong Kong, supporting large-scale data warehouse and business intelligence platforms. They are seeking an experienced Data Analytics Engineer to strengthen their Data Warehouse team and drive data pipeline enhancement, analytics solutions, and enterprise data architecture initiatives.

Job Description

• Partner with business users, architects, developers and data stakeholders to translate requirements into scalable analytics solutions.
• Design, develop and optimise ETL data pipelines, data models, and integration frameworks.
• Support data warehouse architecture improvements and drive best practices for data management.
• Conduct data quality assessments, reconciliation processes and exception handling controls.
• Troubleshoot and resolve data discrepancies across upstream and downstream systems.
• Gather, analyse and validate business requirements through workshops and stakeholder engagement.
• Prepare technical documentation covering functional and non-functional requirements.
• Evaluate new data sources and assess integration impacts on existing platforms.
• Develop dimensional data models including Star Schema and Snowflake Schema designs.
• Ensure solution scalability, maintainability, governance and traceability for enterprise data platforms.
• Support Power BI and SSAS environments, including deployment, performance tuning and security configuration.

The Successful Applicant

• Degree holder in Computer Science, Engineering, Statistics, Mathematics, Business Management, Project Management or related disciplines.
• Minimum 5 years of IT experience with exposure to data warehouse, business intelligence or data migration projects.
• At least 3 years of hands‑on experience with Oracle or SQL Server development.
• Strong knowledge of SQL, Stored Procedures, DDL and DML programming.
• Solid understanding of data modelling, data architecture and data quality management principles.
• Experience designing ETL processes and enterprise data warehouse solutions.
• Hands‑on experience with Power BI, SSAS and dimensional modelling techniques.
• Familiarity with Star Schema, Snowflake Schema and data warehouse best practices.
• Knowledge of Power BI security models, including Row‑Level Security.
• Experience working with JSON APIs and Power Query M scripts is advantageous.
• Exposure to Hadoop, Python, Java Spring Boot, Docker or OpenShift is a plus.
• Strong analytical thinking, problem‑solving and stakeholder management skills.
• Fluent in written and spoken English and Chinese (Cantonese and Mandarin).

What's on Offer

• Competitive monthly salary and benefits package.
• All-inclusive benefits package.
• Temporary role in a prominent technology setting in Kowloon.