Role overview 

As the Business Intelligence Analyst you will design, develop, and maintain processes that provide consistent, reliable, and automated delivery of data to RMCC and its relevant stakeholders. Support growth of the centre by assisting the Senior Management Team and Cluster Revenue Managers in the strategic coordination of revenue management processes and procedures. Continually maximise the efficiency and drive the innovation and development of the Analyst team through forward looking thinking and the creation, implementation and maintenance of data warehouses, reports, and tools for RMCC. 

What will I be doing? 

• Ensure consistent process & procedures for all hotels being managed in the RMCC by covering all the Analysts’ production tasks as and when necessary
• Ensure the delivery of a reliable and versatile reporting package to all stakeholders within the assigned deadlines
• Gather and process raw data at scale, including writing scripts, web scraping, calling API’s, write SQL queries
• Review data collection processes and assess the validity of the information stored
• Identify and eliminate any processes or procedures that contribute to unreliable data being collected
• Identify opportunities to use data and analytics to improve operational performance.
• Maintain effective and regular communication with all stakeholders to ensure that all relevant requests, which enable the implementation of optimal strategies and controls are dealt with in a professional and efficient manner
• Drive the innovation of the Analyst department by engaging in project work and responsibilities that actively enhance the performance and scope of the Analyst Team’s capabilities
• Support the successful completion of all objectives linked to the Analysts and RMCC Strategic Frameworks

Key areas of Accountability: 

Profit

• Ensure all Best Practices and Standard Operating Procedures are followed to capitalise and maximise revenue potential.
• To utilise systems, tools and reports in the prescribed way to ensure all revenue management decisions are supported with relevant data analysis.
• Continuously drive innovation to ensure that RMCC has access to the most up to date systems available in order to make fast and effective revenue management decisions and capitalise on the current market.

Quality

• Follow Best Practice and Standard Operating Procedures for the RMCC to ensure all commercial decisions are supported by appropriate data analysis.
• Feed ideas and suggestions into to strive for constant improvement of operating procedures.
• Consistently evaluate current procedures and data sources to ensure the Revenue Managers and Senior Team are provided with the most reliable and accurate data available.

Customer

• Build an effective working relationship with all stakeholders in order to maintain their trust and confidence in the Revenue Analyst team’s product as well as the decisions and actions being taken among the Revenue Managers and Senior Team.

People

• Supports all Revenue Managers and Senior Leadership in the RMCC to ensure a constant and consistent delivery of Revenue Management reporting materials and to drive the business processes forward.

Specific Accountabilities: 

Reporting: 

Update, process, generate and distribute daily, weekly and monthly revenue management reports 

·       Produce, ensure accuracy and distribute Daily Detail reports on a daily basis with data gathered from various sources

·       Produce, ensure accuracy and distribute reports and other materials for regular meetings and business processes including, but not confined to, Business Focus Meeting (BFM) packs, and Commercial Review Packs

·       Complete Analyst daily/weekly/monthly tasks, including the distribution of Senior Team reporting alongside other duties, and take ownership of said tools/reports on a rolling annual basis. Ownership includes maintenance, support and innovation of currently owned tools/processes through the use of evolving technical skills

·       Perform the above tasks with the use of various systems including MS Excel, Access & Outlook alongside the use of the VB.Net framework, VBA, SQL, Python and other coding languages

·       Utilize Microsoft SQL Server and Db Visualizer for extraction and analysis of data from multiple sources with demonstrated ability to effectively manipulate and report data

·       On-board hotels into RMCC MEA with the use of the Analyst on boarding procedure and checklist

·       Assist with preparation and automation of ad hoc and reoccurring reporting assignments from the Leadership Team in a timely and effective manner

Project Based Work: 

Create, develop and innovate 

·       Create and develop new reports as required within data environments and systems including Redshift, MS Excel, MS Access, Power BI, MicroStrategy or similar to assist in the preparation for revenue management meetings or data analysis

·       Development of analytical tools that provide enhanced decision support and analysis to corporate and property users

·       Actively seek ways to and participate in the innovation and development of current Analyst procedures, tools and processes

·       Project Management of tool development projects and roll-outs

·       Ensure that the Analyst Strategic Framework targets are met through active participation in assigned Strategic Framework project work

·       Participate in periodic research on evolving trends and best practices within Data and Analytics alongside current technological advancements that may provide benefit to the centre