Data Analytics Manager

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

Seeking a skilled and detail-oriented Data pipelines and Analytics Engineer to join Data Analytics Service Team. His or her role is mainly to liaise with different parties to support troubleshooting and problem solving of all Business Intelligence/Data warehouse related issues and improvement area of ETL pipelines and data warehouse architecture. The ideal candidate will possess strong analytical skills, excellent communication abilities, and a deep understanding of dependencies and relationship of all upstream and downstream systems related to data warehouse.

Job Duties

• Translate Data Pipeline and Analytics requirements into analytics model and data pipeline design, guide and direct the design by working closely with a range of stakeholders including the rest of the architecture team, external developers, data consumers, data providers, and internal/external business users.
• Contribute to use case development, e.g. workshop to gather and validate business requirements. Align expectation from different stakeholders to streamline, expedite and solve any complains and queries from clients. Experience of Project Management and Business Transformation in Financial and Insurance Industries is an advantage.
• Model and design the ETL pipeline data structure, storage, integration, integrity check and reconciliation. Standardize all exception control and ensure good traceability during trouble shooting.
• Document and write technical specifications for the function and non-functional requirements of the solution.
• Design data model/platform allowing managed growth of the data model to minimize risk and cost of change for a large-scale data platform.
• Analyze new data sources with structured Data Quality Evaluation approach and work with stakeholders to understand the impact of integrating new data into existing pipelines and models.
• Bridge the gap between business requirements and ETL logic by troubleshooting data discrepancies and implementing scalable solutions.

Education / Qualification

• Bachelor's degree (or higher) in project management, business management, mathematics, statistics, computer science, engineering, or related field.

Skills / Knowledge

• Strong technical understanding of data quality metrics, data modelling, design and architecture principles and techniques across master data, transaction data and data warehouse.
• Experience with Stored Procedure (e.g. Oracle PL/SQL) and SQL DDL/DML.
• Hadoop, Python, Java Spring boot, docker or OCP skill is advantage.
• Experience in Power BI tool with usage of data objects, report objects, and service objects in different scenarios
• Experience in Star Scheme and Snowflake design and dimensional modelling
• Knowledge with Power BI and/or SSAS Row level security
• Experience to use JSON API data service for rendering Power BI report
• Knowledge with Power Query M script is an advantage
• Strong Power BI skill with SSAS multi-dimensional model as data source
• Migration of Power BI data model to SSAS data model best practice.
• SSAS model change version control and deployment across different testing environment and production.
• Performance monitoring and management of Power BI servers and SSAS servers.
• Proficient in both spoken and written English and Chinese (Mandarin/Cantonese).
• Proactive with good problem solving and multitasking skills

Working Experience

• At least 5+ year IT experiences with 2-year in data migration, business intelligence and/or data warehouse pipelines projects.
• At least 3-year experience with Oracle or SQL Server SQL development.