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.

DevOps Engineer - Glasgow - Public Sector - Outside IR35

Day Rate - Market Rates

Duration - 6 months with a view to extend

Harvey Nash’s Client are hiring a contract DevOps Engineer, you will join a team focused on building a cloud based platform. You will be expected to be embedded into the Digital team as well as working with the other members of the business.

Responsibilities

• Implement high-level technical requirements in a reliable, scalable and performant way
• provide coaching and mentoring to more junior colleagues
• ensure due technical consideration is given to make processes repeatable, scalable and secure
• have deep technical knowledge and experience in DevOps environments, providing support to delivery teams and solving complex problems
• Attend all associated Agile ceremonies and make use of collaborative tooling (Slack, Confluence, Jira)
• Be proactive on identifying improvements.
• Be transparent and collaborative when making decisions

Skills & Experience Required

• 5+ years in a hands-on platform engineer / devops role working at a senior level
• Expert level Kubernetes infrastructure build and operate experience
• Demonstrable experience building secure solutions on Kubernetes at scale, ideally using AWS EKS
• Ability to contribute to architecture roadmap for business area through leading and participating in Proof Of Concept (POC)/prototyping initiatives
• Experience implementing CI/CD pipelines
• Experience designing, documenting and presenting secure solutions to stakeholders
• Experience implementing service mesh technologies (Istio)
• Experience building secure solutions using Hashicorp Terraform
• Worked in a GitOps-driven environment
• Able to provide ongoing and appropriate mentorship for DevOps Engineers
• Be eligible for SC level Security Clearance

Significant practical experience and able to evidence detailed technical knowledge of:

• AWS technologies (Compute, Networking, Security, Organisations, Toolsets), Linux, Containers and container orchestration, Helm, Terraform, Git.
• Managing infrastructure as code, catering for multiple environment differences
• Configuration Management
• Secrets Management
• TLS, mTLS
• Authentication technologies.

Some experience with:

• Coding in Python
• Interacting with APIs
• Production support of Java applications.

Desirable Skills & Experience

• Experience working on AWS Cloud migration projects
• Experience with any or all of: Terragrunt & ArgoCD
• Experience supporting the build, deployment production support of Java applications
• Solid understanding of common security principles
• Vulnerability scanning & reporting experience
• Able to demonstrate they have worked in regulated environments (eg, finance, government)
• Demonstrable experience of identifying manual processes suitable for automation
• Existing SC clearance

Please note that a BPSS clearance is required to start this role.

To
From
Record Yes No

Always use these settings

Your new company You will be working at the UK's largest public ultra‑rapid electric vehicle charging network, known for its reliability, simplicity, and customer‑first approach. Founded in 2016, the company operates high‑power DC chargers ranging from 50kW to 160kW, delivering fast, hassle‑free charging across convenient locations nationwide. The company continues to expand rapidly, with over (phone number removed) live chargers across the UK as of late 2024 and a growing presence in Europe, supported entirely by 100% renewable energy. With chargers positioned at popular retail and hospitality partners such as McDonald's, Costa Coffee and Bannatyne Health Club this company enables drivers to "recharge" themselves while charging their vehicles. Their focus on user convenience includes simple contactless payments, transparent pricing, and a reputation for industry‑leading reliability. Recognised as one of the most dependable networks in the UK, they continue to scale their infrastructure to meet growing EV demand, supporting the transition to cleaner, more sustainable transport nationwide. Your new role You'll work with the Senior Data Engineer and wider teams to maintain and improve InstaVolt's data warehouse and data pipelines. Your main focus will be integrating new data sources, building data models, fixing issues, and helping the team expand our data capabilities. This role is ideal for someone who enjoys problem‑solving, learning new tools, and working with data. Key responsibilities include - Keeping an eye on data systems & fixing issues when they arise. - Building, updating & maintaining data models using dbt core and vs code. - Reviewing new potential data sources. - Connecting new data sources to the internal data pipeline and data warehouse. What you'll need to succeed - Technical - Strong SQL skills - Experience using dbt - Ability to model business processes using SQL in dbt - Familiarity with Git and version control. - An understanding of cloud data warehouse concepts. - Basic knowledge of SOAP/REST API's, JSON and YAML. - Basic Python for API data retrieval and data movement. Soft skills - Have a logical and problem-solving mindset - Be comfortable working both independently and with other members of the business. - Have strong relationship building skills across teams. - Positive attitude and eagerness to grow your technical knowledge - High attention to detail What you'll get in return - Hybid working (3 days a week in the office). - Join a fast growing company - Competitive Salary - £55,000 - Expert training and development opportunities - Employees contribute directly to reducing carbon emissions and supporting environmentally friendly transportation. What you need to do now If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV. If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion about your career. Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at (url removed)

Lead Data Engineer (Azure / Databricks)

NO VISA REQUIREMENTS

MUST BE BASED NEAR GLASGOW TO WORK 3 DAYS ONSITE

My FMCG client is undergoing a major transformation of their entire data landscape-migrating from legacy systems and manual reporting into a modern Azure + Databricks Lakehouse. They are building a secure, automated, enterprise-grade platform powered by Lakeflow Declarative Pipelines, Unity Catalog and Azure Data Factory.
They are looking for a Lead Data Engineer to help deliver high-quality pipelines and curated datasets used across Finance, Operations, Sales, Customer Care and Logistics.

What You’ll Do

Lakehouse Engineering (Azure + Databricks)

