Senior Data Engineer and Technical Lead

The Methodist Church in Britain; Parkgate; Hybrid; GBP 55,000 - 75,000; Full time

Job summary

The Clatterbridge Cancer Centre NHS Foundation Trust is seeking an experienced BI/Data Warehouse Lead for a 24-month fixed-term post. The role blends hands-on data engineering with managing a small BI, RPA and SharePoint team across two sites in a flexible, blended pattern.

Sponsorship for Skilled Worker visas is unlikely. You will oversee ETL optimisation, data warehouse operations and the delivery of BI reporting solutions, collaborating with clinicians, analysts and external suppliers to

Qualifications

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

Responsibilities

• 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, BI and dashboard reporting solutions.
• Manage a small team of BI, RPA and SharePoint developers and help prioritise competing workstreams.
• Provide technical leadership from requirements gathering to testing, implementation and support.
• Support the BI Manager in delivering a self-service approach to information.
• Work with analysts, clinicians, managers 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 BI platform.

Skills

SQL Server

T-SQL

SSIS

SSRS

SharePoint

RPA

BI Dashboard Design

Education

Degree-level or postgraduate diploma

CPD in informatics

Tools

SharePoint

Power Platform

Blue Prism

Power Automate

Job description

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