Data Analytics & ETL Architecture Lead

PCCW; Hong Kong; On-site; HKD 600,000 - 900,000; Full time

Job summary

PCCW is seeking a skilled Data Pipelines and Analytics Engineer to join the Data Analytics Service Team in Hong Kong. The role focuses on liaison across stakeholders to troubleshoot BI and data warehouse issues and to improve ETL pipelines and architecture.

The ideal candidate will have strong analytical and communication skills, deep understanding of upstream/downstream system dependencies, and experience with Power BI, SSAS, and Oracle/SQL Server development.

Qualifications

• Bachelor's degree (or higher) in a related field.
• At least 5+ years IT experience with 2+ years in BI or data warehouse pipelines.
• 3+ years experience with Oracle or SQL Server SQL development.
• Proficiency in Power BI, SSAS, and data modelling principles.
• Strong English and Chinese (Mandarin/Cantonese) communication.

Responsibilities

• Translate data pipeline and analytics requirements into analytics model and data pipeline design.
• Collaborate with a range of stakeholders including architecture team, developers, data consumers, and business users.
• Develop use cases and align stakeholder expectations to resolve client queries.
• Model and design ETL pipeline data structures with integrity checks.
• Document technical specifications for functional and non-functional requirements.
• Design scalable data models to support growth of a large-scale data platform.
• Analyze new data sources and evaluate data quality impacts.
• Bridge the gap between business requirements and ETL logic, troubleshoot discrepancies.

Skills

Data quality metrics

Data modelling

Data warehouse architecture

Oracle PL/SQL

SQL DDL/DML

Hadoop

Python

Java Spring Boot

Docker

Power BI

SSAS

Snowflake design

Star Schema

JSON API data service

Power Query M

SSAS multi-dimensional

Power BI deployment

English and Chinese (Mandarin/Cantonse

Problem solving

Multitasking

Education

Bachelor's degree (or higher) in related field

Tools

Oracle

SQL Server

Power BI

SSAS

DAX

Job description

PCCW is seeking a skilled Data Pipelines and Analytics Engineer to join the Data Analytics Service Team in Hong Kong. The role focuses on liaison across stakeholders to troubleshoot BI and data warehouse issues and to improve ETL pipelines and architecture.

The ideal candidate will have strong analytical and communication skills, deep understanding of upstream/downstream system dependencies, and experience with Power BI, SSAS, and Oracle/SQL Server development.