Commercial Data Product Analyst

Commercial Data Product Analyst

Contract – Permanent

Location:

Atrium Court/Glasgow

Salary:
Up to £44,000 per annum depending on experience

With more than 5,000 employees, Scot Rail plays a vital role in serving the people and communities of Scotland. We recognise a modern and diverse workforce, encouraged to use their talents, and develop their skills, is integral to our success in serving and reflecting the communities of Scotland. We are committed to being a diverse and inclusive employer and have also set ourselves ambitious sustainability targets including having a carbon‑free railway in Scotland by 2035.

The Commercial Data Product Analyst plays a pivotal role in delivering Scot Rail’s Commercial Data Strategy, turning data into actionable insights that drive commercial performance and innovation. Using cutting‑edge analytics, automation and business reporting tools while collaborating closely with stakeholders from all areas of the business, this role aims to ensure data is both a strategic asset and a practical decision‑making tool.

The post holder will explore new data sources, techniques, and technologies to solve complex business challenges, while identifying opportunities to automate processes and generate secondary datasets that align with commercial objectives, helping to improve operational efficiencies, grow revenue and increase customer satisfaction.

The role will involve extensive collaboration with internal teams and external partners to ensure accurate, reliable datasets are delivered and fully leveraged. Working alongside data engineering colleagues, the analyst will maintain robust monitoring solutions and ensure the reports powered by these datasets are clear, actionable, and impactful for business users.

At the heart of this role is the maintenance and development of our critical dashboards and analytical tools, including Scot Rail’s industry‑leading passenger counts platform. This essential system combines multiple large datasets using a complex data model and advanced SQL queries, making it a vital resource for spatiotemporal insights into network usage and supporting decision‑making across the business. The post‑holder’s expertise will ensure these tools remain robust, reliable and transparent while evolving to deliver even greater insights, enabling colleagues in all areas to drive smarter, data‑led decisions.

You will be a curious and analytical problem‑solver, equally comfortable diving into complex datasets and optimising queries as you are translating insights into actionable business strategies. You thrive at the intersection of data and commercial impact, using your proficiency in SQL, Python, or data visualisation tools to uncover trends, automate processes, and create innovative solutions. You are detail‑oriented without losing sight of the bigger picture, allowing you to spot opportunities in data that others might overlook, while always keeping the organisation’s commercial goals in focus: weighing the “nice to haves” with the “must‑delivers”.

A natural collaborator, you will be comfortable bridging the gap between technical teams and business stakeholders. You communicate clearly and persuasively, whether explaining a data model to engineers or presenting insights to colleagues. Your ability to listen, ask the right questions, and align data solutions with business needs makes you a trusted partner across the organisation. You’re proactive in gathering requirements and anticipating challenges, ensuring that data products are accurate, user‑friendly, and impactful.

• Commercial Data Strategy & Development
  • Support the Commercial Data Product Manager in shaping, delivering, and maintaining Scot Rail’s Commercial Data Strategy.
  • Research, evaluate, and develop novel solutions for big data challenges, exploring new sources of data, techniques, and automation opportunities.
  • Scope and evaluate opportunities to generate new secondary data sets to support business objectives.
• Data Analysis, Insight & Stakeholder engagement
  • Engage with stakeholders to gather data and insight requirements, translating them into actionable…