Revenue Executive

**Revenue Executive**

We are looking to recruit a Yield and Controls Assistant to join the Celtic Manor Resort.

In this role you will be responsible for updating the rates and availability on travel websites along with creating reports in excel to show past and future revenue statistics.

You will also use report writing tools to find information from our in house booking systems, analyse data and trends and monitor market competition.

You will have excellent levels of numeracy and analytical skills, good attention to detail and enjoy working under pressure to meet deadlines.

You will also be a good team player with excellent interpersonal skills, good time management and be self motivated and adaptable.

The successful applicant will possess experience in accounts or figure work and investigative skills as well as a sound knowledge of Excel spreadsheets.

**Working Hours**:37.5 hours per week working 5 days out of 7

**Rate of pay**: £

**Key Duties**
- To be proficient in using automated reservation systems Delphi, Opera, Concept, Guest Connections and any other systems within Client Services and to be responsible for maximising revenue opportunities within them.
- To assist in producing accurate monthly forecast reports for the Resort.
- To assist in producing a weekly forecast and other revenue reports for the Resort.
- To monitor and change all rates effectively on 3rd party websites, Channel management systems, GDS and through direct sale in Opera in line with yield management decisions. Ensure third party websites are kept up to date with current information in line with the Resort current offerings, including imagery and product information.
- To have daily contact with the IDeaS Revenue Management system, monitoring it’s decisions and making the relevant actions.
- To be aware of all budget and forecast figures and individual targets and work towards achieving these. To be able to identify and explain reasons for variances.
- To monitor bookings made and lost for the previous day and to identify the peaks and troughs this causes.
- To be proficient in and actively working on setting up rate codes in Opera and ensure they are open and closed according to the yield decisions made and strategies adopted.
- To use the Report Writing tools within our various systems for forecasting, reviewing performance and history and highlighting errors within systems.
- To prepare the reports for the weekly executive yield meeting by the set deadline. To analyse these reports and highlight key information at the time of production. To investigate any anomalies presented by these reports and give reasons for the anomalies.
- Action points from the yield meetings accordingly within the set deadlines.
- To update the monthly rooms market segments report and identify reasons for shortfalls.
- To keep the team updated with rooms sold and revenue at regular intervals following promotional eblasts.
- Update tour operators and LCR monthly statistics reports. Analyse them and identify reasons for shortfalls.
- Work with 3rd parties and booking engine contacts to increase our sales with them on a regular basis.
- Update the Yield decisions calendar with all decisions and changes to rates and strategies for all areas of the business.
- Keep the Yield journal up to date with any key yield decisions and marketing activity.
- Update campaign schedules with final statistics and key decisions made during the promotion within 1 week of promotion finishing.
- To monitor group golf bookings created and lost the previous day, to identify and highlight opportunities and troughs in the golf market of the business.
- To bring forward ideas to the yield team to increase average rate or revenue increasing opportunities.
- To ensure that all competitor information is gathered as required and information produced in an easy read format.
- To ensure trough periods are highlighted during the year and yielding put in place for these periods.
- To review bookings entered daily within our booking systems to identify any input errors which would result in incorrect forecasting. Pass details of errors to the Line Manager to rectify in system and with individual.
- Monitors competitors’ rates and offers in all our markets on a monthly basis
- To attend relevant meetings and training as required.
- To actively participate in client hospitality events.
- To positively approach sales opportunities in order to maximise sales revenue.
- To assist in auditing at the Resort’s Special Events
- Assist in daily billing and checking revenue closures and postings made by other departments are done correctly and in a timely fashion.
- To positively approach sales opportunities in order to maximise sales revenue.
- To assist in any other way to ensure the revenue and takings of CS are accurate and protected, performing other tasks not identified in this description relevant to the overall objectives of the role.
- To be proficient in the billing process