Database analyst serp_jobs.h1.location_city

Job Description

Job Description

Summary :

Results-driven and analytical Hotel Revenue Analyst with a strong background in pricing strategy, demand forecasting, and revenue optimization. Adept at supporting the Director of Revenue Management in developing and executing strategic plans to maximize room revenue and profitability. Skilled in analyzing market trends, competitive data, and historical performance to generate actionable insights. Proficient in revenue management systems (RMS), Excel, and data visualization tools. Collaborates effectively with sales, marketing, and operations teams to align revenue goals and drive overall hotel performance.

Essential Job Functions : Include the Following. Other job duties may be assigned.

• Build and manage special rate plans according to established revenue management guidelines for group bookings upon receipt of recaps from Sales Managers.
• Update, process, generate and distribute daily, weekly and monthly revenue management reports and enter data into various systems, including Excel.
• Develop new reports, as needed, to assist in preparation for the revenue management meetings or data analysis.
• Maintain historical statistical data from all distribution channels.
• Analyze and present accurate picture of trends, demand and market conditions.
• Accurately prepare and distribute daily and weekly occupancy forecasts.
• Maintain and enter accurate rate and demand information in various systems.
• Create and manage group masters for newly created Rate codes, Rate plans, SRPs in Revenue Management System, set up billing methods & charge routing controls, & pre-authorize credit card guarantee prior to group arrivals.
• Monitor group cut-off dates. As cut-off dates approach, alert DORM & sales managers if group reservations are missing.
• Perform 14-day window audit of blocked inventory in systems ensuring all unused blocked inventory has been released.
• Assist DOS & DORM to catch & resolve group forecast discrepancies by balancing PMS and the sales system weekly. Alert DRM & sales managers if any recaps are missing for definite groups in Delphi.
• Support DORM in managing the rolling 52-week inventory.
• Monitor and analyze the competition daily and weekly to identify selling strategies and market trends. Alert DRM to emerging trends.
• Assist DORM in optimizing the hotel revenue stream and generating positive index against competing hotels in the marketplace.
• Understand the competition and make recommendations to help the hotel management team respond accordingly.
• Process on-property transient reservation for VIP guests, preferred account clients, etc., as directed by the GM / AGM, DOS & DRM.
• Support Reservations Agent in making reservations for contract-based business (ie : crew, wholesale, FIT).
• Fully understand hotel product and operations processes.
• Interact effectively with colleagues and hotel guests.
• Provide administrative support for the Revenue & Reservations Department.

Required Skills and Abilities :

Language Skills : Excellent verbal communication skills. Service skills including etiquette and ability to work with the public. Knowledge of communications skills, organization skills, ability to deal with diverse clientele, good penmanship.

Reasoning Ability : Ability to apply commonsense understanding to carry out detailed written or oral instructions. Ability to deal with problems involving a few concrete variables in standardized situations.

Other Skills and Abilities : Ability to communicate and work well with fellow employees and other departments. Maintain a presentable appearance, behavior and manner at all times. Ability to process administrative work. Ability to manage multiple tasks effectively.

Physical Demands : While performing the duties of this job, the employee will be sitting for extended periods of time answering and sending emails. Might regularly stand, walk, and talk. The employee frequently is required to use hands to grab, move, lift, or feel objects, and use telephone and copier machine