Commercial Analyst Edinburgh, Scotland
Job description
Details
Reference number
Salary
Job grade
Contract type
Business area
Type of role
Working pattern
Number of jobs available
Contents
Location
About the job
Benefits
Things you need to know
Apply and further information
Location
About the job
Job summary
Job description
Monitoring & Reporting
- Oversee the development of our reporting suite across Power BI, SQL, and Excel.
- Maintain our automated reporting through SSRS and work with Teams and Finance to improve reporting.
- Oversee the production and circulation of the weekly and monthly trading reports and summaries for business tracking purposes.
- Work with senior managers in the Marketing & Engagement team to produce the monthly & Quarterly Commercial Review.
- Develop a common approach to the presentation of information, creating reports which are easy to understand and aid decision making across the agency.
- To work with any future systems to develop a reporting suite that accurately monitors the commercial performance and operational effectiveness of the agency.
- Assisting in the ongoing analysis of our site’s income & expenditure accounts.
- Reconciling income monthly/annually against Finance accounts and assisting in end of year audit.
- To oversee the provision of ad hoc reports as required by the senior CVO team and other senior managers.
Development Projects
- Carry out desk research and meet other organisations to assess best practice.
- Assist in the development of business cases with visitor and financial analysis.
- Working with teams across HES on implementation of new developments.
Industry Benchmarking
- Overall responsibility for the provision and receiving of figures for industry bodies (ASVA, ALVA, Moffat Centre, Visit Scotland and others) as required.
Forecasting
- Reporting on annual target processes and quarterly reforecast adjustments
- Co-ordinate annual rolling visitor and income forecasting process for all sites and income streams
- Profiling of the annual sales forecasts for all sites.
- To development admissions pricing models as appropriate to help understand and forecast the income potential from all site admissions.
Person specification
Essential requirements:
- MS Office skills, particularly Excel
- Experience of using business intelligence tools to develop reports against complex databases
- Experience reporting using Business Intelligence tools (Cognos/Power BI etc)
- Direct experience of analysing business trends and interpretating data across complex income streams
- Experience of forecasting and monitoring performance against targets
- Excellent written and oral communication skills
Desirable requirements:
- Experience of working in the tourism sector
- Knowledge and experience of Historic Environment Scotland
- Experience of working with ticketing databases, i.e. Galaxy
Benefits
We welcome applications from all nationalities, assuming that they have the right to work in the UK: applying for a job with us could open the door to a unique work environment. It will give you job satisfaction and excellent development opportunities, plus a competitive salary, 25 days paid holidays (rising to 30 days after 3 years’ service) and 11.5 public holidays a year – pro rata for part time staff.
In addition we offer a great benefits package to our employees which includes:
- flexible working hours (where appropriate)
- special leave
- maternity/paternity leave
- adoption leave
- reimbursement for relevant professional subscriptions
- support for further education and personal development
- study leave for work related courses
- access to a learning resource centre
Health and welfare
We offer you access to:
- our Employee Assistance Programme – for confidential advice and counselling
- an occupational sick pay scheme
- discounts at some local authority leisure facilities
- access to a free Headspace membership
- interest free loans for bicycles and annual travel passes (see ‘season ticket’ below)
- reasonable adjustments when needed, as part of our Equalities policy
Staff discounts
You will receive:
- free entry to all of our properties (with up to three guests)
- free entry to English Heritage, Manx and Cadw properties
- 20% off purchases in our retail outlets
Season tickets
You can receive an advance to help with the cost of buying an annual season ticket for travel between home and work. The advance is then repaid from your salary over the life of the season ticket. Available to all permanent and fixed-term staff.
Things you need to know
Selection process details
You can apply on-line by visiting our website at https://applications.historicenvironment.scot/
Guidance on completing the application can be found in the ‘Guidance notes for applicants’ document, also available at the above website, which we recommend that you read, in conjunction with this Job Description.
Your application must arrive by the advertised closing date. Please note that when applying online, we will only be able to see your application once you fully submit it.
If you are unable to complete an online application form, please email [email protected], quoting the job title and recruitment reference, and we will arrange for an application form to be sent to you.
Please note that, as we operate an electronic recruitment system, we will contact you via the email address that you provide in your application to inform you of the outcome of your application.
For further information about the post, please contact Emma Martin, Commercial Planning Manager via email at [email protected] .
We welcome all applicants from under-represented groups within HES. We know from our equality monitoring that we need to increase our diversity in terms of ethnicity and disability. We also want to address occupational areas where the ratio is disproportionately in favour of women or men. We ask all applicants to complete the Equality Monitoring section of the recruitment paperwork to help us pursue a diverse and inclusive workforce. In support of our Gaelic language plan we welcome applications from Gaelic speakers.
Feedback will only be provided if you attend an interview or assessment.
Security
Medical
Nationality requirements
This job is broadly open to the following groups:
- UK nationals
- nationals of Commonwealth countries who have the right to work in the UK
- nationals of the Republic of Ireland
- nationals from the EU, EEA or Switzerland with settled or pre-settled status or who apply for either status by the deadline of the European Union Settlement Scheme (EUSS) (opens in a new window)
- relevant EU, EEA, Swiss or Turkish nationals working in the Civil Service
- relevant EU, EEA, Swiss or Turkish nationals who have built up the right to work in the Civil Service
- certain family members of the relevant EU, EEA, Swiss or Turkish nationals
Working for the Civil Service
We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles (opens in a new window).
Apply and further information
Contact point for applicants
Job contact :
Recruitment team :
