We are seeking a highly skilled candidate with exceptional and demonstrable technical abilities in SQL, capable of developing robust reporting solutions to meet varied customer requirements. The successful applicant will have a minimum of 3 years experience working with SQL, databases and data warehouses to produce reports and scope for improvements. Understanding of RiO and other patient management systems will be advantageous. Therefore proven experience in extracting, merging, and manipulating datasets from multiple IT platforms is essential, alongside a track record of solving complex data quality issues. The role demands a thorough understanding of SQL, operational standards, information datasets, and key performance measures, working collaboratively with clinicians, managers, and staff to deliver data-driven insights and champion the roll-out of the Business Information System (BIS).
This is fixed term maternity cover for 12-15 months
This vacancy may be closed before the advertised end date if a high volume of applications are received
Develop, code, test, and implement efficient and reliable database schemes, as well as SQL queries, views, stored procedures, and triggers to support business intelligence initiatives
Utilise tools such as SQL, SQL Server Reporting Services (SSRS), Excel, and Power BI to automate scheduled reporting, organise and prepare data for analysis, and provide actionable insights
Assist Performance and Information Manager and Head of Data Services to meet department objectives
Line management of junior staff
Strong communication and collaboration skills as will work with different colleagues, managers and teams
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
Develop, code, test, and implement efficient and reliable database schemas, as well as SQL queries, views, stored procedures, and triggers to support business intelligence initiatives
Utilise tools such as SQL, SQL Server Reporting Services (SSRS), Excel, and Power BI to automate scheduled reporting, organise and prepare data for analysis, and provide actionable insights
Manage and organise comprehensive data reports for external submissions e.g. MHSDS, CSDS to NHSE, commissioners, and partners.
To act as a source of analytical expertise and advise operational teams on the interpretation of performance information and data standards
Provide a high-quality customer focused service to colleagues throughout the Trust ensuring that their information needs are met
Play an active role in the monitoring and improvement of information across the organisation
Take responsibility for resolving problems with the Business Information System (BIS) on behalf of the directorates
Work closely with the development team to ensure that new business and analytical reports meet the needs of internal and external stakeholders
Work in collaboration with technical development and initiate service and system enhancements on behalf of the services to meet changing customer demand and in the development and maintenance of BI applications
Be highly organised and able to manage his/her own workload in response to changing demands and deadlines
Regularly audit own working practices, identify and implement changes to reflect improved ways of working
The post holder will be the lead analyst on specific projects and working groups
To support the delivery of new/enhanced reporting system developments assisting clinicians and providing training where appropriate
Ability to understand and interpret complex adhoc requests and respond appropriately to tight deadlines. This will entail the analysis, investigation and resolution of complex information issues
Develop training and guidance for clinicians to support data quality, data definitions and the use and interpretation of BI reporting
Ensure that all documentation produced is developed, maintained and published in accordance with departmental standards
Share knowledge and experience with other members of department on a regular basis
Ability to train and coordinate the work of junior staff in the department, including supervision
Using highly developed specialist knowledge of services to enable presentation of complex and contentious reports to clinical colleagues
Undertakes any other duties as required which are consistent with the grade and nature of the post
Demonstrates a proactive approach to responsibilities and exhibits ‘customer focused’ thinking
Management/Leadership responsibilities
Plan and manage the day-to-day work of post holder.
Line management of junior staff
Deputise for the Performance and Information Manager
Liaise with Business and Service Improvement Managers to ensure that all business and analytics reports meet their requirements
Assist Performance and Information Manager and Head of Data Services to meet department objectives
Leading in various meetings with different stakeholders
Responsible for owning and delivering a continuous training programme for the directorates and other areas of the Trust as appropriate
Ensure that all reporting protocols are documented
Devise best practice principles and assist in the implementation of these across the department
Communication and Collaboration
Strong communication and relationship skills are essential for this role.
The post holder will develop and maintain relationships with directorate colleagues such as business managers, support officers, service managers, and team leaders.
The post holder must have strong written communication skills to produce clear training materials and reports.
The post holder may liaise with BSU and local authority staff to address reporting queries. Hold meetings as needed across the organisation to manage data matters.
Delivers complex business and analytical information in various formats across the Trust and be able to a dapt communication to suit the audience.
Ensures that potentially contentious and sensitive information is clearly communicated especially where there may be barriers to understanding.
Regularly assesses directorate needs through research and surveys, then applies findings to enhance personal, Trust, and departmental performance.
General
To proactively manage and discharge the responsibilities of the post through organising own workload, priorities, and deadlines
To have a commitment to service improvement, effective change management and excellent communication skills
To have an understanding of health-related and service provision issues in all service directorates within Oxleas
To work in accordance with Trust Policies and Procedures at all times
Always follow the Trust’s Information Security Policy and avoid any actions that could breach confidentiality
To attend meetings as required
