Job summary
Expected Shortlisting
Date
01/09/2025
Planned Interview
Date
11/09/2025
This
is a fixed term 22.5 hours per week contract with an end date of 31 March
2027.
We
are seeking a dynamic, self-motivated and passionate person with experience
of working in a progressive Business Intelligence environment.
Do
you have experience leading the delivery of BI solutions for organisations
with multiple stakeholders? Delivering
quality assured evidence based insights to inform business decisions?
Can
you provide technical support and data warehouse maintenance? Do you have experience producing self
reporting dashboards in data visualisation environments such as Qlik or
Tableau?
The
role will develop informatics delivery, ensuring user requirements are met
with accurate and well-presented outputs supporting the NIHR missions to
improve the health and wealth of the nation through research.
Main duties of the job
Our
business intelligence tasks can range in scale from small ad-hoc data
requests to long-term, cross-team projects. As part of a small and friendly
team your role will allow you to work with the full end-to-end business
intelligence delivery process. From
meeting stakeholders and understanding requirements, through data modelling
and the ETL process, to data visualisation and generating insight - youll
get to experience it all!
Main
duties will include working with relational databases with MS SQL server and
ETL tools such as SSIS. You will also
perform analysis of data loads and implement data warehouse design theory and
data modelling techniques. Producing reports and data visualisation in Qlik
or Tableau using a variety of data sources. Our current data warehouse is
on-premise, but there may be the opportunity in the future to move to a
hybrid or cloud based approach. Therefore, any experience of Microsoft Azure
or Amazon AWS may also be beneficial.
Through
our data scientists, we are exploring and implementing artificial
intelligence and machine learning solutions.
An enthusiasm for the field of data science, and a desire to
collaborate, and support these projects will 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
Data
Quality and Evaluation
- Provide
reports to an agreed standard to meet the requirements of NIHR Academy
Executive Board
- Monitor
established reporting to ensure data quality and integrity is maintained
- Evaluate
outputs, formulate and present ideas of future reporting developments
- Deal
with non-routine enquiries providing advice as necessary
- Analyse
and report on a range of options 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
- Provide
support in responding to information requests and parliamentary questions
- Implements
business intelligence policies and proposes changes to user working practices
and procedures e.g. when planning for new projects, changes in legislation,
new reporting processes, new training programmes impacting across the
organisation.
- Continuous
improvement of data collection and modelling processes to ensure future fit
for purpose
Communications
and Engagement
- Provide
and receive complex, sensitive information
- Communicate
complicated, difficult to explain issues to non-technical staff
- Present
comprehensive reports and analysis of data gathered to the NIHR Academy
Executive Board and other stakeholders
- Build
relationships with end users to ensure that the BI function provides the
tools that they require
- Contribute
to cross-NIHR meetings and groups, effectively communicating information
relating to NIHR Academy
Technical
- Use
appropriate BI tools to access and analyse data
- Provide
server side infrastructure support to the BI Manager to ensure reporting and
BI tools continue to be available at all times
- Plan
and implement projects appropriate to the role
- Achieve
agreed objectives, working within professional policies, acting as a
specialist in own area
Job description
Job responsibilities
Data
Quality and Evaluation
- Provide
reports to an agreed standard to meet the requirements of NIHR Academy
Executive Board
- Monitor
established reporting to ensure data quality and integrity is maintained
- Evaluate
outputs, formulate and present ideas of future reporting developments
- Deal
with non-routine enquiries providing advice as necessary
- Analyse
and report on a range of options 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
- Provide
support in responding to information requests and parliamentary questions
- Implements
business intelligence policies and proposes changes to user working practices
and procedures e.g. when planning for new projects, changes in legislation,
new reporting processes, new training programmes impacting across the
organisation.
- Continuous
improvement of data collection and modelling processes to ensure future fit
for purpose
Communications
and Engagement
- Provide
and receive complex, sensitive information
- Communicate
complicated, difficult to explain issues to non-technical staff
- Present
comprehensive reports and analysis of data gathered to the NIHR Academy
Executive Board and other stakeholders
- Build
relationships with end users to ensure that the BI function provides the
tools that they require
- Contribute
to cross-NIHR meetings and groups, effectively communicating information
relating to NIHR Academy
Technical
- Use
appropriate BI tools to access and analyse data
- Provide
server side infrastructure support to the BI Manager to ensure reporting and
BI tools continue to be available at all times
- Plan
and implement projects appropriate to the role
- Achieve
agreed objectives, working within professional policies, acting as a
specialist in own area
Person Specification
Experience
Essential
- Advanced knowledge of Microsoft Excel
- Specialist business intelligence knowledge and expertise acquired through degree level or equivalent qualification/experience
- Experience of complex data analysis using advanced knowledge of statistics, database design and BI systems tools
- Understand basic concepts of BI Architecture such as ETL, Data Warehousing and Data Modelling
- Ability to manipulate, model and analyse data using Excel, SQL, QlikView, Qlik Sense
- Experience developing reports using data visualisation tools such as QlikView, Qlik Sense, Tableau or Power BI
- Experience in processes related to data collection, modelling and processing data to maintain a trusted data source
- Commitment to self development and consideration of options that may improve or provide alternative solutions to existing NIHR Academy technology
- An understanding of data protection and information governance including GDPR and the importance of reporting standards and report definitions
Desirable
- Experience creating ad hoc SQL queries of T-SQL
- Experience of project management
- Advanced development and application of google platforms, Microsoft office and databases
- Contributed to peer reviewed publications
- Experience of Microsoft Visual Studio (SSIS)
- 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
Skills & behaviours
Essential
- Highly developed interpersonal skills with the ability to deal effectively with confidential, sensitive, or contentious information
- Quickly assimilate information and apply knowledge effectively to new problems, escalating concerns where necessary
- Well-developed knowledge and experience of operating and utilising information systems and software applications
- Understanding of Business Intelligence terminology and processes
- Understanding of Relational Databases
- 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
- Ability to set goals and standards
- Ability to take personal responsibility
- Excellent verbally and in written communications
- Highly motivated
- Ability to give, receive and seek advice to/from peers and wider NIHR Academy executive
Desirable
- Experience developing and scripting with QlikView
- Experience developing SSIS routines
- Understanding of Source or Change Control processes
- Understanding of Relational database administration and maintenance routines
Additional Requirements
Essential
- Ability to work accurately with attention to detail
- Use of BI tool sets such as QlikView and SQL
- Experience of drafting reports or manuscripts
- Experience creating plans for BI solutions
- Ability to analyse, interpret and present complex data and policy information in an easy to use and understandable manner for different audiences
- Ability to collect, model and process data from many different sources
- 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 identify data errors, inconsistencies, or gaps to achieve standardised, consistent, and reliable outputs
- Ability to maintain confidentiality
- Willingness and ability to travel in UK on a frequent and regular basis, including occasional overnight absence
Qualifications
Essential
- Degree in a science, mathematics or computing discipline or equivalent experience as a reporting analyst
Desirable
- Masters degree in a science, mathematics or computing discipline or equivalent
Person Specification
Experience
Essential
- Advanced knowledge of Microsoft Excel
- Specialist business intelligence knowledge and expertise acquired through degree level or equivalent qualification/experience
- Experience of complex data analysis using advanced knowledge of statistics, database design and BI systems tools
- Understand basic concepts of BI Architecture such as ETL, Data Warehousing and Data Modelling
- Ability to manipulate, model and analyse data using Excel, SQL, QlikView, Qlik Sense
- Experience developing reports using data visualisation tools such as QlikView, Qlik Sense, Tableau or Power BI
- Experience in processes related to data collection, modelling and processing data to maintain a trusted data source
- Commitment to self development and consideration of options that may improve or provide alternative solutions to existing NIHR Academy technology
- An understanding of data protection and information governance including GDPR and the importance of reporting standards and report definitions
Desirable
- Experience creating ad hoc SQL queries of T-SQL
- Experience of project management
- Advanced development and application of google platforms, Microsoft office and databases
- Contributed to peer reviewed publications
- Experience of Microsoft Visual Studio (SSIS)
- 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
Skills & behaviours
Essential
- Highly developed interpersonal skills with the ability to deal effectively with confidential, sensitive, or contentious information
- Quickly assimilate information and apply knowledge effectively to new problems, escalating concerns where necessary
- Well-developed knowledge and experience of operating and utilising information systems and software applications
- Understanding of Business Intelligence terminology and processes
- Understanding of Relational Databases
- 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
- Ability to set goals and standards
- Ability to take personal responsibility
- Excellent verbally and in written communications
- Highly motivated
- Ability to give, receive and seek advice to/from peers and wider NIHR Academy executive
Desirable
- Experience developing and scripting with QlikView
- Experience developing SSIS routines
- Understanding of Source or Change Control processes
- Understanding of Relational database administration and maintenance routines
Additional Requirements
Essential
- Ability to work accurately with attention to detail
- Use of BI tool sets such as QlikView and SQL
- Experience of drafting reports or manuscripts
- Experience creating plans for BI solutions
- Ability to analyse, interpret and present complex data and policy information in an easy to use and understandable manner for different audiences
- Ability to collect, model and process data from many different sources
- 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 identify data errors, inconsistencies, or gaps to achieve standardised, consistent, and reliable outputs
- Ability to maintain confidentiality
- Willingness and ability to travel in UK on a frequent and regular basis, including occasional overnight absence
Qualifications
Essential
- Degree in a science, mathematics or computing discipline or equivalent experience as a reporting analyst
Desirable
- Masters degree in a science, mathematics or computing discipline or equivalent
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.
