Job summary
Please note:
This
is a fixed term contract role with an initial contract end date of 31 March
2025 (extension anticipated).
The salary for this role is subject to review and may change. We anticipate the salary will be confirmed prior to agreeing the start date for the successful applicant, at the very latest.
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.
Previous applicants need not apply.
Main duties of the job
Working
within a small friendly team, you will support the Assistant Director oversee
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 etc.
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 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 on-going 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 Academys 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.
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 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 on-going 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 Academys 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
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
Skills & behaviours
Essential
- Think strategically
- Leading by example
- Giving purpose and direction which includes involving people in deciding what needs to be done
- Getting the best from others
- Identifying opportunities and approaches to achieve goals and improve results
- Leading inclusively
- Good communication skills and ability 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
Additional requirements
Essential
- Highly motivated
- 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
Person Specification
Qualifications
Essential
- Masters level degree in a science, mathematics or computing discipline or equivalent experience
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
Skills & behaviours
Essential
- Think strategically
- Leading by example
- Giving purpose and direction which includes involving people in deciding what needs to be done
- Getting the best from others
- Identifying opportunities and approaches to achieve goals and improve results
- Leading inclusively
- Good communication skills and ability 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
Additional requirements
Essential
- Highly motivated
- 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
