Data Engineer & Business Intelligence Platform Administrator

Chelsea and Westminster Hospital NHS Foundation Trust; London; On-site; GBP 40,000 - 70,000; Full time

Job summary

An established industry player is seeking a Qlik Platform Administrator to enhance their BI capabilities. In this role, you will be responsible for installing, configuring, and maintaining Qlik BI platforms, ensuring data security and compliance with healthcare standards. You will work closely with IT support and stakeholders to optimize system performance and implement data governance best practices. This position offers an exciting opportunity to contribute to data-driven decision-making in a dynamic healthcare environment, where your expertise will directly impact patient care and operational efficiency.

Qualifications

• 3+ years in data engineering and BI platform administration.
• Experience with ETL processes and data workflows.
• Familiarity with UK healthcare data governance standards.

Responsibilities

• Install and maintain Qlik BI platforms, ensuring data security.
• Design scalable data pipelines and manage ETL processes.
• Collaborate with stakeholders to meet reporting needs.

Skills

SQL

Data Processing

Qlik BI Tools

Data Governance

Problem-Solving

Education

Bachelor's degree in Computer Science

Certifications in data engineering

Master's or Ph.D. in related fields

Tools

Qlikview

Qliksense

Qlik NPrinting

SQL Server

Oracle

PostgreSQL

Job description

Detailed job description and main responsibilities

Qlik Platform Administrator

1. Install, configure, and maintain Qlik BI platforms (Qlikview, Qliksense, Qlik NPrinting, and QlikCloud).
2. Manage user roles, permissions, and authentication to ensure data security and compliance with internal policies. Work closely with cybersecurity teams to implement best practices.
3. 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.
4. 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.
5. Stay up to date with BI technology trends and recommend improvements that enhance system performance and user experience.
6. Monitor and optimise system performance, ensuring high availability of BI tools and data platforms.
7. Implement data security best practices, including encryption, access control, and auditing mechanisms to ensure that sensitive data is protected.

Healthcare & NHS Standards

1. 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.
2. Ensure adherence to data governance policies and regulatory requirements related to BI platform usage. Establish standard operating procedures for BI processes.
3. Collaborate with data stewards and compliance teams to enforce data standards, policies, and procedures.

Data Engineering & Architecture

1. Contribute to the design of data models that improve reporting efficiency ensuring seamless data extraction, transformation, and loading (ETL) processes.
2. Design and build scalable data pipelines that integrate data from multiple sources into BI platforms and data marts.
3. 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.
4. Analyse and work with complex data often made up from many significantly inter-related sources.
5. 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.
6. Assist in the execution of data strategies that align with NHS and organisational objectives, including performance reporting and data-driven decision-making.
7. Support large-scale BI projects from inception to completion, ensuring timely delivery and stakeholder satisfaction.
8. Maintain technical documentation, best practices, and provide training to end users on BI tools and data marts. Develop user guides and conduct workshops.
9. Design, implement, and maintain BI platforms, data lakes, and data marts to ensure high performance, scalability, and reliability.
10. Optimise ETL (Extract, Transform, Load) processes to ensure timely and efficient data ingestion, transformation, and availability for analytics purposes.
11. Use data orchestration tools to automate workflows, monitor jobs, and ensure data pipelines are running smoothly.
12. Troubleshoot and resolve performance bottlenecks in data mart ETL, including optimising query performance and tuning databases.
13. Implement data governance frameworks to ensure data quality, lineage, and consistency across BI tools and data platforms.
14. Ensure that data models are aligned with business requirements and that data pipelines follow best practices in terms of governance.

General Expectations

1. Work closely with the Information Team and key stakeholders to deliver on data engineering requests.
2. Observe assignment priority definitions per Data Warehouse team prioritisation meetings.
3. Observe Information Governance guidance while handling sensitive information.
4. Take responsibility for own actions and work under minimal guidance from the line manager. The post holder should be able to determine and develop work independently, following initial guidance.
5. Seek out new ways of working and ideas for system improvements whilst adhering to ICT Policies and Procedures.
6. Innovate by introducing new ideas, tools, and techniques to increase team effectiveness.

Person Specification

Trust Values

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

Education and Qualifications

• Essential: Bachelor's degree or equivalent in Computer Science, Data Engineering, IT, or related field.
• Desirable: Certifications in data engineering (e.g., Azure Data Engineer) or advanced degrees (Master's or Ph.D.) in related fields.

Experience

• Essential: 3+ years in data engineering, architecture, or BI platform administration, with experience in ETL, data workflows, and Qlik platforms.
• Familiarity with UK healthcare data governance and compliance standards (e.g., GDPR).
• Experience with database management systems (SQL Server, Oracle, PostgreSQL, etc.).

Skills and Knowledge

• Proficient in SQL and data processing.
• Expertise in Qlik BI tools.
• Understanding of data governance, quality practices, and data lineage.

Personal Qualities

• Proactive in identifying system improvements.
• Strong problem-solving skills and effective communication.
• Ability to work in cross-functional teams and stay updated with industry trends.