Hotel Revenue Analyst

JOB SUMMARY:  Supports the maximization of total hotel profit (gaming and cash) by Analyzing and interpreting historical and forecasted hotel data to result in maximum hotel yield.

·           Maintains room rates and rate structures in the Hotel Management System under the guidance of Hotel management and the Planning & Analysis Manager

·           Coordinate with all areas of marketing and group sales to effectively deliver group, event, and direct mail programs that do not displace revenue from the hotel and deliver high occupancy rates.

·           Review, act and report on any current RM irregularities within LMS and RMS that may result in increased optimal revenue capture.

·           Maintains and reports on weekend displacement analysis to capture future expected demand more efficiently.

·           Responsible for determining historical demand and demand weight for events and promotions.

·           Maintains event and promotions historical demand and Revenue DB

·           Monitors Sales groups and updates rates.

·           Review group blocks and ensure proper criteria is placed within each group master account, including but not limited to billing, inventory against contract.

·           Creates reports analysis based on RM data

·           Provides RMS systems and analysis expertise to help internal customers including but not limited to hotel, marketing, and sales.

·           Creates and maintains all future and existing RM related excel files and models on a routine basis and maintains them as read only for other departments utilization.

·           Creates and analysis ad-hoc reports for property based on RM data.

·           Monitors Direct Mail offers and performs cross-reference against settings within LMS and makes recommendations to maximize profits.

·           Assists in monitoring Marketing calendar for changes and ensuring RM goals are maintained and optimized through efficient utilization of DM campaigns and Events

·           Supports generation of departmental analytical information, presentations, and updates.

·           Creates accurate and timely reports from various systems.

·           Monitors Synxis reports and supports GDS system and extranet exposure.

·           Provides detailed analysis of DM offers, retail, Internet booked, and advertised redemption rates.

·           Maintains and updates daily room and revenue reports

·           Maintains Marketing Databases including but not limited to; Direct Mail, Business Source, Cash Revenue, Theo/Win, Discounts and Promotions, Third Party.

·           Manages Packaging and Promotional Bookings Pace and Revenue. Makes recommendations to maximize profits.

·           Provides other administrative support as needed.

·        Experience with Hyperion Essbase and Microsoft Access preferred.

The requirements listed are representative of the knowledge, skill and/or ability required to fulfill the obligations of this position.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Preference is given to Ak-Chin community members and members of other recognized Arizona tribes.

This is not necessarily an exhaustive list of all responsibilities, skills, duties, requirements, efforts or working conditions associated with the job. While this is intended to be an accurate reflection of the current job, management reserves the right to revise the current job or to require that other or different tasks be performed when circumstances change, (e.g. emergencies, changes in personnel, workload, rush jobs or technical developments).