The successful candidate will be responsible for the smooth running and technical development of the Trust's BI system, 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 developed within it are supported from a technical perspective. This involves leading a database administration function, working with IT and third parties who supply hardware infrastructure to ensure the system can support growth in the number of products, developing data structures such as Extract, Transform, Load processes, and Cubes. The candidate will also explore and develop new systems such as mobile business intelligence, new web platforms, and new database systems.
The post holder will 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 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 of experience in the business intelligence field with a focus on database administration and at least 2 years of managerial experience. They will be responsible for managing software engineers, database administrators, 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, working in close partnership with other parts of the NHS, local councils, and the voluntary sector 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 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, 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, 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 third-party data collection applications.
* Change Control - Develop a robust change control process to ensure that changes to the database architecture or 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.
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
Employer details
Employer name
Oxleas NHS Foundation Trust
Address
Pinewood House
Dartford
DA2 7WG
Any attachments will be accessible after you click to apply.
277-6927091-CORP #J-18808-Ljbffr