Senior Data Analytics Engineer
PCCW
full-time
Posted on:
Location Type: Office
Location: Hong Kong • Hong Kong
Visit company websiteExplore more
Job Level
About the role
- Seek a skilled and detail-oriented Data pipelines and Analytics Engineer to join Data Warehouse Team.
- 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.
- 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 expectations from different stakeholders to streamline, expedite and solve any complaints 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.
Requirements
- Bachelor's degree (or higher) in project management, business management, mathematics, statistics, computer science, engineering, or related field.
- 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.
- 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
- 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.
- At least 5+ years of IT experience with 2-years in data migration, business intelligence and/or data warehouse pipelines projects.
- At least 3-year experience with Oracle or SQL Server SQL development.
Benefits
- Professional development opportunities
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data pipelinesETLdata modelingdata architectureSQLOracle PL/SQLPower BIStar SchemaSnowflake designJSON API
Soft Skills
problem solvingmultitaskingcommunicationstakeholder managementproject management
Certifications
Bachelor's degree