Data Analytics Manager

Dorsett Hospitality International Services Limited; Hong Kong; Vor Ort; HKD 900.000 - 1.500.000; Vollzeit

Zusammenfassung

Dorsett Hospitality International is seeking an Data Analytics Manager to turn hotel and market data into reliable dashboards and automated reports. You will lead Power BI development, SQL data preparation and modelling, and provide actionable insights for Revenue Management, E-Commerce, Sales and Finance across properties.

This hands-on BI role requires strong communication with senior stakeholders, data-quality governance, and cross-functional collaboration across regional teams.

Qualifikationen

• Field of Study: Data Analytics, Information Systems, Computer Science or related quantitative discipline.
• Minimum four years of BI, data analytics or management reporting experience.

Aufgaben

• Data Integration and Quality: consolidate data from multiple sources and validate accuracy.
• BI Dashboard Development: design and maintain dashboards and KPI reports for stakeholders.
• SQL and Data Modelling: write SQL, build data models and calculations.
• Reporting Automation: automate data refresh and report distribution processes.
• Commercial Performance Analysis: analyze revenue, occupancy, market share and related metrics.
• Executive and Business Insights: present insights to senior management with clear narrative.
• Ad-Hoc Business Cases: support market assessments and commercial evaluations.
• Stakeholder Requirements and Adoption: gather requirements and promote adoption of standard reports.
• Documentation and Governance: maintain data dictionaries and change logs.
• Continuous Improvement: monitor usage and improve reporting processes.

Kenntnisse

Power BI

SQL

Data modelling

Data quality

Excel

DAX

Ausbildung

Bachelor's degree in a related field

Tools

Azure data services

Power Automate

Python

R

Jobbeschreibung

The Data Analytics Manager supports commercial decision-making by transforming hotels, distribution and market data into reliable dashboards, automated reporting and actionable business insights.

The role is a hands-on business-intelligence position responsible for Power BI development, SQL-based data preparation and modelling, data-quality controls, commercial analysis and clear communication of performance drivers, risks and opportunities. The position works closely with Revenue Management, E-Commerce, Sales, Marketing, Finance, IT, regional teams and hotels.

Principal Accountabilities

Data Integration and Quality
Consolidate data from PMS, RMS, CRS, distribution, market-intelligence, finance and other agreed sources. Perform validation, reconciliation and exception checks to improve the accuracy, consistency and usability of commercial reporting.

BI Dashboard Development
Design, develop, maintain and enhance commercial dashboards, KPI scorecards and management reports for corporate, regional and hotel users. Apply appropriate data visualization, drill-downs, filters and exception reporting to support timely decisions.

SQL and Data Modelling
Use SQL to extract, join, transform and validate data. Develop and maintain practical data models, calculations and metric definitions that support scalable reporting and consistent interpretation across properties.

Reporting Automation
Reduce manual reporting through repeatable data-refresh, validation and report-distribution processes. Work with IT, vendors and business users on source connectivity and access requirements; the role is not expected to own enterprise infrastructure or full-scale data engineering.

Commercial Performance Analysis
Analyze revenue, RevPAR, ADR, occupancy, market share, forecast and budget performance, booking pace, channel and segment mix, customer-acquisition cost, length of stay and other agreed commercial measures. Identify material trends, performance gaps, risks and opportunities.

Executive and Business Insights
Translate complex data into concise commentary, presentations and recommendations for senior management, regional leaders and hotel teams. Clearly distinguish factual findings, business implications and recommended follow-up actions.

Ad-Hoc Business Cases
Support scenario analysis, feasibility reviews, market assessments and commercial evaluations for hotel openings, repositioning, renovation, distribution initiatives and other approved projects.

Stakeholder Requirements and Adoption
Gather and prioritize reporting requirements, convert business questions into analytical outputs and support users in interpreting dashboards. Provide practical user guidance and encourage adoption of standard reports.

Documentation and Governance
Maintain dashboard specifications, source mappings, KPI definitions, data dictionaries, refresh procedures, access records and change logs. Apply appropriate confidentiality, access-control and data-handling requirements in coordination with IT.

Continuous Improvement
Monitor dashboard usage and reporting effectiveness, resolve recurring data issues and recommend improvements to reporting processes, visualization standards and analytical methods.

PERSON REQUIREMENT:

Field of Study

Data Analytics, Business Analytics, Information Systems, Computer Science, Statistics, Mathematics, Economics, Finance, Business Administration or related quantitative discipline.

Years of Experience:

Minimum four years of relevant experience in business intelligence, data analytics, commercial analytics or management reporting.

The position may suit either an experienced Analytics Manager or a strong Senior BI/Data Analyst ready to take broader ownership.

Area of Experience:

Hands-on development of Power BI dashboards and management reports.

Practical SQL experience for data extraction, transformation, validation and analysis.

Experience working with multiple data sources and translating business requirements into analytical outputs.

Experience presenting insights to non-technical stakeholders.

Hospitality experience is preferred.

Knowledge of hotel metrics, systems and data such as PMS, RMS, CRS, RevPAR, ADR, occupancy, market share and channel mix is preferred.

Experience in reporting automation, KPI standardization, data-quality controls and executive reporting.

Experience engaging in senior stakeholders or supporting commercial business cases is preferred.

Other Professional Qualifications / Technical Skills / Knowledge Required:

Strong Power BI capability, including data modelling, DAX, Power Query and effective dashboard design.

Strong SQL skills, including extracting, joining, transforming and validating structured data.

Advanced Excel skills.

Sound understanding of data quality, relational data, KPI definitions and reporting controls.

Strong analytical thinking, attention to detail, business communication and data-storytelling skills.

Able to work independently and manage multiple stakeholder requests.

Familiarity with Power Automate, Microsoft Fabric, Azure data services, APIs, ETL/ELT concepts or comparable cloud/data tools are preferred.

Python, R or other analytical programming exposure is preferred.

Microsoft Power BI Data Analyst or related certification is preferred.

Essential: Strong written and spoken English, including the ability to prepare clear management commentary and presentations.

Preferred: Cantonese and/or Mandarin for collaboration with Hong Kong and Greater China stakeholders

Dorsett Hospitality International is one of the fastest-growing hotel groups in Asia. With 54 properties in 21 major cities across Mainland China, Hong Kong, Australia, the United Kingdom, Malaysia, Singapore, Japan and Continental Europe, we offer a diverse international footprint alongside our strategic partners Palasino Group and AGORA Hospitality Group. Our four core brands – Dorsett Hotels, Dao by Dorsett, d.Collection and Silka Hotels – aim to provide exceptional guest experiences while making positive impacts in our local communities.

Dorsett Hospitality International is one of the fastest-growing hotel groups in Asia. With 54 properties in 21 major cities across Mainland China, Hong Kong, Australia, the United Kingdom, Malaysia, Singapore, Japan and Continental Europe, we offer a diverse international footprint alongside our strategic partners Palasino Group and AGORA Hospitality Group. Our four core brands – Dorsett Hotels, Dao by Dorsett, d.Collection and Silka Hotels – aim to provide exceptional guest experiences while making positive impacts in our local communities.