Data Engineer / Senior Data Engineer (MS SQL - SSAS Focus)

PCCW Services Limited (Hong Kong, Hong Kong) Follow 18 hours ago

Full-time ETL Pipelines Exceptions Analytics Business Transformation Rendering

Seeking a skilled and detail-oriented Data Pipelines and Analytics Engineer to join the Data Warehouse Team. The role is mainly to liaise with different parties to support troubleshooting and problem solving of all Business Intelligence/Data warehouse related issues and improvement areas of ETL pipelines and data warehouse architecture.

Job Duties

Translate Data Pipeline and Analytics requirements into analytics model and data pipeline design, guiding and directing the design by working closely with a range of stakeholders including the architecture team, external developers, data consumers, data providers, and internal/external business users.
Contribute to use case development, e.g., workshops to gather and validate business requirements, align expectations from different stakeholders to streamline, expedite, and solve complaints and queries from clients. Project Management and Business Transformation experience 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 functional and non‑functional requirements of the solution.
Design data model/platform that allows managed growth of the data model to minimize risk and cost of change for a large‑scale data platform.
Analyze new data sources with a 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.

Qualifications

Bachelor's degree (or higher) in project management, business management, mathematics, statistics, computer science, engineering, or related field.
At least 5+ years IT experience with 2+ years in data migration, business intelligence and/or data warehouse pipeline projects, and at least 3 years experience with SQL Server SQL development.
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 procedures and SQL DDL/DML.
Hadoop, Python, Java Spring Boot, Docker or OCP skills is an advantage.
Experience in Power BI tool usage of data objects, report objects, and service objects in different scenarios.
Experience in Star Schema and Snowflake design and dimensional modelling.
Knowledge of Power BI and/or SSAS Row‑level security.
Experience using JSON API data service for rendering Power BI reports.
Knowledge of Power Query M script is an advantage.
Strong Power BI skill with SSAS multi‑dimensional model as data source.
Experience migrating Power BI data models to SSAS data models and best practices.
SSAS model change version control and deployment across different testing environments 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.