Business Intelligence Lead (NIHR) (XN08)

We are seeking a dynamic, self-motivated and passionate person with experience overseeing and developing an organisation's Business Intelligence function.

Do you have experience managing a team to deliver BI solutions for organisations with multiple stakeholders? Delivering quality assured evidence-based insights to inform business decisions?

The role will include line management of Business Intelligence Analysts, Data Scientists, and Information Managers.

Can you provide advanced technical support and describe technical solutions to a non-technical audience? Do you have experience producing self-reporting dashboards in data visualisation environments such as Qlik or Tableau?

The role will include developing informatics delivery, ensuring user requirements are met with accurate and well-presented outputs supporting the NIHR mission to improve the health and wealth of the nation through research.

Expected Shortlisting Date
29/01/2025

Planned Interview Date
06/02/2025

Main duties of the job
Working within a small friendly team, you will support the Assistant Director overseeing a team performing a variety of business intelligence, data science, and information-related tasks. These include reviewing and maintaining the NIHR Academy data warehouse, providing information in response to parliamentary questions, providing innovative data science solutions, and developing dashboards and analytics to support the NIHR demonstrating the difference it makes.

Main duties will include providing leadership and technical expertise to the BI functions working with relational databases with MS SQL server and ETL tools such as SSIS. You will provide advanced theoretical and practical knowledge of BI Architecture including Extract, Transform and Load (ETL), SSIS (SQL Server Integration Services), Data Warehousing, data science methodologies, and Data Modelling.

You will oversee the production of reports and data visualisation in Qlik or Tableau using a variety of data sources to meet business needs. Our current data warehouse is in the cloud; therefore, experience of Microsoft Azure or Amazon AWS may also be beneficial.

About us
The National Institute for Health and Care Research (NIHR) has a mission to improve the health and wealth of the nation through research. The NIHR plays a pivotal role in attracting, training, and supporting the best researchers and complements the additional NIHR investment in world-class research facilities and a skilled research workforce.

This role is hosted by the Leeds Teaching Hospitals Trust (LTHT) and delivers the work of the NIHR, leading on policy, strategy, and delivery in respect of academic training in England and working closely with other NIHR centres and the Science Research and Evidence (SRE) Directorate at the Department of Health and Social Care (DHSC).

Leeds Teaching Hospitals is committed to our process of redeploying 'at risk' members of our existing workforce to new roles. As such, all our job adverts are subject to this policy and we reserve the right to close, delay or remove adverts while this process is completed. If you do experience a delay in the shortlisting stage of the recruitment cycle, please bear with us while this process is completed, and contact the named contact if you have any questions.

Job description
Job responsibilities
Specialist Programme Expertise and Leadership

• Support the Assistant Director for Evaluation, Business Intelligence, and Impact in leading the development and operation of the organisations Business Intelligence Information and data systems, developing and testing systems for the organisation to access data and information, ensuring alignment with overall NIHR initiatives and approach.
• Work with the Assistant Director - Evaluation, Business Intelligence, and Impact and take a key role in identifying approaches for Business Intelligence system solutions, data visualisations, and analytics while implementing national strategic developments.
• Provide specialist knowledge of BI Architecture including Extract, Transform and Load (ETL), SSIS (SQL Server Integration Services), Data Warehousing, and Data Modelling.
• Provide reports to an agreed standard to meet the requirements of NIHR Academy Executive Board.
• Assist the Assistant Director for Evaluation, Business Intelligence, and Impact with the preparation of reports and papers for strategic and policy meetings and publication.
• Evaluate outputs, formulate, and present highly complex ideas of future reporting developments.
• Apply specialist knowledge of BI solutions for non-routine enquiries.
• Oversee the implementation and delivery of new BI initiatives, policies, and projects as they arise.
• Produce analytical options papers in order to contribute to decision-making and action planning.
• Provide support and input into how data quality and integrity can be maintained as part of business improvement plans.
• Act as the initial focal point for BI queries, providing key support to the process for answering Parliamentary Questions.
• Review, manage, and lead the development of methods of collection and analysis of data to ensure accuracy of sources and data resilience.
• Monitor data quality standards by collating data produced from data quality reports and other control procedures. Assist with data cleaning exercises, data extracts, and supply processes.

Communications and Engagement

