Position Summary

It is the primary responsibility of the Rooms Revenue Analyst to develop, analyze, prepare and communicate various reports for management review on all aspects of room occupancy, room rates, revenue generation and cost control. All duties are to be performed in accordance with departmental, Galaxy Macau policies, practices and procedures.

Primary Responsibility

•    Working with multiple hotel brands to set and yield all hotel rates, packages and pricing promotions for all distribution channels using data modeling and forecasting tools based on historical, competitive influences and price/demand sensitivity.
•    Performing quantitative analysis & methodologies (including forecasting, statistics, econometric modeling, linear programming and other optimization algorithms) for yield optimization; reporting and modeling to support ongoing improvements in revenue decision making and maximizing of hotel revenue. 
•    Performs total customer enterprise value for the purposes of making revenue optimization decisions 
•    Consults regularly with internal departments to understand business needs, changing strategies and developments to improve effectiveness, validate and measure results and improve overall revenue optimization
•    Provides input and executes the strategic plan for the revenue department consistent with the strategic vision of the hotels division within Galaxy Macau. 
•    Formulates, prepares and communicates reports for senior management on a daily, weekly and monthly basis, offering recommendations for revenue maximization. 
•    Ensures timely preparation of various weekly, monthly, quarterly and annual reports in accordance with established practices and procedures, distributing reports to management as appropriate.
•    Continuously investigates new revenue and profit opportunities for all hotel assets.
•    Consolidates, simplifies and creates new and existing reports for data analyzing.
•    Participates in the development of Galaxy Macau’s marketing strategies to increase volume, market share, and hotel revenue, monitoring current booking trends. 
•    Assists in preparation of special information/statistical projects and statistical/analytical data in a timely and efficient manner, and as requested by management. 
•    Manages and recommends hotel room rate changes. 
•    Work within both the rate loading and distribution systems such as Opera, Siteminder.
•    Monitors Galaxy Macau’s advertising, promotions, and develops reports on the effectiveness of various marketing tools.

Requirements Have exceptional intellectual, professional, and interpersonal agility with strong analytical and problem solving skills. Strong oral and written presentation skills Work collaboratively and communicate effectively with senior management team. Have strong financial acumen and bottom-line orientation. Work in a fast-paced, busy, and somewhat stressful environment. Must have excellent working knowledge of Microsoft Excel and all Microsoft products. Must have the ability to translate information into readable and logical report structure. Must have the ability to perform a multiple task with attention to detail. Must possess preternatural attention to detail and be highly accurate with his work. Must be able to communicate effectively in English, in both written and oral forms. Must have interpersonal skills to deal effectively with all business contact Should be familiar with gaming knowledge Programming skills in Python, SQL, PowerBi and SAS or other programming languages is preferred Strong project management skills.