Data Engineer

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.

What does the job involve?

Extract data from multiple sources, ensuring its accuracy and integrity when stored
Ensure data quality processes are embedded into workflows and within data sources
Structure data in the data warehouse to ensure scalable approach as more data is migrated across
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
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.

What skills and experience do I need to do the job?

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.

What are the salary and 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.

Applications will be considered from colleagues with 6 months experience in current role and a full check of absence and disciplinary records.

We reserve the right to withdraw this advert at any time due to high volumes of applications (please submit your application as early as possible to avoid disappointment).

As an inclusive employer, we welcome applications from all backgrounds and ensure no-one receives less favourable treatment on the grounds of age, disability, gender, race/ethnicity, religion, belief and sexual orientation.