• Identify and understand the business needs, prioritise, and implement Business Intelligence tools, policies, and processes to meet those needs.
• Work with the Assistant Director for Evaluation, Business Intelligence, and Impact to identify data streams which will inform the ongoing development of BI procedures and support the strategic direction for NIHR Academy.
• Maintain regular liaison with Business Intelligence Analysts across NIHR and keep the NIHR Academy Executive Board informed of work progress or any issues.
• Train NIHR Academy's programme management staff in the most effective use of the design functionality within data visualisation tools such as QlikView or QlikSense.
• Liaise with the Information Systems team to achieve best practice and improved ways of working.
• Work with the Assistant Director for Evaluation, Business Intelligence, and Impact to take a leading role for developing and communicating highly complex and sensitive information relating to business intelligence developments, information requirements, and research evidence in line with new national initiatives.
• Liaise with other national NIHR programmes, wider NIHR, Department of Health and Social Care staff, other key funders of health and social care research, and the academic community as necessary.
• Deliver presentations to NIHR stakeholder groups, internal and external.
• Work closely with the wider NIHR Academy Evaluation and Impact team to ensure that they have sufficient data and tools to be able to respond quickly to Information Requests and long-term Analysis.

Technical

• Provide specialist knowledge across a wide range of BI tools supporting ETL, Data Warehousing, Modelling, Dashboards, and Reporting.
• Be/Act as the domain expert and understand what information can be accessed and how this is achieved.
• Use specialist knowledge of data flows and source data, providing advice on how information should be managed, focusing on data quality.
• Ensure the NIHR Academy Executive is up to date with developments in appropriate technologies.
• Plan and implement projects appropriate to the role.

Information Resources

• Co-ordinate production of analysis, publications, datasets, documentation, and briefing.
• Design and develop automated reporting processes to gain maximum benefits from using reporting and analysis software.
• Provide Technical Configuration for the SQL and QlikView Servers, including Security and Access roles, Service support, Scheduling, Version Control, Licensing, and Server update.
• Propose, implement, and test information systems and data analytical services for NIHR Academy.
• Ensure NIHR Academy meets national information governance guidelines by having specialist knowledge of GDPR and data confidentiality laws.

Staff Management and Supervision

• Provide leadership and line management on an individual basis including the direct supervision of 2 staff, objective setting, appraisals, and appropriate personal development plans.

Person Specification
Qualifications
Essential

• Masters level degree in a science, mathematics, or computing discipline or equivalent experience.

Skills & behaviours
Essential

• Think strategically.
• Lead by example.
• Give purpose and direction which includes involving people in deciding what needs to be done.
• Get the best from others.
• Identify opportunities and approaches to achieve goals and improve results.
• Lead inclusively.
• Good communication skills and ability to interface between technical and wider business.
• Ability to tackle complex problems, identify solutions, and implement them.
• Ability to work as part of a team, build and maintain good working relationships both internally and externally to the organisation.
• Excellent time management and organisational skills, with the ability to work both independently and as part of a team.
• Highly developed interpersonal skills with the ability to deal effectively with confidential, sensitive, or contentious information Ability to set goals and standards.
• Ability to take personal responsibility.
• Ability to evaluate quickly and resolve problems, escalating concerns where necessary.
• Excellent verbally and in written communications.
• Highly motivated.

Additional Requirements
Essential

• Ability to work accurately with attention to detail to identify data errors, inconsistencies, or gaps to achieve standardised, consistent, and reliable outputs.
• Ability to collate and present highly complex technical and analytical data in an easy-to-use and understandable manner for different audiences.
• Ability to work with end users at all levels to gather requirements and suggest innovative methods to streamline approaches to model and analyse data to match business requirements.
• Ability to evaluate quickly and resolve problems, escalating concerns where necessary.
• Able to demonstrate project management techniques to deliver quality outcomes to deadline, identifying risks and making contingency plans.
• Ability to maintain confidentiality.

Experience
Essential

• Creating and developing SQL server queries and/or stored procedures.
• Data management.
• Interpreting and analysing highly complex data sets from multiple databases and spreadsheets to produce reports.
• Writing reports and managing the production of technical publications.
• Specialist knowledge of statistics, database design, and BI technology.
• Specialist knowledge of Microsoft Excel.
• Specialist knowledge of Business Intelligence technology and architecture such as ETL, SQL, SSIS, QlikView, Qlik Sense, PowerBI.
• Specialist knowledge of Information Governance, General Data Protection Regulation (GDPR), and the importance of reporting standards and report definitions.
• Specialist knowledge developing dashboards, scripting, and data visualisations using tools such as QlikView.

Desirable

• Advanced development and application of Google platforms, Microsoft Office, and databases.
• Developing SSRS or other SQL-based reporting tools.
• Experience with SQL server source control.
• Knowledge of grant/award management and its metrics.
• An understanding of terminology applicable to medical research.
• An understanding of public sector health research and its management.

Employer details
Employer name
Leeds Teaching Hospitals
Address
NIHR Academy Executive
21 Queen Street
Leeds
LS1 2TW
Any attachments will be accessible after you click to apply.