Details Reference number 350654 Salary £45,000 - £50,000 A Civil Service Pension with an average employer contribution of 27% GBP Job grade Higher Executive Officer Contract type Permanent Type of role Accountancy Working pattern Full-time Number of jobs available 1 Contents Location About the job Benefits Things you need to know Apply and further information Location Westminster, London About the job Job summary To deliver accurate historical income and profit margin by event type in the form of a Profit & Loss. This aspect of the role will focus on supporting the sales and marketing teams by analysing historic data and deriving insights for maximising income and profit margin. Job Purpose To deliver accurate historical income and profit margin by event type in the form of a Profit & Loss. This aspect of the role will focus on supporting the sales and marketing teams by analysing historic data and deriving insights for maximising income and profit margin. To forecast realistic future income and profit margin by event type for inclusion in the forward-looking business plan and subsequent reforecasts - comprising Profit & Loss, Balance Sheet and Cash Flows. This aspect of the role will work hand-in-hand with the sales team to set stretch performance targets for maximising income. To build the forward-looking business plan and subsequent reforecast for the full suite of Profit & Loss (i.e. all income and expenditure items), Balance Sheet and Cash Flows. This aspect of the role will focus on analysing deviations between actual versus plan, and will entail liaising with various teams (e.g. sales, audio visual, catering, venue operations, human resources). In addition to the above, the role will include wider aspects of steering Business Performance, such as creating dashboards of key metrics and preparing other ad hoc analyses as required. Key Tasks General Gain Super User status for Momentus Ungerboeck EBMS (Events Booking Management System) and undertake the following: Specialise in Report production from EBMS. Review and update Reporting templates. Improve Reports especially for live information reporting. Communication point for external EBMS consultant for errors, report creation and modification requests. Attend Ungerboeck Independent User Group meetings. Prepare historical Profit & Loss by event type. Build business plans and reforecasts of forward-looking Profit & Loss, Balance Sheet, Cash Flows. Create Business Performance reports for CEO/Directors as defined, evaluate results and provide commentary. Review payment invoices of Agency commissions for introducing business and raise purchase orders. Weekly Tasks Report Enquiry Counts and red alert months (when sales fall below plan) in weekly sales meetings. Report Enquiry Counts by Event Week with quote-to-contract sale conversion rates. Email Sales/Marketing and Directors with overview of sales activity including recent contracts sent out or big wins. Monthly Tasks Report Monthly Income with future forecasts broken down by month for current year, future year ahead, and prior year comparison. Report Enquiry Counts by Event Month with quote-to-contract sale conversion rate. Report Enquiry Counts by Enquiry Month with quote-to-contract sale conversion rate. Report Occupancy Days by Meeting Rooms and Size Category. Lost Business deep dive into booking cancellations and non-renewals, including reasons. Quarterly Tasks Track Financial Year actuals versus plan: Occupancy Days by Meeting Rooms analyse deviation between actuals versus plan split by size category, weekday AM, weekday PM, weekend AM, weekend PM. Room Hire income analyse deviation between actuals versus plan in total, by client industry sector (e.g. pharmaceutical, education etc), and by client geographic market (e.g. UK, US etc). Quarterly Monitoring report for Sales/Marketing and Directors: Total Event Counts split into government and non-government, with prior year comparison. Total Enquiry Counts split into UK and non-UK, with quote-to-contract sale conversion rate, event delegate size, event type (e.g. conference, graduation, filming). Reports for Management and Advisory Boards Yearly Tasks Business Plans and Reforecasts: Roll forward various data input files: Occupancy Days by Meeting Rooms split by size category, weekday AM, weekday PM, weekend AM, weekend PM. Room Hire income split by client industry sector and client geographic market. Enquiry Counts split into UK and non-UK, with quote-to-contract sale conversion rate, event delegate size and event type. Pricing for future years start process 6 months before 1 April rate change: Check audit visual packages are not changing with Audio Visual. Agree room hire price increases with Directors. Calculate secondary income ratios for audio visual and catering. Obtain historic general ledger income split from QEII Live and load into EBMS. Communicate to Sales/Marketing and Finance teams. Administration Undertake and manage specific projects set by the Finance Director and other Directors working to agreed timescales and budgets. Product Knowledge Maintain a current and accurate knowledge of QEII Centre service offerings including secondary services (audio visual, catering). Maintain a current and accurate knowledge of competitor service offerings, pricing structure and activity. The above is not exhaustive and other duties not outlined may form part of the employees job description. Person specification Essential Criteria Qualified accountant, or part-qualified accountant who has passed the majority of papers. Experience of working in a sales/income management environment within the events/hospitality industry sector. Excellent IT skills and experience of operating a Customer Relationship Management (CRM) system from a sales/income management reporting perspective. Highly skilled at using Data Analysis and Visualization tools such as Excel, Powerpoint, Power BI. Effectively manage time and resources, work under own initiative and adopt best practice. Strong administrative skills with ability to plan, organise and deliver work to meet deadlines and quality standards. Strong written and verbal communication skills. Strong numeracy skills. Desirable Criteria Experience working with Momentus Ungerboeck EBMS (Events Booking Management System) Behaviours We'll assess you against these behaviours during the selection process: Working Together Seeing the Big Picture Delivering at Pace Managing a Quality Service Communicating and Influencing Benefits Alongside your salary of £45,000, Queen Elizabeth II Conference Centre contributes £12,150 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides. QEII benefits will include: Bonus scheme (discretionary) calculated on corporate and individual performance Membership of the Civil Service Pension Scheme 25 days' annual leave with an additional day per year to a maximum of 30 days & 1 privilege day Subsidised staff restaurant/coffee bar Interest free season ticket loan Cycle to work scheme On site cycle rack 3 days paid volunteering Participation at staff events; celebratory, educational, team Access to learning and development tailored to you A working culture which encourages inclusion and diversity Regular employment engagement activities Things you need to know Selection process details This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours. How to Apply Candidates should apply by submitting their CV and a statement of suitability to hrqeiicentre.london having reviewed the Job Description which is available on our website. The statement of suitability should be no more than two sides of A4 and should set out how the candidate meets the criteria set out in the person specification within the Job Description. The closing date for applications is 3rd May 2024 23.59 This vacancy is using the Civil Service Success Profiles Framework, and will assess your Behaviours, Strengths, Experience and Technical skills as set out in the job specification. Applications will be sifted on candidates' experience against the requirements of the role on 9th May 2024. Candidates successful for interview stage will be required to undertake word-based or excel-based exercises prior to their interview. Interviews will take place on 16th May 2024. Feedback will only be provided if you attend an interview or assessment. Security Successful candidates must undergo a criminal record check. Successful candidates must meet the security requirements before they can be appointed. The level of security needed is counter-terrorist check (opens in a new window).See our vetting charter (opens in a new window). People working with government assets must complete baseline personnel security standard (opens in new window) checks. Medical Successful candidates will be expected to have a medical. Nationality requirements This job is broadly open to the following groups: UK nationals nationals of the Republic of Ireland nationals of Commonwealth countries who have the right to work in the UK nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS) (opens in a new window) nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS) individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020 Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service