Job Specifications
As a Data Engineer & Business Intelligence Platform Administrator, you will play a pivotal role in transforming data into actionable insights, driving strategic decisions, and enhancing the overall efficiency of our healthcare services. Your expertise will ensure the stability, performance, and security of our BI platforms and data marts, enabling data-driven decision-making across the organization.
The Data Engineer & BI Platform Administrator collaborates with fellow data engineers, analysts, and business users to create robust, scalable data solutions that empower data-driven decision-making and support business intelligence function.
You will not only provide technical expertise but also act as a bridge between data engineering and business functions, troubleshooting issues, and enhancing the overall analytics environment. Additionally, this role plays a crucial part in BI strategy development, ensuring that reporting tools and datasets are scalable, reliable, and align with the Trust’s broader data strategy.
This position demands a proactive mindset, with continuous improvements to system architecture and business processes as a key focus.
Design, implement, and maintain BI platforms, data lakes, and data marts.
Optimise ETL processes to ensuring efficient data ingestion, transformation, and timely availability for analytics.
Design and build scalable data pipelines that integrate data from multiple sources into BI platforms and data marts.
Develop and maintain data models (star and snowflake schemas) to ensure efficient querying and reporting, while using data orchestration tools to automate workflows, monitor jobs, and ensure smooth operation of data pipelines.
Collaborate with data scientists, analysts, and business users to gather requirements and implement data-driven solutions.
Support business intelligence initiatives by ensuring data accuracy and accessibility, enabling data analysts and business users to make informed decisions.
Identify areas of improvement in the BI platform architecture, data pipelines, and business processes to enhance overall performance, reliability, and value.
Research and experiment with new BI and data engineering technologies, recommending tools and solutions that enhance efficiency and data insights.
Chelsea and Westminster Hospital NHS Foundation Trust is one of England's top-performing and safest trusts. We operate two main acute hospital sites—Chelsea and Westminster Hospital and West Middlesex University Hospital—along with award-winning clinics across North West London.
Our nearly 7,500 staff care for a diverse population of 1.5 million, providing full clinical services, including maternity, A&E, and children’s services, plus specialist HIV and sexual health clinics. The Care Quality Commission rates us 'Good' in safety, effectiveness, care, and responsiveness, and 'Outstanding' in leadership and resource use.
We continually invest in our facilities, including a £30m expansion of critical care at Chelsea and Westminster and an £80m Ambulatory Diagnostic Centre at West Middlesex.
We are committed to equal opportunities and believe that diversity drives innovation and excellence. As part of our dedication to equity, we actively welcome applications from individuals from the global majority, veterans and underrepresented communities. We value the unique perspectives and experiences that diverse teams bring and are committed to creating an environment where all voices are heard, respected, and empowered to succeed."
If you haven’t heard from us within three weeks of the closing date, your application was likely unsuccessful. Employment is subject to a six-month probationary period.
Some roles may require weekend shifts at multiple sites
For further details / informal visits contact: Name: David Fokum Job title: Data Warehouse Manager Email address: david.fokum@nhs.net Telephone number: 02083215534