Job summary
1 x fixed term contract role with an end date of 3 October 2025
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.
Expected Shortlisting
Date:
14/11/2024
Planned Interview
Date:
28/11/2024
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
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
Experience
Essential
- Understand basic concepts of BI Architecture such as ETL, Data Warehousing and Data Modelling
- 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
Desirable
- Experience of Microsoft Visual Studio (SSIS)
- Experience creating ad hoc SQL queries of T-SQL
- Experience of project management
Skills & behaviours
Essential
- An understanding of data protection and information governance including GDPR and the importance of reporting standards and report definitions
- 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.
- 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 analyse, interpret and present complex data and policy information 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 identify data errors, inconsistencies, or gaps to achieve standardised, consistent, and reliable outputs
Desirable
- 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
- 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
Other Criteria
Essential
- Willingness and ability to travel in UK on a frequent and regular basis, including occasional overnight absence
Person Specification
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
Experience
Essential
- Understand basic concepts of BI Architecture such as ETL, Data Warehousing and Data Modelling
- 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
Desirable
- Experience of Microsoft Visual Studio (SSIS)
- Experience creating ad hoc SQL queries of T-SQL
- Experience of project management
Skills & behaviours
Essential
- An understanding of data protection and information governance including GDPR and the importance of reporting standards and report definitions
- 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.
- 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 analyse, interpret and present complex data and policy information 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 identify data errors, inconsistencies, or gaps to achieve standardised, consistent, and reliable outputs
Desirable
- 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
- 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
Other Criteria
Essential
- Willingness and ability to travel in UK on a frequent and regular basis, including occasional overnight absence
