Business Intelligence Developer
The closing date is 27 January 2026
As a Business Intelligence Developer, 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 organisation.
The Business Intelligence Developer 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 team 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
Key responsibilities
- BI Product Development & Platform Administration
- Strategy, Leadership & SME Role
- Stakeholder Engagement & Collaboration
- Data Transformation & Analysis
- Quality Assurance & Compliance
- Process Improvement & Innovation
- Documentation, Training & Support
- Project & Request Management
- Research Analytics Leadership
About us
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
Job responsibilities
Roles and responsibilities
In addition to the duties listed in the Key Responsibilities section, the post holder would be expected to do the following; Information Systems
Job description
Job responsibilities
Roles and responsibilities
In addition to the duties listed in the Key Responsibilities section, the post holder would be expected to do the following; Information Systems
To be responsible for building and supporting with Qlik applications and reporting as part of the agreed work programme.
To bring together through various reporting methodologies, the individual strands of External and Internal reporting for the two departments through making appropriate datasets available.
To be responsible for dataset creation for complex clinical outcome benchmark models commissioned by the departments.
To follow the Information Team strategy of using Azure SQL/DataBricks/Palantir Foundry to return datasets from the Trusts Data Warehouse and support in the use of Qlik applications/Foundry to disseminate the results to the Trust
To support where appropriate to developing integration of EHR and Research EDC (eCRF) systems to reduce duplicate data entry and increase efficiency and data quality.
Communication and Relationships
To receive, analyse and communicate a wide range of highly complex technical information to colleagues, including junior analysts and peers, where cooperation and comprehension is fundamentally necessary.
To liaise with clinical and management leads to ensure there is regular provision of relevant information to support key work streams such as:
- Research strategy meetings
- Service Line Reporting (SLR)
- Research Partner deliverables
To communicate to Strategy leads, Financial and Operational managers, regarding the use and interpretation of the production process and content of Information Management data and reports using laymen terms; agreeing assumptions and showing how these can offer advantages in delivering against Trusts strategic objectives.
To promote the corporate Patient Administration System (Cerner) as the principal source for data entry and analysis, working to improve data quality in conjunction with the related teams for data quality.
To work with Head of Information to understand how to make best use of the analyst resource, coordinating pan organisation information processes and taking lead for delivery of strategic analysis and monitoring of compliance against Trust Performance Assurance Framework.
To work in partnership with Lead Strategist, Business Analysts, Head of Financial Planning, Performance Managers and General Managers to ensure that clinical and research activity is being processed robustly so that Trust income is secured.
To liaise with relevant staff within the Trust such as the Clinical Coding Team, Divisional Operational and Information/Data Warehouse teams to ensure that clinical and research data is reliably reportable in an accurate, complete, consistent and timely manner.
Work closely with, senior members of the Information and Data Engineering teams
Collaborate and work with sector‑wide operational system leads
To develop and analyse datasets on Equality, Diversity and Inclusion in Research to drive an increase of research participation from under‑served communities.
Knowledge, Training and Experience
To use a highly developed specialist knowledge of NHS Data and Acute Informatics effectively within the Trust to stimulate an advancement of a research and business intelligence culture.
To have a highly developed knowledge of systems used within the Information Team (e.g. Qlik, SQL) and be adaptable and able to learn about Research focussed information systems, and to be able to extract data from them, transform, cleanse and analyse it.
To provide guidance on national clinical benchmarking sources and data items catalogued in the NHS data dictionary.
To be responsible for ensuring reporting tools and strategies continue to be relevant to performance for the Research department, evaluating and supporting contemporary information needs and supporting communication plans.
To apply knowledge from previous modernisation projects to identify risks and benefits to system changes.
Planning and Organisational Skills
To plan and organise strategic Information Management projects, working with relational databases, creating datasets and using/supporting use of Qlik and Foundry as the Trusts main business intelligence tool.
To reflect the wide range and complexity of healthcare provision, in community and acute care settings. This may include working collaboratively with different departments and organisations. The ability to understand complex requirements, data models and data flows will be essential, as will the ability to translate concepts into understandable and useable information for strategic, operational and clinical management.
To respond to and prioritise ad‑hoc requests for information Team from internal and external requestors that we work with, ensuring that information supplied is relevant, insightful, complete and in an accurate, and timely fashion.
To support the Head of Information in ensuring that procedures carried out are correctly documented and maintained in a transparent manner for all routine datasets, reports, dashboards and investigating and performing a Root Cause Analysis into data processing issues that arise.
Management Responsibilities
Support the delivery of strategic projects within the sector which need to provide in‑depth intelligence to inform decision making, business planning, and aid the monitoring of patient outcomes.
Foster a culture of customer service by working closely with the decision‑support function, responding effectively to the needs of the organisation and pro‑actively seeking to add value to the organisation through information analyses, dataset creation, tools and methods.
Foster close working relations with departments such as ICT, Digital, Research and others in developing and maintaining quality information and information and data reporting systems.
Review and contribute to the development of Information Management and Data Quality policies and procedures to meet the needs of the Trust.
Support, mentor and line manage information analyst(s)
Other Responsibilities
To support the development and appropriate usage of Trust wide clinical and data/BI information systems, including integration and full reconciliation with corporate systems.
Line management, mentoring and support to more junior members of the team
To attend regular relevant meetings as and when required
Maintains and protects patient confidentiality at all times and in accordance with the Data Protection Act and relevant Trust policies.
Provides training and guidance to other members of the team with regards to systems, standards and reporting.
To carry out any other duties as requested by the General Manager for Digital or Head of Information.
Person Specification
Trust Values
- Putting patients first
- Responsive to patients and staff
- Open and honest
- Unfailingly kind
- Determined to develop
Education and Qualifications
- Educated to Master levels (or equivalent experience) in computer science, data engineering or related subject or equivalent experience
- Business Intelligence, Data Management or related qualifications
Experience
- Significant experience in BI development, with expertise in QlikSense and other BI tools
- Experience of leading and delivering complex change and strategy development programmes in a politically sensitive and complex environment
- Ability to present complex technical ideas/solutions to non-technical audiences
- Ability to work with internal and external stakeholders, fostering and maintaining good relationships throughout, including managing expectations and deliverables.
- Experience in working with databases namely experience in using SQL, including data transformation experience
- Data engineering and reporting experience
- Experiencing of creating robust data and reporting internal policies and documentation on, including following and creating best practice methods
- Documenting key information relating to processes on data work e.g. ETL pipelines, transformations, data models, integrations, workflows and similar.
- Experience of working with BI tools such as Qlik
- Analysing information in a health environment
- Proven experience in analysing and interpreting complex datasets and dashboards
- Experience of warehouse and relational database design and object management
- Qlik platform administration and maintenance (including Qlik Cloud)
Skills and Knowledge
- Knowledge of information management gained through senior management experience
- Understanding of role of NHS data standards, data definitions, information governance
- Knowledge of best practice data modelling and data reporting techniques, including creating documenting this and related activities
- Ability to communicate clearly and concisely, both written and oral, at all levels, both within the trust and with external stakeholders
- Proficiency in querying and reporting against relational databases, Structured Query Language (SQL) or similar
- Expertise in QlikSense and other BI/data visualization tools.
- Understanding of data governance, data quality, and audit practices.
- Extensive knowledge of staff management gained through senior management experience and/or qualification
- Strong Project Management & MS Excel Skills
- Highly data rational with the ability to use quantitative and qualitative information to stimulate improvement and provide assurance on data integrity
- Ability to use data science techniques and statistics, including use of Python/R
- Ability to manipulate data in data lakes using PySpark/Experience with cloud-based data architectures and scalable data solutions
Personal Qualities
- Excellent stakeholder management and interpersonal skills
- Intellectually flexible and creative, challenging current ways of working to produce innovative outputs
- Highly developed negotiation and influencing skills
- Ability to manage and self‑organise while dealing with multiple competing priorities
- Initiative and proactive approach to system/process improvement
- Commitment to continuous learning and keeping up with industry trends.
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Chelsea and Westminster Hospital NHS Foundation Trust
Address
Harbour Yard (Imperial Wharf) or West Middlesex Hospital plus flexible home working (up to 3 days per week)
:quality(80))
:quality(80))
:quality(80))