Job summary The successful candidate will be responsible for the smooth running and technical development of the Trust's BI system. Developing and managing data flows into and out of the trust. They will lead on technical development improvements, designing and building systems in adherence with the software Development Life Cycle. The focus of this role is ensuring the Business Intelligence system, and the products that have been developed within it, are supported from a technical perspective. This involves leading a database administration function; working with IT and 3rd parties who supply hardware infrastructure to ensure the system can support growth in the number of products; developing data structures such as Extract Transform and Load processes and Cubes; exploring and developing new systems such as mobile business intelligence, new web platforms and new database systems. The post holder will also lead on change control and business intelligence support, developing and managing a robust change control process to ensure that changes to the database architecture or the source systems do not adversely impact the accuracy of Business Intelligence outputs. Main duties of the job The successful candidate will have at least 10 years experience in the business intelligence field with a focus on database administration and will have at least 2 years managerial experience. They will be responsible for managing software engineers, database administrator and product engineers. Please see below and supporting Job Description for information regarding responsibilities. About us Oxleas offers a wide range of NHS healthcare services to people in community and secure environment settings. Our services include community health care such as district nursing and speech and language therapy, care for people with learning disabilities and mental health care such as psychiatry, nursing and therapies. Our multidisciplinary teams look after people of all ages and we work in close partnership with other parts of the NHS, local councils and the voluntary sector and through our new provider collaboratives. Our 4,300 members of staff work in many different settings including hospitals, clinics, prisons, secure hospitals, children's centres, schools and people's homes.We have over 125 sites in a variety of locations in the South of England. In London we operate within the Boroughs of Bexley, Bromley Greenwich and into Kent. We manage hospital sites including Queen Mary's Hospital, Sidcup and Memorial Hospital, Woolwich, as well as the Bracton Centre, our medium secure unit for people with mental health needs. We are the largest NHS provider of prison health services providing healthcare to prisons within Devon, Dorset, Bristol, Wiltshire and Gloucestershire, Kent and South London. We are proud of the care we provide and our people. Our purpose is to improve lives by providing the best possible care to our patients and their families. This is strengthened by our new values: We're Kind We're Fair We Listen We Care Date posted 14 January 2025 Pay scheme Agenda for change Band Band 8a Salary £59,490 to £66,239 a year pa inc Contract Permanent Working pattern Full-time Reference number 277-6927091-CORP Job locations Pinewood House Pinewood House Dartford DA2 7WG Job description Job responsibilities Technical Skills Required: Design and develop business and analytical reports. SQL Server objects: t-SQL, stored procedures, views SQL Server Reporting Services objects SQL Server Integration Services packages ASP.NET web applications with C# backend Soft Skills Required Excellent communication skills, written and verbal with the ability to communicate complex technical information to a non technical audience Ability to devise best practice principles and lead on their implementation. Demonstrates a proactive approach and 'customer-focused' thinking. Advise the team on suitable technologies for use in applications Ability to manage, lead and develop a team of technical analysts Main Duties Hardware Support - ensure that the hardware in place supports the demand being placed on BI Systems. Support ICT in the procurement, installation and testing of new hardware ensuring the needs of the department are met. Database Architecture - Lead on the design of the Business Intelligence Systems architecture, setting standards for data flow processes and identifying technical solutions to meet BI Developer requirements. Software - Investigate new technologies and assess their suitability for adoption within the department. Application Development - Put in place any data collections that might be required outside of existing systems, e.g. HTML forms or new 3rd party data collection applications. Change Control - Develop a robust change control process to ensure that changes to the database architecture or the source systems do not adversely impact the accuracy of Business Intelligence outputs. Business Intelligence Support - Lead the Business Intelligence support function to respond to customer requests for fixes or changes to existing Business Intelligence products. Please Job description and personal specification for full details Job description Job responsibilities Technical Skills Required: Design and develop business and analytical reports. SQL Server objects: t-SQL, stored procedures, views SQL Server Reporting Services objects SQL Server Integration Services packages ASP.NET web applications with C# backend Soft Skills Required Excellent communication skills, written and verbal with the ability to communicate complex technical information to a non technical audience Ability to devise best practice principles and lead on their implementation. Demonstrates a proactive approach and 'customer-focused' thinking. Advise the team on suitable technologies for use in applications Ability to manage, lead and develop a team of technical analysts Main Duties Hardware Support - ensure that the hardware in place supports the demand being placed on BI Systems. Support ICT in the procurement, installation and testing of new hardware ensuring the needs of the department are met. Database Architecture - Lead on the design of the Business Intelligence Systems architecture, setting standards for data flow processes and identifying technical solutions to meet BI Developer requirements. Software - Investigate new technologies and assess their suitability for adoption within the department. Application Development - Put in place any data collections that might be required outside of existing systems, e.g. HTML forms or new 3rd party data collection applications. Change Control - Develop a robust change control process to ensure that changes to the database architecture or the source systems do not adversely impact the accuracy of Business Intelligence outputs. Business Intelligence Support - Lead the Business Intelligence support function to respond to customer requests for fixes or changes to existing Business Intelligence products. Please Job description and personal specification for full details Person Specification Qualification & Experience Essential Computer Science Degree or 10 years equivalent experience Desirable 2 Years Management experience Competencies Essential Ability to communicate in different forms with stakeholders Ability to work autonomously and manage own time Planning and organisational skills Self-motivated and able to act on own initiative Leadership skills Desirable Knowledge and understanding of GDPR Understanding of Clinical Information/Patient Management Systems or equivalent systems Skills/ Technical Knowledge Essential Working with Data (SQL Server) Developing Reports (SSRS) Developing ETL Packages (SSIS) Writing code (HTML, JavaScript, C#, Python, PowerShell or other) Desirable Use of development lifecycle Use of Source Version Control, e.g. Git Working in DevOps environment Person Specification Qualification & Experience Essential Computer Science Degree or 10 years equivalent experience Desirable 2 Years Management experience Competencies Essential Ability to communicate in different forms with stakeholders Ability to work autonomously and manage own time Planning and organisational skills Self-motivated and able to act on own initiative Leadership skills Desirable Knowledge and understanding of GDPR Understanding of Clinical Information/Patient Management Systems or equivalent systems Skills/ Technical Knowledge Essential Working with Data (SQL Server) Developing Reports (SSRS) Developing ETL Packages (SSIS) Writing code (HTML, JavaScript, C#, Python, PowerShell or other) Desirable Use of development lifecycle Use of Source Version Control, e.g. Git Working in DevOps environment 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 Oxleas NHS Foundation Trust Address Pinewood House Pinewood House Dartford DA2 7WG Employer's website http://oxleas.nhs.uk/ (Opens in a new tab)