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
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.
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).
