Description

As part of the Transport UK Group, West Midlands Trains delivers around 1,300 train journeys a day, for more than 60 million passengers a year, across our two brands - West Midlands Railway and London Northwestern Railway. We are committed to delivering a safe and reliable train service, by investing in our fleet of trains, stations and employees.As part of this investment, we are seeking a

Data Engineer based in Birmingham on a Full-Time permanent basis . This is a key role in the Business Intelligence team to extract data from existing systems, load it into a central data lake and transform it into useful business intelligence information/dashboards. You will ensure good data quality by cleaning and collating required data streams into appropriate formats for supply to West Midlands Train’s central system and DfT’s Rail Data Marketplace.

Key Responsibilities

Develop and maintain WMT''s database architecture and data processing systems with the support of WMT’s IT department

Extract data from multiple sources, ensuring its accuracy and integrity when stored

Load Data into WMT''s central data warehouse/data lake

Ensure data quality processes are embedded into workflows and within data sources

Define and develop APIs/automation to extract data from core systems into WMT''s central data warehouse / data lake and potentially to external stakeholders

Work closely with WMT department to migrate datasets into WMT’s central data architecture

Structure data in the data warehouse to ensure scalable approach as more data is migrated across

Define metadata necessary for synthesis of various datasets across WMT

Transform data into useable BI reporting outputs replicating or enhancing current reporting and determine reporting frequency with end users

Develop and deploy flexible data access tools/interactive dashboards, led by end users and the wider BI team

Work closely as a key member of WMT’s BI team, utilising the experience and knowledge of other team members to jointly deliver successful data outcomes and BI for WMT

Data pipeline maintenance/testing. Test the reliability and performance of each part of a system throughout development and roll out

Monitor the stability of the data warehouse, undertake regular maintenance to ensure the system runs efficiently and effectively

Interpret data for specific questions from WMT’s departments

Skills, Knowledge and Expertise

Able to build strong working relationships within the company, particularly at peer group level, interpret end user requests into the development of useful tools that add value and increase efficiency.

Experience of the rail industry would be preferable, having an understanding of the way that the rail industry is structured, operates and the type of data produced will greatly help in the use of that data to create value adding outputs

Ability to respond to a wide range of complex and conflicting interests and to communicate effectively with key stakeholders in their resolution.

Self-starter with the ability to lead mini development processes

Conscientious approach to work, to undertake sufficient testing, checking and to provide assurance that data quality is good and reporting outputs are accurate and reflective.

Job Benefits

Salary - Up to £50,000 per annum + benefits

Hybrid working - 2-3 days in Birmingham office

Defined Benefit pension – one of the best in the UK

Free travel on all our trains and those of other train companies within our parent group company - for you, your partner and any dependent children

75% off all other train company travel tickets

Retail discounts

Career development opportunities

About London Northwestern and West Midlands RailwaysWe are proud to operate two new railway brands for and to the Midlands, the North West and London.

In the Midlands the West Midlands Railway brand is a local railway placing Birmingham at the centre of its network. We run the majority of the local services, as well as direct trains to many of the surrounding towns and cities, including Redditch, Stratford-upon-Avon, Worcester, Hereford, Shrewsbury, Telford, and Northampton.

Our London Northwestern Railway brand serves the London to Liverpool route on the west coast, stopping at Birmingham, Milton Keynes and Northampton, with the West Midlands at its heart.

Both services are operated by West Midlands Trains Ltd, part of Transport UK.

Each business brings a wealth of knowledge and expertise to the franchise and it''s our aim to give you the rail experience you deserve at the price you want to pay.

#J-18808-Ljbffr