Job summary
For external applicants, this role will be offered on a fixed term contract; for current NHS employees, it will be a secondment subject to line manager approval.
Business Intelligence Data Analyst - Targeted Lung Health Check Programme (TLHC)
The TLHC Programme is new to Leicester, Leicestershire and Rutland and the BI Data analyst role will be critical to the establishment, operational rollout and onward management of the programme.
Main duties of the job
The post holder will be an integral member of the TLHC Programme Team and will be responsible for the delivery of a high quality and professional at-scale reporting, analysis, monitoring, interpretation, and support service on all local, regional, and national data and reporting requirements.
About us
Our new strategy, developed with the support and feedback of colleagues, patients, and partners, is our compass for the next seven years (2023-2030).
We have four primary goals:
- high-quality care for all,
- being a great place to work,
- partnerships for impact, and
- research and education excellence
And we will embed health equality in all we do - taking active steps to reduce the avoidable differences in healthcare that some people face, working in partnership with communities.
Our strategy is underpinned by new values and we will work to ensure they are an everyday reality for all:
- we are compassionate,
- we are proud,
- we are inclusive, and
- we are one team
This is an exciting moment as we look to the future with clarity on what we already do well and where we need to focus our energies to make an even bigger difference for the people we serve.
About the University Hospitals of Leicester NHS Trust:
http://www.leicestershospitals.nhs.uk/aboutus/work-for-us/current-vacancies/
Job description
Job responsibilities
The post holder will have specialist knowledge and expertise to enable them full responsibility for the collection, manipulation, analysis, interpretation, reporting and management of highly complex information from multiple sources including patient activity, demographic and epidemiological information to support the implementation of the TLHC programme.
The provision and continued operation and development of the employment of a data warehouse that will hold data from multiple sources but primarily from the SProc CMS system.
The linkage to the MLCSU BI team towards the availability and maintenance of the data warehouse on the BI servers
Developing and managing the generation of daily data feeds to the data warehouse from CMS and identification of and notification to the BI Function when data flows are incomplete.
The provision and development of a standardised suite of reports to agreed protocols to both the business and national bodies such as NHSE.
Responsibility for the at scale delivery of statutory returns
Job description
Job responsibilities
The post holder will have specialist knowledge and expertise to enable them full responsibility for the collection, manipulation, analysis, interpretation, reporting and management of highly complex information from multiple sources including patient activity, demographic and epidemiological information to support the implementation of the TLHC programme.
The provision and continued operation and development of the employment of a data warehouse that will hold data from multiple sources but primarily from the SProc CMS system.
The linkage to the MLCSU BI team towards the availability and maintenance of the data warehouse on the BI servers
Developing and managing the generation of daily data feeds to the data warehouse from CMS and identification of and notification to the BI Function when data flows are incomplete.
The provision and development of a standardised suite of reports to agreed protocols to both the business and national bodies such as NHSE.
Responsibility for the at scale delivery of statutory returns
Person Specification
Training & Qualifications
Essential
- Educated to degree level (or relevant experience) and 2 years information and analysis management.
- Significant specialised knowledge
Desirable
- Degree or postgraduate qualification with numerical or analytical content.
- Formal Project Management Training
Commitment to Trust Value and Behaviours
Essential
- Must be able to demonstrate behaviours consistent with the Trust's Values and Behaviours
Experience
Essential
- Post qualification experience in a senior information role in a multi-professional complex organisation.
- Evidence of having successfully delivered analytical support
- Track record of learning and self-development,
- Advanced knowledge and experience in relation to SQL
- Specialist knowledge and expertise in database design and modelling for data warehouse and business intelligence applications, including relational database structures and normal forms.
- Significant data manipulation, data querying and reporting experience
- Basic knowledge of project principles
- Advanced Microsoft Excel, word processing and Power Point user
- Experience of the analysis of complex data including using various statistical techniques to produce and present board level reports.
Desirable
- Understanding of Caldicott principle and information governance.
- Awareness of the wider context of health care delivery
- Ability to interpret and implement Freedom of Information Act.
- Advanced knowledge of SProc CMS.
- Basic understanding of a Dynamic Procurement system
- Knowledge and understanding of the software development life cycle.
- Technical documentation and version control
- Knowledge of Power BI and Tableau
Communication and relationship skills
Essential
- Approachable, reliable, decisive, tactful, motivated, respectful, and supportive.
- Excellent communication skills, with experience in disseminating and summarising information with demonstrable impact
- Report writing - Proven ability to write clear and concise analytical reports and briefing papers using a variety of methodologies for data visualisation.
- Ability to present and explain complex technical topics and problems and present alternative solutions to others.
- Provide and receive complex, sensitive, and contentious information, negotiate with senior stakeholders on difficult and controversial issues, and present complex and sensitive information to various groups
- Evidence of building effective working relationships with clinical leaders, partner organisations and other stakeholders
- Use a range of communication channels to build relationships, manage barriers to effective communication.
Analytical and Judgement skills
Essential
- Can judge highly complex facts/situations requiring analysis, interpretation, and comparison of a wide range of options.
- Understands the theoretical knowledge required for data analysis, and the appropriate statistical, numerical, techniques, methodologies, and tools to analyse, manipulate and interpret data Design of information systems to manage planning and management of resources.
- Ability to analyse and interpret highly complex information and translate into clear messages/ presentations.
- Ability to manage conflict from senior teams when opinions challenge the data presented.
- Ability to concentrate for long periods of time on highly complex and multi stranded analysis
- Experience of capacity planning and market assessment analysis
- Technical expertise in data analysis such as Access, Excel, Business Objects, SQL
Desirable
- Ability to analyse impacts and outcomes to support business case development.
Skills
Essential
- Highly specialist knowledge of theory and practice and information analysis.
- Excellent knowledge of NHS Information terminology.
- In depth knowledge of statistics and epidemiological information analysis.
- Understanding of NHS performance monitoring processes.
- In depth knowledge of the national and local health context.
- Attention to detail and excellent numerical skills
Desirable
- Service redesign
- Specialist knowledge of Payment by Results
- Project Management skills
Planning and organisation skills
Essential
- Plan and organise a broad range of complex activities
- Formulate and adjust plans to inform strategic direction and timelines that may involve uncertainty at speciality level.
- Project planning in all aspects of the business area when required.
- Formulate policies and procedure where required
Equality, Diversity and Inclusion
Essential
- Able to demonstrate a commitment and understanding of the importance of treating all individuals with dignity and respect appropriate to their individual needs
Other requirements specific to the role
Essential
- Ability to provide, receive and present highly complex, sensitive, or contentious information to large groups.
- Able to manage and prioritise conflicting demands/strands of work/projects and work simultaneously where needed.
- Able to initiate and plan statistical work programmes and flex to meet stakeholder requirements and needs.
Desirable
- Self- critique of work and development needs.
- Keep abreast of related national information developments as part of continuous professional development.
Person Specification
Training & Qualifications
Essential
- Educated to degree level (or relevant experience) and 2 years information and analysis management.
- Significant specialised knowledge
Desirable
- Degree or postgraduate qualification with numerical or analytical content.
- Formal Project Management Training
Commitment to Trust Value and Behaviours
Essential
- Must be able to demonstrate behaviours consistent with the Trust's Values and Behaviours
Experience
Essential
- Post qualification experience in a senior information role in a multi-professional complex organisation.
- Evidence of having successfully delivered analytical support
- Track record of learning and self-development,
- Advanced knowledge and experience in relation to SQL
- Specialist knowledge and expertise in database design and modelling for data warehouse and business intelligence applications, including relational database structures and normal forms.
- Significant data manipulation, data querying and reporting experience
- Basic knowledge of project principles
- Advanced Microsoft Excel, word processing and Power Point user
- Experience of the analysis of complex data including using various statistical techniques to produce and present board level reports.
Desirable
- Understanding of Caldicott principle and information governance.
- Awareness of the wider context of health care delivery
- Ability to interpret and implement Freedom of Information Act.
- Advanced knowledge of SProc CMS.
- Basic understanding of a Dynamic Procurement system
- Knowledge and understanding of the software development life cycle.
- Technical documentation and version control
- Knowledge of Power BI and Tableau
Communication and relationship skills
Essential
- Approachable, reliable, decisive, tactful, motivated, respectful, and supportive.
- Excellent communication skills, with experience in disseminating and summarising information with demonstrable impact
- Report writing - Proven ability to write clear and concise analytical reports and briefing papers using a variety of methodologies for data visualisation.
- Ability to present and explain complex technical topics and problems and present alternative solutions to others.
- Provide and receive complex, sensitive, and contentious information, negotiate with senior stakeholders on difficult and controversial issues, and present complex and sensitive information to various groups
- Evidence of building effective working relationships with clinical leaders, partner organisations and other stakeholders
- Use a range of communication channels to build relationships, manage barriers to effective communication.
Analytical and Judgement skills
Essential
- Can judge highly complex facts/situations requiring analysis, interpretation, and comparison of a wide range of options.
- Understands the theoretical knowledge required for data analysis, and the appropriate statistical, numerical, techniques, methodologies, and tools to analyse, manipulate and interpret data Design of information systems to manage planning and management of resources.
- Ability to analyse and interpret highly complex information and translate into clear messages/ presentations.
- Ability to manage conflict from senior teams when opinions challenge the data presented.
- Ability to concentrate for long periods of time on highly complex and multi stranded analysis
- Experience of capacity planning and market assessment analysis
- Technical expertise in data analysis such as Access, Excel, Business Objects, SQL
Desirable
- Ability to analyse impacts and outcomes to support business case development.
Skills
Essential
- Highly specialist knowledge of theory and practice and information analysis.
- Excellent knowledge of NHS Information terminology.
- In depth knowledge of statistics and epidemiological information analysis.
- Understanding of NHS performance monitoring processes.
- In depth knowledge of the national and local health context.
- Attention to detail and excellent numerical skills
Desirable
- Service redesign
- Specialist knowledge of Payment by Results
- Project Management skills
Planning and organisation skills
Essential
- Plan and organise a broad range of complex activities
- Formulate and adjust plans to inform strategic direction and timelines that may involve uncertainty at speciality level.
- Project planning in all aspects of the business area when required.
- Formulate policies and procedure where required
Equality, Diversity and Inclusion
Essential
- Able to demonstrate a commitment and understanding of the importance of treating all individuals with dignity and respect appropriate to their individual needs
Other requirements specific to the role
Essential
- Ability to provide, receive and present highly complex, sensitive, or contentious information to large groups.
- Able to manage and prioritise conflicting demands/strands of work/projects and work simultaneously where needed.
- Able to initiate and plan statistical work programmes and flex to meet stakeholder requirements and needs.
Desirable
- Self- critique of work and development needs.
- Keep abreast of related national information developments as part of continuous professional development.
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.
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).
Additional information
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.
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).