0203 011 1008

Data Engineering

Helping you future-proof your data

We help build resilient data pipelines in the cloud, enabling you to optimise cost, handle large volumes of data, and gain a competitive advantage through enabling advanced analytics. We combine data sources to unlock new insights, and automate the steps to reduce maintenance burden on your team.

A new generation of change programmes

We use cutting-edge cloud-based ETL tools to build resilient, automated pipelines which handle large real-time datasets, scale when needed and provide clean ready-to-use data for your data teams.

Do you need support with taking real-time rail data feeds and combining them in the cloud? This is an area where many large management consulting organisations lack the credibility of specialist technology companies like JNCTION.

Our experience

Our data engineers are experts in rail data and live feed APIs and are highly experienced at combining them for rail-specific problems.

Our team

Working with you from start to finish

Identifying Priorities and Challenges

Working alongside your teams, we will identify your priority areas and biggest business challenges. We will scope what you want to work on and how we can help.

Tool-Agnostic Approach

Unlike many organisations, we are tool-agnostic and work with the best tools for your specific challenge. We like to demonstrate the application of our analysis through proof of concept, before scaling to the wider business or other geographies. We can help you:

  • Give your customers improved experience through better understanding of their trends
  • Reduce delays by building a holistic picture of your asset performance
  • Improve your performance metrics through optimised timetables
  • Monetise your data by using it to provide analytics insights to other business (e.g. retail, food outlets

Sustained Implementation and Support

By working with you throughout, identifying clear technical owners for our solutions within your business and supporting the roll-out with excellent communications to win heart and minds, our team make change stick and help you realise the benefits long-term.

Work with us

Example applications for our rail data and expertise

Developing an enhanced database of train movements

Read more – JNCTION Archive

Our Approach

  • Build a pipeline of enhanced train movements by combining multiple rail data sources
  • Load to a database which can be easily filtered by operator, geography or date

Benefits

  • Improved punctuality performance through analysing sub-threshold delays, where seconds are consistently lost at certain times and locations
  • We do the hard data engineering bit for you
  • £0 data access cost if procured via analytics consulting project

 

Developing an enhanced real-time feed of train movements

Read more – JNCTION LiveData

Our Approach

  • Build a real-time feed of enhanced train movements by combining multiple rail data sources
  • Integrate with software via APIs to load information to ‘live trains’ screens

Benefits

  • Improved responsiveness to live services, especially during disruption where quality information is vital
  • We do the hard data engineering bit for you (you subscribe to 1 feed, rather than 6)
  • £0 data access cost if procured via JNCTION Control

Case Study

Better delay predictions using models trained on historic incidents and live train running

Case Study

Our Approach

  • Build an historic database and a real-time feed of enhanced train movements by combining multiple rail data sources
  • Train machine learning models to predict incident durations and incurred delay based on incident type, location, timing etc
  • Combine with live train running to generate predictions in real-time for Control room users.
  • Record input from Control users, to evolve the model and learn from their experience (safeguard their legacy for years to come)

Benefits

  • Reduced decision-making time during disruption, especially for junior colleagues who can benefit from the ‘experience’ of the model, and input from their experienced colleagues
  • AI can spot patterns that even the most experienced Control staff cannot, and can learn from similar incidents in other geographies.
  • £ saved from faster service recovery

Blog

Developing brand new data to analyse your specific performance challenges

Blog

Our Approach

  • Berth-step level train movements are the fundamental building blocks of rail performance. We group, filter and combine these movements in JNCTION Archive to create an aggregate picture to answer any desired performance questions.
  • We have done this ourselves to create an industry-first Service Level Metric

Benefits

  • Comprehensive and accurate historic data tailored to the specific business question you need to understand
  • We do the hard data engineering bit for you with development included via analytics consulting project
  • £0 data access cost if procured via analytics consulting project

Case Study