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 & 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 & West Midlands Railways
We 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