Job summary
Business Intelligence Officer Band 5 - The successful candidate will work closely with the Directorate Business Manager and IT colleagues to deliver a high quality of service information & reports to colleagues within the Trust and to external users of the service. A key element of the role is to support the Directorate with SQL related tasks and data provision and involvement in data projects as required. There will be a requirement for excellent IT skills, particularly SQL, Excel and Access, to work with the databases and systems in place.
The post holder will be part of a small team within a larger Directorate and will benefit from working in a successful and supportive Directorate where there is great diversity in terms of roles and people and opportunity and where the Trust's 'PROUD' values are embedded within the Team.
This vacancy is advertised on a fixed term contract basis for the maximum period of 18 months, Where there is potential, the secondment/fixed term contract may finish early, or in the first instance, the secondment/fixed term contract may be extended due to the internal/external secondment of the substantive post holder. The fixed term contract status of the post holder will be reviewed in accordance with the Trust's legal obligations regarding fixed term contracts and secondments in relation to the substantive post holder.
Main duties of the job
- To provide analytical, business intelligence and technical support to the Directorate Business Team and wider Directorate, assisting in the provision of information and the maintenance of databases, to run and provide standard reports and create specifically tailored reports and queries as required.
- To provide data analysis (frequently complex data) and create reports to support the Directorate in relation to any activity related enquiries
- To provide general support for activity and technical queries on behalf of the IT and Business Teams, as required
- To provide, analyse and audit data returns to NHSI, in conjunction with the IT Lead, Business Manager and Laboratory Managers ensuring accurate reflection of Laboratory Medicine activity for submission into NHSI Model Hospital portals
About us
Laboratory Medicine provides clinical laboratory services to clinicians working in hospital, community and general practice. The Directorate's prime function is to provide a first class diagnostic service based on the examination of specimens collected from patients, and it also makes very significant contributions to teaching and research in an environment of academic excellence.
The Business Team is a small, collaborative and focused team providing flexible support to the wider Laboratory Medicine Directorate and Trust. We are looking for an enthusiastic candidate to play a key role in joining the Team, aware that excellent organisational, communication, IT skills and attention to detail are essential requirements for the role.
You will be working for an organisation which values and respects all of its staff and the community it serves. The Trust is a leader in the NHS and research sectors and provides excellent benefits for its staff. This includes commitments to professional development but also many policies to support employees in balancing their personal and professional lives.
Job description
Job responsibilities
Please view the attached Job Description and Person Specification documents for full details regarding this post.
When completing your application please ensure that you clearly demonstrate how you meet the role criteria.
Job description
Job responsibilities
Please view the attached Job Description and Person Specification documents for full details regarding this post.
When completing your application please ensure that you clearly demonstrate how you meet the role criteria.
Person Specification
Qualifications
Essential
- Educated to degree level in a business or data analysis related subject (or equivalent experience)
Desirable
- Qualification in advanced IT Use (eg Microsoft Office Specialist (MOS): Excel, Microsoft Office Specialist (MOS): Access)
- Qualifications in Maths, Statistics or data manipulation
Experience
Essential
- Excellent IT skills in a range of data information systems including Microsoft Office packages with strong skills in Excel, Word & Access
- Investigative and analytical reporting skills including experience in statistical analysis
- Experience of database design, development and associated concepts.
- Writing complex formulae in Excel
- Demonstrable experience of SQL, VBA and Macros
- Experience of data manipulation and report writing
- Supervisory or Line Management experience
Desirable
- Experience of working in a business, IT or statistic related role within a health related environment
- Experiencing of working in an NHS Laboratory setting and scrutinising laboratory data in particular
- Experience of VBA/Macros
Further Training
Desirable
- Competence in statistical analysis
- Project management training
Special Skills/Aptitudes
Essential
- Excellent communication skills, both written and oral
- Ability to work accurately with attention to detail
- Ability to produce concise and clear reports summarising activity data
- Understanding of data protection legislation and its impact on the role
- Good organisational skills & excellent time management skills
- Ability to work accurately and calmly under pressure
- Commitment to patient-centred service
- Ability to design, implement and monitor protocols
Other Factors
Essential
- Flexible and innovative with an ability to adapt to changing needs of the service
- Ability to work systematically and thoroughly and as part of a team and independently.
- Willingness to learn new skills and develop own knowledge
- There is a requirement to use VDU equipment regularly for extended periods
- Frequent prolonged concentration
Person Specification
Qualifications
Essential
- Educated to degree level in a business or data analysis related subject (or equivalent experience)
Desirable
- Qualification in advanced IT Use (eg Microsoft Office Specialist (MOS): Excel, Microsoft Office Specialist (MOS): Access)
- Qualifications in Maths, Statistics or data manipulation
Experience
Essential
- Excellent IT skills in a range of data information systems including Microsoft Office packages with strong skills in Excel, Word & Access
- Investigative and analytical reporting skills including experience in statistical analysis
- Experience of database design, development and associated concepts.
- Writing complex formulae in Excel
- Demonstrable experience of SQL, VBA and Macros
- Experience of data manipulation and report writing
- Supervisory or Line Management experience
Desirable
- Experience of working in a business, IT or statistic related role within a health related environment
- Experiencing of working in an NHS Laboratory setting and scrutinising laboratory data in particular
- Experience of VBA/Macros
Further Training
Desirable
- Competence in statistical analysis
- Project management training
Special Skills/Aptitudes
Essential
- Excellent communication skills, both written and oral
- Ability to work accurately with attention to detail
- Ability to produce concise and clear reports summarising activity data
- Understanding of data protection legislation and its impact on the role
- Good organisational skills & excellent time management skills
- Ability to work accurately and calmly under pressure
- Commitment to patient-centred service
- Ability to design, implement and monitor protocols
Other Factors
Essential
- Flexible and innovative with an ability to adapt to changing needs of the service
- Ability to work systematically and thoroughly and as part of a team and independently.
- Willingness to learn new skills and develop own knowledge
- There is a requirement to use VDU equipment regularly for extended periods
- Frequent prolonged concentration
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).
