Revenue Data Analyst Caledonian Sleeper Permanent, Full time 37.5 hours per week Hybrid working (2 days in the office – Inverness or Glasgow) Competitive salary plus benefits The Caledonian Sleeper team are looking for a Revenue Data Analyst to join their Finance and Revenue team. This is an exciting opportunity for an enthusiastic and motivated analyst to join the Caledonian Sleeper Retail and Pricing team. The Revenue Data Analyst is a new role which will support the Head of Retail and Pricing, dealing with all aspects of the organisation’s revenue generation processes from maintenance of back end systems that support selling to the guest, post sale and travel analysis. The role enables greater insight to optimise revenues and continually improve our guest experience to meet and exceed their expectations. In June 2023, the business transferred into Scottish public sector ownership and this has allowed the opportunity to build and expand in-house analytics and automation. This role is to support this area of expertise, allowing the business to maximise the potential of improved analytics for decision making purposes, whilst also being responsible for managing the operational mechanics of the organisation’s revenue systems. The role will report to the Head of Retail and Pricing and work closely with team members including the recently appointed Business Intelligence Lead and other colleagues in the broader Caledonian Sleeper business. Main Accountabilities: Maintenance of schedule and formation changes in RARS (the Rail Industry Reservation system) so that these reflect the current timetable and planned service formation to ensure that the reservation inventory reflects both the timetable and formation of the train that will operate. Ensuring the latest Engineering Works position is reflected in RARS and matches that in the industry data. When engineering work has been processed in the reservations system identify Guests who are impacted by these changes and advise the Guest Services team. Work with the Head of Retail and Pricing and the Business Intelligence Lead to develop improved reporting capability for historic and forecast revenues, sales and occupancy data. Monitor in house reporting to investigate booking anomalies and ensure these are reported and rectified. Ad hoc analytical and testing tasks as required by the Head of Retail and Pricing and Business Intelligence Lead. Monitoring of Revenue Optimisation software to ensure that Revenue is being maximised. Ensuring reports from external systems for example website back office are generated for loading into the CSL data warehouse. Ensuring Transport Focus receive customer data to enable distribution of post trip surveys. Extraction of data from central Rail Industry systems into the Caledonian Sleeper Data Warehouse for example Tableau sales data and reservation data Assist the Business Intelligence Lead in further automation of data flows, developing the reporting suite to enhance insights. Investigation and recording of Credit Card chargebacks. What you’ll need to do the role: This details the key competencies (knowledge, skills, and abilities) required to complete this role. For the purposes of recruitment and selection the indicators below will be used in the shortlisting and assessment process for this role. You should therefore address these areas fully in your application. You will be confident working with Excel, PowerBI and other Microsoft Office packages and will have a strong attention to detail. An understanding or willingness to learn SQL. Strong analytical skills with the ability to manipulate/interpret complex data and evaluate information objectively and accurately. An understanding or willingness to learn the dynamic revenue management principles in a transport environment. Willingness to learn Rail Industry specific systems provided by Rail Delivery Group, principally Rail Availability and Reservations System and Tableau. A flexible team player with a high level of own initiative. Capable of working on own projects and take responsibility of own workload. Ability to work in a fast-paced environment with a varied workload. Good organisational skills to ensure deadlines are achieved. Flexible and growth mindset, capable of embracing change. Ability to create, build and maintain relationships with internal key stakeholders. Assisting with Freedom of Information and GDPR requests Education and Qualifications Educated to degree level Further relevant qualifications or CPD in a relevant area. Candidates must be willing and able to travel on occasion where appropriate, most likely between the Inverness and Glasgow offices. What we offer 25 days annual leave (pro-rata) Opportunity to join the Railway final salary pension scheme Allocation of complimentary tickets for Caledonian Sleeper each year Complimentary Scotland wide rail travel with ScotRail for the employee and qualifying family member Please click on the apply button to complete your application. Occasionally we receive a large volume of applications for our roles and when that happens, we sometimes bring the closing date forward, so please apply promptly to avoid disappointment. At Caledonian Sleeper Limited we are committed to building a diverse and inclusive organisation that supports the needs of all and matches the diverse profile of our guests. As such we will make reasonable adjustments at interview through to employment for our candidates and strongly encourage applications from all if you feel you match the skill requirements of the role. We are open to discussions around flexibility and flexible working. Disabled applicants who meet the minimum criteria for the job will be given the opportunity to demonstrate their abilities at an interview. Caledonian Sleeper is an iconic brand with a heritage stretching back a century and a half to the early years of Scotland-London sleepers. Part of an exclusive club, Caledonian Sleeper is one of only two sleeper trains in the UK, and we like to think it is the most scenic Whisking guests from the bright lights of London through the night to the iconic cities of Aberdeen, Edinburgh, Inverness, and Glasgow or to the jaw dropping scenery of the west Highlands of Scotland around Fort William. We are proud to serve the UK’s most remote railway station too, Corrour. Caledonian Sleeper sets new standards in overnight rail travel, offering a choice of affordable seats, private guestrooms, some with en-suites and double beds, as well as our much-loved Club Car to around 200,000 guests per year. Serco is acting as the resourcing partner for Caledonian Sleeper Limited which is operated by Scottish Rail Holdings on behalf of the Scottish Government.