Revenue Analyst

Revenue Analyst – Five-Star Hotel

Main Responsibilities:

• Analyze daily occupancy, ADR (Average Daily Rate), RevPAR, room revenue, and pickup.

• Monitor hotel bookings, cancellations, no-shows, and booking pace.

• Prepare daily, weekly, and monthly revenue and forecasting reports.

• Assist the Revenue Manager in developing pricing and inventory strategies.

• Analyze historical and current data to forecast future demand and occupancy.

• Monitor competitors’ room rates, promotions, packages, and market positioning.

• Recommend appropriate room rates based on demand, seasonality, events, and market conditions.

• Manage and analyze room inventory across different room types and rate categories.

• Identify opportunities to increase revenue through upselling, packages, promotions, and restrictions.

• Monitor OTA performance, including channels such as Booking.com and Expedia, as well as direct bookings.

• Evaluate the performance of different market segments, such as corporate, leisure, group, wholesale, and government.

• Support decisions regarding minimum length of stay (MLOS), closed-to-arrival (CTA), and other revenue controls.

• Work closely with Sales, Reservations, Front Office, Finance, and Marketing teams.

• Prepare presentations and reports for management meetings.

• Maintain accurate data in the hotel’s PMS, RMS, CRS, and reporting systems.

Education

• Bachelor’s degree or diploma in Hotel Management, Hospitality, Finance, Business Administration, Economics, or a related field.

• A qualification in Revenue Management or Hospitality Analytics is an advantage.

Experience

• Typically 1–3 years of experience in hotel revenue management, reservations, finance, or hotel operations.

• Experience in a 4- or 5-star hotel is preferred.

• Fresh graduates may be considered for junior/entry-level Revenue Analyst positions if they have strong analytical and Excel skills.

Technical Skills

• Strong Microsoft Excel skills, including:

• Pivot Tables

• XLOOKUP/VLOOKUP

• SUMIFS/COUNTIFS

• Charts and dashboards

• Basic data analysis

• Knowledge of hotel PMS, RMS, CRS, and channel-management systems.

• Familiarity with Opera PMS, IDeaS, Duetto, or similar systems is an advantage.

• Understanding of STR reports and competitive-set analysis.

Revenue Management Knowledge

• Understanding of Occupancy, ADR, RevPAR, TRevPAR, and GOPPAR.

• Knowledge of forecasting and demand analysis.

• Understanding of room pricing and inventory management.

• Knowledge of market segmentation and booking channels.

• Ability to analyze pickup, booking pace, cancellations, and no-shows.

• Understanding of OTA and direct-booking performance.

Personal Skills

• Strong analytical and numerical ability.

• Excellent attention to detail.

• Good problem-solving skills.

• Commercial and business mindset.

• Strong communication skills.

• Ability to work with multiple departments.

• Ability to meet tight deadlines and handle pressure.