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).
Main duties of the job
* 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
* 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
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 Listen
* We Care
Job responsibilities
* 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 adapt 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 Trusts Information Security Policy and avoid any actions that could breach confidentiality
* To attend meetings as required
Person Specification
Education/Qualifications
* Masters Degree or Equivalent
Experience
* 3-5 years Experience
* External Data Collections/Submissions MHSDS, CSDS, NHSE etc
Technical Skills
* SQL Server
* SSRS, SSAS, SSIS
* PowerBI
* MS Office
* IT Systems and Databases
Other Skills
* Management/planning/organisational skills
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.
#J-18808-Ljbffr