Commercial Data Product Analyst
2 days ago
Sheffield
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, ScotRail 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. Not your average role…. The Commercial Data Product Analyst plays a pivotal role in delivering ScotRail’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 ScotRail’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. What you bring: 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. Key responsibilities Commercial Data Strategy & Development • Support the Commercial Data Product Manager in shaping, delivering, and maintaining ScotRail’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 analytical solutions., • Provide ad hoc data support to the commercial function to answer queries and inform business decisions., • Mine existing data sources and assess the value of open source and third-party supplier data, developing use cases to demonstrate impact., • Collaborate with internal and external partners on data projects, ensuring datasets are accurate, reliable, and aligned with business objectives. Data Visualisation, Reporting & BI governance • Design & maintain dashboards, visualisations, and reports to present data clearly and effectively for decision-making., • Translate complex data into actionable insights for commercial teams and senior stakeholders., • Support adherence to the organisation’s BI strategy, ensuring data practices align with wider business objectives and contribute to its ongoing development. Essential skills • Degree in a quantitative or business-related field., • Expert in manipulating complex datasets with Excel, Power BI/Power Query, and Python or R., • Proficiency in SQL (advanced queries and optimisation) and relational databases., • Experience building data models and dashboards to drive executive decision-making., • Ability to turn business needs into technical insights and communicate them to non-technical stakeholders., • Proven record of working with data engineers to optimise processing flows., • Commercial mindset with the ability to manage multiple priorities under tight deadlines. Desirable skills • Application of data mining and machine learning techniques., • Experience with software development best practices including Git & DevOps or equivalent. What we offer you: ScotRail offer an excellent rewards package including: • Contributory Final Salary Pension scheme., • Free and reduced rate rail travel for you and your family., • Generous holiday allowance., • Enhanced company sick pay and family leave including maternity, paternity and adoption., • Life Insurance cover for 4 x annual salary., • Contributory lifestyle benefit options including discounts at hundreds of retailers, cycle to work scheme, discounted gym memberships and healthcare cashback plan. This is a full-time role, 35 hours per week, working Monday to Friday. Please note that due to the volume of interest received these vacancies could close prior to the published date. Selection Process Selected candidates will be invited to a competency-based interview. All offers are subject to passing our pre-employment checks which include a criminal record check, medical and referencing. Equal Opportunities ScotRail is seven times accredited as a Top Employer, has achieved Leaders in Diversity and is a Disability Confident Employer. We value, celebrate, and respect the diversity our people and aim to inspire, attract, retain, and develop the best talent. Because we value diversity and the benefits it brings, we want to continue improving the diversity of our people and particularly welcome applications from women, young people, LGBT+ people, people with a disability, and people from ethnically diverse background.