Senior Data Engineer and Technical Lead

This role sits in the Business Intelligence team at The Clatterbridge Cancer Centre NHS Foundation Trust and is a 24-month fixed-term post, first offered as an internal promotion. The postholder leads ETL development and the day-to-day running of the Trust's data warehouse. The post combines hands-on data engineering with managing a small team of Business Intelligence, Robotic Process Automation and SharePoint developers, and the team works in a blended pattern across two sites. Skilled Worker visa sponsorship is unlikely to be available.

What the job involves

• Lead the development, implementation and optimisation of ETL processes and the integration of data from multiple information systems
• Oversee the day-to-day operation and ongoing enhancement of the Trust's data warehouse
• Lead the development and delivery of data warehouse, Business Intelligence and dashboard reporting solutions
• Manage a small team of Business Intelligence, RPA and SharePoint developers and help prioritise competing workstreams
• Provide technical leadership from requirements gathering and solution design through to testing, implementation and support
• Support the Business Intelligence Manager in delivering a self-service approach to information
• Work with analysts, clinicians, managers, operational teams and external suppliers on reporting, automation and data solutions
• Promote best practice in system development, data quality, testing, documentation and automation
• Reduce manual processes and maximise the value of the Business Intelligence platform and associated systems

What’s required

Qualifications

• Degree-level or postgraduate diploma, or equivalent experience
• Evidence of continued professional development in an informatics specialism

Experience

• Extracting and analysing complex and sensitive data to support monitoring
• Track record of database and dashboard or report development
• Implementing, managing and administering data warehousing solutions
• Setting up and maintaining current and legacy extracts into a data warehouse

Skills & knowledge

• Advanced SQL Server and T-SQL, including SSIS and SSRS
• Experience of the SharePoint platform
• Understanding of Robotic Process Automation
• Understanding of Business Intelligence dashboard and reporting design
• Good understanding of GDPR, FOI, information governance and Caldicott guidance
• Highly developed Microsoft Office and Microsoft operating system skills

Nice to have

• Membership of a Fed-IP recognised professional body (BCS, SOCITM, IHRIM, CILIP or AphA)
• Informatics-related courses or qualifications
• Experience of SharePoint development
• Experience of RPA development using Blue Prism or Microsoft Power Automate
• Experience of the Microsoft Power Platform
• Significant experience of working in the NHS or a health setting
• Thorough understanding of NHS performance targets, NHS data sets and information procedures
• Experience of managing or leading a team in a technical environment