Commercial Analyst

East Midlands Railway; East Midlands; Hybrid; GBP 44,000 - 54,000; Full time

Benefits offered by this job

Free travel on EMR services

Rail discounts

Leave allowance 32 days

Personal development opportunities

Job summary

East Midlands Railway (EMR) invites applications for a Commercial Analyst based in our Derby head office. You will join the Commercial Insights team, shaping revenue analytics, building dashboards, and delivering regular reporting to inform strategic decisions and drive growth.

We seek a degree-level candidate with strong numerical skills, experience in Excel/Power BI/Tableau, and the ability to translate complex data into clear recommendations for senior stakeholders. Hybrid working supported.

Qualifications

• Educated to degree level or equivalent experience.
• Strong numerical and analytical capabilities.
• Experience with large datasets and financial modelling.
• Experience turning data into actionable insights for stakeholders.

Responsibilities

• Shape and deliver the commercial analysis strategy to guide revenue growth.
• Provide regular and ad-hoc revenue reporting and insights to executives.
• Design, develop and maintain self-service dashboards for stakeholders.
• Improve analytical processes and data quality across the team.
• Support research projects and capture learnings to inform analyses.
• Conduct financial modelling to assess revenue benefits of business cases.
• Be the expert on revenue performance for other departments.

Skills

Commercial acumen

Numerical analysis

Data visualization

SQL

Dashboards

Stakeholder communication

Education

Degree or equivalent

Tools

Excel

Power BI

Tableau

SQL Server Management Studio

Job description

Salary: circa £48,896, dependent on experience + free train travel on EMR services

ClosingDate: Wednesday 02 September 2026

InterviewDate: See advert

Reference: 2026-CA2

We are proud to be One Team at East Midlands Railway (EMR). We are passionate about keeping people safe, delighting our customers, doing the right thing and putting customers at the heart of our sustainable railway for the East Midlands. With over 2,600 employees, our people are the reason we are so successful and our Commercial team make a crucial contribution to this.

Ten times accredited as a Top Employer and Gold accredited for Inclusive Employers Standards, we value our people and are dedicated to making sure that everybody feels empowered to bring their authentic self to work.

At EMR we want to proactively embrace diversity across our workforce and recognise that we are under‑represented in some areas. We’re therefore taking positive steps to promote a positive and inclusive culture and we welcome applications from everyone to help us better represent our communities.

We have an exciting opportunity to join #TeamEMR as a Commercial Analyst.

This role reports to the Senior Commercial Insights Manager and is based in our head office in Derby. This is a fantastic opportunity for someone who has strong analytical skills and a drive to make a measurable difference in achieving financial targets and driving commercial development. Utilising a range of skills and systems, you will play a key role in helping the business to develop a greater understanding of our customers and identifying opportunities for revenue growth.

Key Roles and Responsibilities

• Help to shape and deliver the commercial analysis and insights strategy to guide our commercial approach as a business and drive revenue growth
• Provide regular and ad-hoc revenue reporting and analysis, generating insights into our customers and markets and presenting findings to a wide range of stakeholders including senior level executives
• Design, develop and maintain scalable self-service reporting and dashboard solutions, enabling stakeholders across the business to independently access, explore and act on commercial data
• Identify opportunities to improve analytical processes, reporting, and ways of working, to drive efficiencies, enhance data quality and help embed best practice across the Commercial Insights team
• Support research projects, providing input to market research proposals and capturing the learnings of research to improve internal analysis
• Conduct financial modelling to evaluate the expected revenue benefits of business cases and analyse the observed impacts once projects are delivered to assess whether benefits are being realised
• Be an expert on revenue performance for the rest of the business, helping other departments to understand what drives revenue performance and making sure commercial impacts are considered in all business initiatives

Key Skills & Experience

• Educated to at least degree level or equivalent experience
• Strong commercial acumen, with the ability to accurately assess the factors influencing performance and make recommendations to optimise commercial results
• Highly skilled in numerical analysis, with the ability to deliver detailed analysis, financial modelling, forecasting, and reporting, using tools such as Microsoft Excel, Power BI, Tableau or other similar data visualisation platforms
• Proficiency working with large, complex datasets, including data extraction, transformation and modelling, to support scalable analytics. Experience using SQL and SQL Server Management Studio beneficial but not essential
• Strong experience developing interactive dashboards and self-service reporting solutions, with a focus on usability, accessibility and stakeholder adoption
• Excellent ability to interpret business requirements and translate complex issues into clear, concise and audience-appropriate insights and recommendations
• Self-motivation, positivity and determination to deliver high quality outcomes in your work, both individually and as part of a team
• Ability to grasp and solve complex issues and systems quickly and independently

As well as a competitive salary, we’ll also offer you:

• 32 days annual leave (including bank holidays), rising to 34 days after 2 years of service
• Free travel on East Midlands Railway and other train companies operated by Transport UK
• 75% discount on other national rail train companies, including for partners and dependants
• Discounted friends and family tickets on the EMR network
• Various personal development and progression opportunities

EMR has a hybrid working policy which is applicable for this role. This means the role can be based at home 2-3 days per week and on site 2-3 days per week. Should you wish to work full time on site, this is also an option.

We are open minded to applications from people who wish to have flexible working. Many of our staff work flexibly in many different ways. Please talk to us at interview about the flexibility you need. We can’t promise to give you exactly what you want, but we do promise not to judge you for asking.

If you're successful in this role, you'll be expected to support our frontline colleagues at some points throughout the year. This might be undertaking safety critical work, for which you'll receive training, but it could just be helping out with Customer Service when our stations are busy. We're One Team, and that means our managers step up for the frontline, not just manage from a distance. Supporting frontline colleagues is part of our DNA at EMR.

We welcome applicants from diverse backgrounds, we promote equal opportunities for all. East Midlands Railway is a non-discriminatory employer committed to the recruitment and promotion of all on the basis of ability and merit irrespective of disability, race, gender, health, social class, sexual preference, marital status, nationality, religion, employment status or age. We’ll treat your application fairly and assess you for the job based on merit and skills.