Data Engineer
About our client
Our client has a stated mission to provide high-quality, digitally enabled rolling stock solutions that help deliver a safe, efficient and sustainable railway
In the last 8 years they have invested £3bn, including the commissioning of over 2,500 new passenger and freight vehicles, and with a plan to invest over £1bn into UK rail in the coming years to deliver high quality new and refurbished vehicles for passengers and freight customers.
However, financing new trains is not the endgame for them. Their asset stewardship role includes management of assets to ensure performance, safety and long-term suitability over their full economic life
About the team
They are now seeking a highly experienced Data Engineer to join the Fleet function, a small multi-disciplinary team that supports corporate and project governance, risk management and audits of Train Operating Companies, suppliers and internal processes. The team is part of the Operations Directorate reporting to the Chief Operating Officer
Role Purpose
This role will support the delivery and development of the Digital Portfolio. Taking advantage of the unified data platform, you would have overall responsibility for managing and maintaining existing data pipelines, monitoring of workloads, root cause analysis, data quality monitoring and escalation of technical issues to Product Owner
Responsibilities
- Monitoring and recovery of Azure Data Factory and Databricks jobs
- Proactive monitoring of data quality
- Becoming a subject matter expert on understanding data sources, ingestion methods and data quality levels
- Assisting in developing and adhering to associated data governance policies and internal processes
- Working closely with the wider team to understand the business needs and improve data quality
- Develop and maintain digital services data quality KPIs
- Maintaining and monitoring of user facing dashboards and other internal Digital products
- Updating and patching of existing Digital software products
- Documenting root cause analysis outputs
Technical Requirements
- Microsoft Azure Experience (essential)
- Knowledge of Azure data components such as Azure Data Factory, Azure SQL DB, Azure Data Lake, etc
- Strong Python and SQL skills for manipulating data
- Apache Spark and/or Databricks experience
- Experience using BI visualisation tools, such as Power BI
- Experience in managing end-to-end analytics pipelines (batch and streaming) suitable for data science workload consumption
- Experience in root-cause analysis and post-incident reporting in a production environment
Knowledge and Qualifications
- A relevant degree in Computer Science, Engineering, and/or relevant certificates including, Azure Data Engineer Associate are desirable
- Knowledge of railway industry rolling stock, organisation and players
- Data ingestion methods for real-time and batch ingestion
- PySpark
- Debugging Apache Spark workloads
- Experience using BI visualisation tools, such as Power BI
A great place to work
We are seeking the very best talent to join the team, and offer an excellent salary, along with bonus and benefits
This is a fantastic opportunity to join a great organisation with excellent people and a road map for the future to grow and develop the business.
Some of the benefits are listed below:
- Excellent pension scheme, life assurance and healthcare cash plan
- Financial wellbeing support with flexible working and enhanced family friendly policies, including Adoption and Shared Parental Leave benefits
- Enhanced Armed Forces policies
- Ongoing support with professional and personal development
- Long service and Star awards
- 25 days’ annual leave + Bank Holidays with the option to buy and sell up to 5 days’ additional leave, with additional leave for long service
- Season ticket loan, cycle to work scheme and free parking
To apply please send your CV and confirm your salary expectation and notice period please to
