Skip to main content

This site is independent of the NHS and the Department of Health.

Please wait, loading

Job summary

Main area
Data Engineering
Grade
NHS AfC: Band 8a
Contract
Permanent
Hours
  • Full time
  • Flexible working
37.5 hours per week
Job ref
289-CR-1703-B
Employer
Chelsea and Westminster Hospital NHS Foundation Trust
Employer type
NHS
Site
Harbour Yard (Imperial Wharf) or West Middlesex Hospital
Town
London
Salary
£53,755 - £60,504 per annum plus HCAS
Salary period
Yearly
Closing
20/05/2025 23:59
Interview date
29/05/2025

Employer heading

Chelsea and Westminster Hospital NHS Foundation Trust logo

Data Engineer & Business Intelligence Platform Administrator

NHS AfC: Band 8a

Job overview

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.

Main duties of the job

·         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.

Working for our organisation

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

Detailed job description and main responsibilities

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.

Person specification

Trust Values

Essential criteria
  • Putting patients first
  • Responsive to patients and staff
  • Open and honest
  • Unfailingly kind
  • Determined to develop

Education and Qualifications

Essential criteria
  • Bachelor's degree or equivalent experience in Computer Science, Data Engineering, Information Technology, or a related field
Desirable criteria
  • Certifications in data engineering or related areas (e.g., Microsoft Certified: Azure Data Engineer, Google Cloud Professional Data Engineer)
  • Advanced degrees (Master’s or Ph.D.) in Data Science, Computer Science, or related field

Experience

Essential criteria
  • 3+ years of experience in data engineering, data architecture, or BI platform administration, with a strong understanding of data pipeline design and management
  • Hands-on experience in developing and maintaining ETL processes, integrating data from diverse sources into BI platforms, and managing data workflows
  • Familiarity with UK healthcare data governance practices and regulatory compliance standards (e.g., GDPR)
  • 3+ years of experience developing and administering Qlik platforms for data visualization, reporting
  • 3+ years of experience with database management systems (SQL Server, Oracle, PostgreSQL, etc.)
Desirable criteria
  • Proven experience with cloud-based data architectures (AWS, Azure, or GCP) and building scalable data solutions

Skills and Knowledge

Essential criteria
  • Proficient in SQL programming and data processing
  • Expertise in Qlik business intelligence and data visualization tools
  • Understanding of data governance frameworks, data quality practices, and the implementation of data lineage and audit logs
Desirable criteria
  • Knowledge of Git and CI/CD best practices for streamlined deployment and version management.
  • Expertise in Python for data manipulation, ETL development, and building data pipelines
  • Expertise in ETL design, building data pipelines, and optimizing data flow using Azure Data Factory

Personal Qualities

Essential criteria
  • Takes initiative to identify system inefficiencies and proactively works on improving processes
  • Strong problem-solving skills with a data-driven approach to resolving issues
  • Works effectively in cross-functional teams, able to communicate complex technical concepts to non-technical stakeholders, and serves as a bridge between technical and business teams
  • Keeps up with industry trends and is eager to learn and implement new technologies

Employer certification / accreditation badges

Trust IDWe are a Living Wage EmployerCapital Nurse, LondonHealthy Workplace - Commitment 2018Veteran AwareApprenticeships logoTimewise helps businesses to attract and develop the best talent through flexible working.No smoking policyCare quality commission - GoodDisability confident employerStep into healthArmed Forces Covenant Bronze AwardArmed Forces Covenant

Documents to download

Apply online now

Further details / informal visits contact

Name
David Fokum
Job title
Data Warehouse Manager
Email address
[email protected]
Telephone number
02083215534
Apply online nowAlert me to similar vacancies