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

Qlik Platform Administrator

Install, configure, and maintain Qlik BI platforms (Qlikview, Qliksense, Qlik NPrinting, and QlikCloud.
Manage user roles, permissions, and authentication to ensure data security and compliance with internal policies. Work closely with cybersecurity teams to implement best practices.
Diagnose and resolve technical issues related to the BI environment, working closely with IT support teams as needed. Provide ongoing technical support and guidance to BI users.
Apply updates, patches, and upgrades to keep BI platforms up to date with the latest features and security fixes. Maintain version control and ensure backward compatibility of reports.
Stay up to date with BI technology trends and recommend improvements that enhance system performance and user experience.
Monitor and optimise system performance, ensuring high availability of BI tools and data platforms.
Implement data security best practices, including encryption, access control, and auditing mechanisms to ensure that sensitive data is protected.

Healthcare & NHS Standards

Ensure compliance with NHS and healthcare-related information governance policies, contributing to high-quality patient-centred care. Work with NHS teams to align data standards with national healthcare reporting requirements.
Ensure adherence to data governance policies and regulatory requirements related to BI platform usage. Establish standard operating procedures for BI processes.
Collaborate with data stewards and compliance teams to enforce data standards, policies, and procedures.

Data Engineering & Architecture

Contribute to the design of data models that improve reporting efficiency ensuring seamless data extraction, transformation, and loading (ETL) processes.
Design and build scalable data pipelines that integrate data from multiple sources into BI platforms and data marts.
Work with business users and information team colleagues to understand reporting needs, ensuring data marts align with business goals. Act as a consultant to informatics team seeking to enhance their analytics capabilities.
Analysing and working with complex data often made up from many significantly inter-related sources
Be jointly responsible for the management of extraction, transformation and loading of data (ETL) into and out of the data warehouse, ensuring that data items are stored efficiently for optimal analytical interrogation
Assist in the execution of data strategies that align with NHS and organisational objectives, including performance reporting and data-driven decision-making.
Support large-scale BI projects from inception to completion, ensuring timely delivery and stakeholder satisfaction.
Maintain technical documentation, best practices, and provide training to end users on BI tools and data marts. Develop user guides and conduct workshops.
Design, implement, and maintain BI platforms, data lakes, and data marts to ensure high performance, scalability, and reliability.
Optimise ETL (Extract, Transform, Load) processes to ensure timely and efficient data ingestion, transformation, and availability for analytics purposes.
Use data orchestration tools to automate workflows, monitor jobs, and ensure data pipelines are running smoothly.
Troubleshoot and resolve performance bottlenecks in data mart ETL, including optimising query performance and tuning databases.
Implement data governance frameworks to ensure data quality, lineage, and consistency across BI tools and data platforms.
Ensure that data models are aligned with business requirements and that data pipelines follow best practices in terms of governance.

General Expectations

Work closely with the Information Team and key stakeholders to deliver on data engineering requests.
Observe assignment priority definitions per Data Warehouse team prioritisation meetings.
Observe Information Governance guidance while handling sensitive information.
Taking responsibility for own actions and working under minimal guidance from the post’s line manager. For the role, it is expected that the post holder will be provided with an outline of each piece of work from their line manager and guidance as to what should be delivered for that piece of work; beyond that, it is expected that the post holder will have sufficient ability and confidence to determine and find their way through the development of that piece of work.
Seeking out new ways of working and ideas for system improvements whilst adhering to ICT Policies and Procedures.
“Pushing at boundaries” regarding the introduction of new ideas, tools and techniques that increase the effectiveness of the team to support.

Chelsea And Westminster Hospital Nhs Foundation Trust

Latest Leads

Data Engineer & Business Intelligence Platform Administrator