Business Intelligence Developer

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;

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.

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:

o Research strategy meetings

o Service Line Reporting (SLR)

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

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.

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.

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)

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

Essential

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

Education and Qualifications

Essential

• Educated to Master levels (or equivalent experience) in computer science, data engineering or related subject or equivalent experience

Desirable

• Business Intelligence, Data Management or related qualifications

Experience

Essential

• 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

Desirable

• 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

Essential

• 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

Desirable

• 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

Essential

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

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Employer details

Employer name

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)

london

SW10 0XD

Employer's website

https://www.chelwest.nhs.uk/ (Opens in a new tab)