• Build and maintain scalable ELT pipelines using Lakeflow Declarative Pipelines, PySpark and Spark SQL.
• Work within a Medallion architecture (Bronze ? Silver ? Gold) to deliver reliable, high-quality datasets.
• Ingest data from multiple sources including ChargeBee, legacy operational files, SharePoint, SFTP, SQL, REST and GraphQL APIs using Azure Data Factory and metadata-driven patterns.
• Apply data quality and validation rules using Lakeflow Declarative Pipelines expectations.

Curated Layers & Data Modelling

• Develop clean and conforming Silver & Gold layers aligned to enterprise subject areas.
• Contribute to dimensional modelling (star schemas), harmonisation logic, SCDs and business marts powering Power BI datasets.
• Apply governance, lineage and permissioning through Unity Catalog.

Orchestration & Observability

• Use Lakeflow Workflows and ADF to orchestrate and optimise ingestion, transformation and scheduled jobs.
• Help implement monitoring, alerting, SLAs/SLIs and runbooks to support production reliability.
• Assist in performance tuning and cost optimisation.

DevOps & Platform Engineering

• Contribute to CI/CD pipelines in Azure DevOps to automate deployment of notebooks, Lakeflow Declarative Pipelines, SQL models and ADF assets.
• Support secure deployment patterns using private endpoints, managed identities and Key Vault.
• Participate in code reviews and help improve engineering practices.

Collaboration & Delivery

• Work with BI and Analytics teams to deliver curated datasets that power dashboards across the business.
• Contribute to architectural discussions and the ongoing data platform roadmap.

Tech You’ll Use

• Databricks: Lakeflow Declarative Pipelines, Lakeflow Workflows, Unity Catalog, Delta Lake
• Azure: ADLS Gen2, Data Factory, Event Hubs (optional), Key Vault, private endpoints
• Languages: PySpark, Spark SQL, Python, Git
• DevOps: Azure DevOps Repos & Pipelines, CI/CD
• Analytics: Power BI, Fabric

What We’re Looking For

Experience

• Commercial and proven Lead Data Engineering experience.
• Hands-on experience delivering solutions on Azure + Databricks.
• Strong PySpark and Spark SQL skills within distributed compute environments.
• Experience working in a Lakehouse/Medallion architecture with Delta Lake.
• Understanding of dimensional modelling (Kimball), including SCD Type 1/2.
• Exposure to operational concepts such as monitoring, retries, idempotency and backfills.

Mindset

• Good energy and enthusiasm
• Keen to grow within a modern Azure Data Platform environment.
• Comfortable with Git, CI/CD and modern engineering workflows.
• Able to communicate technical concepts clearly to non-technical stakeholders.
• Quality-driven, collaborative and proactive.

Why Join?

• Opportunity to shape and build a modern enterprise Lakehouse platform.
• Hands-on work with Azure, Databricks and leading-edge engineering practices.
• Real progression opportunities within a growing data function.
• Direct impact across multiple business domains.

LOCATION: Glasgow Head Office Hybrid, 4 office : 1 WFH

RESPONSIBLE FOR/DIRECT REPORTS: n/a

JOB PURPOSE:

This role will be responsible for developing and maintaining end-to-end software solutions across both front-end and back-end systems. Ensure that applications are robust, scalable, and user-focused by combining strong technical expertise with an understanding of business requirements. Contribute to architectural decisions and ensure all software adheres to architectural standards and best practices. Provide guidance and coaching to the team as required.

PRINCIPAL TASKS AND RESPONSIBILITIES

Software Development

Develop high quality technical solutions which meet specified business objectives, whilst adhering to overarching business and technical requirements and constraints.

Ensure all software that is created is in line with the technical roadmap and development guidelines.

Optimise applications for maximum performance, scalability, and security

Work with other members of the team to ensure business requirements are appropriately converted to functional and technical specifications

Troubleshoot, debug, and resolve technical issues across the full technology stack.

Conduct unit testing, participate in code reviews, and support quality assurance processes.

Participate in squad ceremonies including Story Refinement, Sprint Planning and Retrospectives.

As a Senior

Contribute the design, architecture, and planning of complex systems and applications.

Mentor, coach, and support junior and mid-level developers to build skills and improve code quality.

Identify and address technical debt, proposing long-term solutions for maintainability and performance.

Act as an escalation point for complex technical issues across the full stack.

Own and drive major features or projects from concept through delivery.

Contribute to security reviews and ensure robust security practices across applications.

Basic Behaviours

Ensure that continuous improvement is baked into everything we do.

Support the development of a strong culture focused on transparency, collaboration, and high performance

Make time to support other members of the squad and answer questions when they need help.

Take responsibility of your personal objectives and those of the squad.

Take ownership of deadlines and releases for yourself and the team.

Any quality issues of the software the squad owns should be looked on as a temporary and unacceptable state of affairs. Every opportunity should be taken to rectify problems, in conjunction with the completion of squad and individual objectives.

SKILLS / EXPERIENCE

Professional / Academic / Qualifications

• 5+ years experience in a development role

• Degree level qualification

Specific Knowledge

• Microsoft .NET development stack (C#, ASP.NET, MVC, SQL Server)

• Azure, .NET Core, Entity Framework

• Angular, Typescript

• GIT, Azure DevOps

• RESTful Web APIs

• CI/CD Pipelines

• Experience of both Waterfall and Agile tools/frameworks

• Knowledge of secure coding practices and application security fundamentals

• Experience with Azure Cloud Services

• Knowledge of the Facilities Management domain

• Background in domain-driven design, event-driven systems, or clean architecture.

Demonstrated Behaviours

• Proactive, self-driven, and able to work independently or as part of a team
• Focused on outcomes rather than outputs
• Excellent verbal and written communication skills
• Pragmatic and flexible attitude
• Excellent interpersonal skills
• Attention to detail
• Mentoring/coaching skills