Job summary This is an exciting time for the NHS in Cornwall, with investment that will fund the development of a new Electronic Patient Record at the Royal Cornwall Hospitals Trust. This will be the biggest investment and transformation in the digital technology, that supports our patient care, for more than 30 years. Our new EPR will touch the lives of staff, patients and partner organisations across Cornwall, the Isles of Scilly and beyond. Our services will be supported by a software system that is modern, flexible, and able to support the ongoing health care needs of our population. A key part of the programme will be the transformation of reporting methods, information provision and business intelligence extracted from the new system. To support this, we are developing new posts in our vital, award winning, Information and Business Intelligence (BI) service. You could play a crucial part in our journey to deliver brilliant healthcare services across Cornwall. Key elements of this post include:- Educated to degree level / post grad diploma. Computing related qualification Comprehensive knowledge & expert use of SQL Language and SQL Server Experience of working in information management and the use of information systems. Logical and organised in approach, enthusiastic, team player. Highly Skilled in collecting, extracting and validating complex and sensitive data from a variety of computer systems Main duties of the job The Information and Business Intelligence team have a direct and tangible link to the high quality of patient care and patient safety delivered across the Trust, providing key reporting/BI solutions. These roles will support the reporting/information work streams during the Electronic Patient Record (EPR) implementation. This will encompass assisting the Senior Management Team in ensuring reporting from the EPR complies with the national information guidelines, updating Data Collection Worksheets, lead on implementing quality checks and producing data quality reports. The post holders will also be responsible for cascading specialist knowledge and understanding of the new system, into the wider Information and BI Team. We are looking for motivated and committed individuals, who are passionate about how data, information and BI tools can transform services and underpin the health of our population. We are looking for candidates with strong SQL experience, knowledge and experience of analytical techniques and technologies, an aptitude for problem-solving, a keen eye for detail, data analysis, and excellent communication skills. The best candidates will have experience in data extraction, analysis and data reporting and developing new information reports using a variety of business intelligence tools. About us Royal Cornwall Hospitals NHS Trust is the biggest provider of healthcare services in Cornwall and the Isles of Scilly. Our three main sites are Royal Cornwall Hospital Truro, St Michael's Hospital Hayle and West Cornwall Hospital Penzance, our staff and services are available across the region. The Trust employs 5,000 staff, has a budget of £380 million and 750 beds. We work with health and social care organisations -including NHS Kernow and NHS England- to ensure local healthcare needs are met. We provide acute medical, surgical and specialist services to around 500,000- which can increase significantly during busy holiday periods. The Trust has teaching hospitals status as part of the University of Exeter Medical School. Keeping at the forefront of medical advances, we continually develop clinical services and are committed to maximising the range of specialist care offered locally. We can offer you a rewarding career in a supportive working environment. We have extensive educational links to help you realise your full potential and develop skills to provide outstanding healthcare to the local community. Enjoy an outstanding quality of life in a place that offers surfing beaches and fishing harbours to beautiful countryside and historic towns. With clean air, plenty of opportunities for outdoor activities and excellent schools, colleges and universities (including adult education) it is the ideal place for families and for you to develop your own career. Date posted 08 November 2024 Pay scheme Agenda for change Band Band 6 Salary £37,338 to £44,962 a year Per annum pro rata Contract Fixed term Duration 10 months Working pattern Full-time, Part-time Reference number 156-6780872 Job locations Royal Cornwall Hospital Treliske Truro TR1 3LJ Job description Job responsibilities PLEASE NOTE: To view the full Job Description and Person Specification, please click the supporting document on the right-hand side. To be an employee of the NHS you need to successfully complete the following: Identity Checks Professional registration and qualification checks Employment history and reference checks Occupational Health clearance Satisfactory Disclosure and Barring Service check Right to work in the UK For further information please visit: https://www.nhsemployers.org/topics-networks/employment-standards-and-regulation We reserve the right to close this advert early. We may be able to offer flexible working. Please discuss at interview. We may be able to offer sponsorship but this is not guaranteed. Job description Job responsibilities PLEASE NOTE: To view the full Job Description and Person Specification, please click the supporting document on the right-hand side. To be an employee of the NHS you need to successfully complete the following: Identity Checks Professional registration and qualification checks Employment history and reference checks Occupational Health clearance Satisfactory Disclosure and Barring Service check Right to work in the UK For further information please visit: https://www.nhsemployers.org/topics-networks/employment-standards-and-regulation We reserve the right to close this advert early. We may be able to offer flexible working. Please discuss at interview. We may be able to offer sponsorship but this is not guaranteed. Person Specification Qualifications Essential Educated to degree level. Computing related qualification. Experience Essential Comprehensive knowledge of SQL Language and SQL Server. Experience of working in information management and the use of information systems. Desirable Specialist knowledge and experience of business intelligence software both from a customer and technical viewpoint (particularly SharePoint and the Microsoft BI stack). Significant experience of working in Information Management in the NHS or Healthcare environment. Skills & Knowledge Essential Expert use of SQL. Logical and organised in approach, enthusiastic, team player. Highly Skilled in collecting, extracting and validating complex and sensitive data from a variety of computer systems. Highly skilled in understanding, interpreting and responding appropriately to complex information requests, queries and problems. Desirable Comprehensive knowledge and understanding of NHS data definitions, Acute and Community information, clinical terminology and coding systems. Comprehensive knowledge and practical experience of Hospital systems such as PAS, ICS and Encore. Person Specification Qualifications Essential Educated to degree level. Computing related qualification. Experience Essential Comprehensive knowledge of SQL Language and SQL Server. Experience of working in information management and the use of information systems. Desirable Specialist knowledge and experience of business intelligence software both from a customer and technical viewpoint (particularly SharePoint and the Microsoft BI stack). Significant experience of working in Information Management in the NHS or Healthcare environment. Skills & Knowledge Essential Expert use of SQL. Logical and organised in approach, enthusiastic, team player. Highly Skilled in collecting, extracting and validating complex and sensitive data from a variety of computer systems. Highly skilled in understanding, interpreting and responding appropriately to complex information requests, queries and problems. Desirable Comprehensive knowledge and understanding of NHS data definitions, Acute and Community information, clinical terminology and coding systems. Comprehensive knowledge and practical experience of Hospital systems such as PAS, ICS and Encore. 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. Certificate of Sponsorship 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. Certificate of Sponsorship 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). Employer details Employer name Royal Cornwall Hospitals Trust Address Royal Cornwall Hospital Treliske Truro TR1 3LJ Employer's website https://www.royalcornwall.nhs.uk/ (Opens in a new tab)