Job summary
- Main area
- Data Engineering
- Grade
- NHS AfC: Band 8a
- Contract
- Permanent
- Hours
- Full time
- Flexible working
- 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

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
Documents to download
Further details / informal visits contact
- Name
- David Fokum
- Job title
- Data Warehouse Manager
- Email address
- [email protected]
- Telephone number
- 02083215534
List jobs with Chelsea and Westminster Hospital NHS Foundation Trust in Administrative Services or all sectors