Commercial Analyst (Retail and Surface Access)

The recruitment process for this role will be comprised of two stages. There will be a first stage Teams interview, and successful candidates will then be invited to an in person, second interview which will involve a presentation to be confirmed on invite to interview. Depending on the volume of applications, we may introduce an online assessment as a first sifting stage.

Please note, our interview process may be adjusted depending on the volume of candidates. We are committed to supporting diverse ways of thinking and working, so if you require adjustments in the recruitment process, please let us know on your application. You can find out more about our interview process and the types of questions we ask here.

What you’ll be doing

Commercial Insight & Decision Support

• Analyse performance across Retail (Shops, Catering, Bureau, Duty Free) and Surface Access (car rental, public transport, taxis etc).
• Monitor commercial trends, revenue drivers, passenger behaviour, conversion, penetration and yield.
• Translate data into clear findings, commentary and recommendations for commercial stakeholders.
• Support regular performance reviews by preparing insight packs, dashboards and supporting analysis.
• Identify risks, opportunities and areas for improved commercial performance.
• Support ad-hoc analysis for contract discussions, bid reviews, business cases and commercial proposals.
• Conduct benchmarking analysis against comparable airports and relevant sectors.

• Support the Commercial Analytics Manager with budgeting, forecasting and reforecasting processes.
• Provide analysis of trends, seasonality and performance drivers to inform revenue projections.
• Support month-end reporting by validating data and ensuring actuals are accurately reflected in reports, dashboards and insight packs.

• Develop, maintain and improve commercial dashboards, reporting packs and KPI trackers across Retail and Surface Access.
• Create clear, intuitive and visually engaging reports that help stakeholders understand performance quickly.
• Use Power BI and other reporting tools to turn complex datasets into simple, actionable dashboards.
• Ensure reporting outputs are accurate, consistent, timely and aligned with business requirements.
• Identify opportunities to automate recurring reports and reduce manual reporting effort.
• Help standardise reporting layouts, definitions and data sources across Retail and Surface Access.

• Work with Commercial, Finance, Billing, IT and Data teams to ensure data is accurate, complete and fit for purpose.
• Support improvements to datasets within the Commercial Data Warehouse.
• Test and validate data outputs used in dashboards, reports and commercial analysis.
• Document reporting logic, KPI definitions, data sources and dashboard methodologies.
• Identify and implement improvements that increase reporting accuracy, consistency and scalability.

• Strong data visualisation skills, with the ability to turn complex information into clear, engaging and actionable reporting.
• Strong numerical and analytical skills, with good attention to detail.
• Strong Excel skills, including formulas, pivots, lookups and structured modelling.
• Ability to turn data into clear insight, commentary and recommendations.
• Strong written and verbal communication skills.
• Organised, proactive and able to manage multiple priorities.
• Curious, improvement-focused and willing to challenge existing ways of working.

• Pension scheme- employer contributions can be up to 7%
• 32 days holiday, based on full time roles, increasing with service
• Annual discretionary bonus
• Supporting your health and wellbeing- private healthcare after 1 years’ service, access to our Employee Assistance Programme and occupational health services
• Free car parking on site and when you go on holiday
• We offer a range of other benefits, find out more here

Why EDI?

We are Edinburgh Airport, where Scotland meets the world. The success of the airport comes down to our people, and you can help us deliver even more big days for our passengers and colleagues. The development of your career is important to us, and we’ll support and encourage this every step of the way. We offer in-house and external training, both role specific and based on your objectives.

As a business we’re driven by our values – they’re at the core of our culture and everything we do. We will ask questions based on our values during your interview, as we’re looking for people who will demonstrate these values day-in, day-out. So if this sounds like you, apply now and get ready for your career to take off. 

As a Disability Confident Leader, we are committed to ensuring applicants with a disability can participate fully in our recruitment process. Please let us know in your application form if you require any adjustments, such as parking arrangements or alternative methods of communication.

We work with Inclusive Employers, who are a leading organisation for employers committed to prioritising inclusion. We are supported by them through leadership workshops, a variety of resources and webinars,  demonstrating our commitment to an inclusive workplace and ensuring all our employees feel valued. This partnership is part of our wider Diversity and Inclusion strategy, and you can find out more here.

We give colleagues the opportunity to engage with different people and projects, within our business and beyond. You can get involved in a variety of different employee groups, including Diversity, STEM, Wellbeing, or create your own community - it's important to us that you can share your interests and be yourself at work.