Specialist, Commercial, North

JOB SUMMARY

The Specialist, Commercial reports to the Senior Director, Commercial and serves as a hands-on analytical partner to the regional commercial team. This role is suited for an individual contributor with senior analyst-level capabilities who can consolidate commercial data, support dashboard development, streamline daily data collection and consolidation workflows, improve recurring reporting routines, and translate data findings into clear observations and practical recommendations.

This role supports the Senior Director, Commercial and above-property commercial priorities across assigned hotels by helping to establish a reliable and structured approach to commercial performance reporting. Working under the guidance of the Senior Director, Commercial, the incumbent partners with regional, property, and Center of Excellence stakeholders to support approved commercial strategies, tools, standards, and programs. The incumbent is responsible for collecting, organizing, validating, and analyzing data from multiple sources, including hotel performance reports, revenue systems, sales production, channel contribution, business mix, forecasts, and market share indicators.

The ideal candidate has strong analytical discipline, good attention to detail, a basic understanding of commercial or revenue management principles, hands-on experience with Excel and Power BI or similar business intelligence tools, and strong learning agility and self-motivation. The candidate should be able to quickly learn new systems, tools, data sources, and business concepts, and use these capabilities to identify trends, highlight performance gaps, and prepare clear reporting outputs.

CANDIDATE PROFILE

Education and Experience

Required

Bachelor’s degree in Business Analytics, Revenue Management, Hospitality Management, Statistics, Economics, Information Systems, Computer Science, or a related discipline.

Minimum 2–3 years of relevant experience in commercial analytics, revenue management support, business intelligence, sales analytics, distribution analytics, hotel performance reporting, or related fields.

Basic understanding of hotel commercial performance metrics, including revenue, room nights, ADR, RevPAR, occupancy, market share, segmentation, channel mix, sales contribution, and forecasting indicators.

Hands-on experience using Power BI, Tableau, or similar BI tools to build or maintain dashboards, visualize performance trends, and support recurring reporting needs.

Strong Excel capability, with experience in data consolidation, pivot tables, lookup formulas, data checks, dashboard preparation, and structured reporting.

Fluent in oral and written Chinese; English reading and business communication skills are preferred.

Preferred

Experience helping to create reporting templates, dashboards, trackers, or semi-automated reporting workflows for business users.

Working knowledge of Power Query, basic SQL, data modeling concepts, or data warehouse logic is a plus.

Experience supporting commercial reviews, market reviews, hotel performance analysis, or business performance reporting.

Ability to interpret data, summarize key findings, and communicate business implications clearly.

Key Skills

Good commercial, revenue, and analytical mindset, with the ability to connect data findings to business questions.

Strong data consolidation, data validation, dashboard maintenance, and performance reporting capability.

Working proficiency in Power BI or equivalent BI platforms, with the ability to build or update user-friendly dashboards and recurring reports.

Ability to improve manual reporting steps, organize data collection, and support more efficient reporting routines.

Good analytical, organizational, communication, problem-solving, and follow-up skills, with strong attention to detail, learning agility, self-motivation, and the ability to work independently.

CORE WORK ACTIVITIES

Commercial Analytics, BI Reporting, and Decision Support

Supports the Senior Director, Commercial and regional commercial leadership in tracking commercial priorities, following up on assigned actions, and maintaining relevant analytical materials and performance trackers.

Collects, consolidates, and validates data from multiple commercial sources and transforms the inputs into structured reporting outputs for regional leadership and hotel teams.

Builds, updates, and maintains Power BI dashboards, trackers, and recurring reports that present commercial performance trends in a clear and user-friendly format.

Supports the improvement and partial automation of recurring data collection, dashboard refresh, and reporting processes to reduce manual effort and improve consistency and accuracy.

Analyzes performance trends, highlights commercial gaps and opportunities, and prepares practical observations and recommendations for review by the Senior Director, Commercial and relevant business stakeholders.

Supports commercial reviews, market reviews, hotel performance discussions, business planning, campaign tracking, and leadership reporting by preparing data summaries, charts, insights, and follow-up materials.

Coordinates with regional, property, and Center of Excellence stakeholders to clarify reporting requirements and support the rollout of approved commercial tools, standards, materials, and programs.

Identifies data gaps, reporting issues, follow-up needs, process inefficiencies, or potential risks and escalates them for review and guidance as needed.