Azure Data Engineer

£55,000 (+ bonus opportunity, up to 10%)Full Time - Permanent Hybrid Working - 1 day in office every 1 - 2 weeks (Derby)The Client The client has been at the heart of the UK rail network for three decades and owns around a quarter of the national passenger rail fleet.They mobilise private finance to drive rail growth through tailored leasing solutions, industry leading innovations and essential network projects that deliver a safe, efficient and sustainable railway.Their mission is to provide high-quality, digitally enabled rolling stock solutions that help deliver a safe, efficient and sustainable railway. We take an industry-leading approach, driven by innovative thinking and future planning.About the teamThe successful candidate will be joining 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 OfficerResponsibilitiesThis role will support the delivery and development of the client's Digital Portfolio. Taking advantage of the client's unified data platform and working with the team 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* Monitoring and recovery of Azure Data Factory and Databricks jobs * Proactive monitoring of data quality* Becoming a subject matter expert on understanding client's 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* Skills, Knowledge and ExpertiseRole 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 Key Skills* Interpersonal skills * Report writing, presentation and record keeping skills* Excellent communication and stakeholder management * 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 benefitsThis 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 our benefits are listed below:* Excellent pension scheme* Financial wellbeing support* Flexible working* Enhanced family friendly policies* Adoption & Shared Parental Leave benefits* Enhanced Armed Forces policies* Ongoing support with professional and personal development* Long service awards* Life assurance* Healthcare cash plan* 25 days' annual leave + Bank Holidays + option to buy and sell up to 5 days' additional leave* Additional days annual leave for long service* Season ticket loan* Cycle to work scheme