Job summary
Within Lincolnshire Partnership Foundation Trust, we are seeking to recruit a SQL Developer. You will be working in a team responsible for producing user friendly, innovative and high quality outputs within the trusts various systems, namely the trust's electronic patient record, RiO.
This role has a focus on the further development of our clinical system, Rio. You will be ensuring that Rio keeps pace with any organisational changes as well as developing innovative new ways of displaying and reporting data in the patient record in the system.
The ideal candidate would have the following:
- Experience of tailoring developments to customer requirements
- A good understanding of SQL (Advanced Support available to the right candidate)
- Experience of Working in an NHS environment advantageous
For further information please contact: Samuel Bowker on S.Bowker1@nhs.net
Main duties of the job
Write SQL scripts to develop reports and new functionality within our clinical systems.
Responsible for engaging and supporting the future design of the trust's electronic patient record (EPR) in terms of locally configured reports and functionality within data presentation screens, acting as a system expert and designer making recommendations based on systems knowledge.
Actively seek out new ideas and challenge the boundaries of the EPR functionality through engagement with operational services, analyst function and corporate services, ensuring EPR Developments are fit for purpose meeting local and national care and contracting guidelines.
To analyse and document business requirements for large and or complex areas, working with colleagues across the organisation.
To identify the key business requirements of stakeholders/customers, prepare functional specifications and develop the system to meet these specifications.
To complete complex and technical developments within the EPR as per the agreed specification.
The post holder will provide practical advice and demonstration to front line workers and administration staff.
Line management of colleagues.
The post holder will promote data quality within clinical and admin teams working within Lincolnshire Partnership NHS Foundation Trust.
About us
Lincolnshire Partnership NHS Foundation Trust provides mental health services and a number of learning disability, autism and social care services in the county of Lincolnshire. Employing around 2,900 staff, and serving a population of over 768,400, our people lie at the heart of everything we do.
You could be part of a Trust rated by staff as one of the best mental health and learning disability trusts in England. We firmly believe the key to high quality care is a contented workforce. This is reflected in our Care Quality Commission rating of 'outstanding' for well-led and 'good' overall. In the most recent National NHS Staff Survey, our staff rated us as the number one trust nationally for staff morale and one of the top scoring NHS Trusts in the Midlands for being compassionate and inclusive. We're really proud of this!
We offer options for flexible working and provide a wide range of training and promotion opportunities in all professions. We support and celebrate diversity, have active staff networks groups and are always looking at what more we can do to support our staff.
Whether you're taking the first exciting steps in your career, itching for a new challenge or searching for a better place to raise a family, Lincolnshire has arange of rewarding health and social care careers in a county that's friendly, fascinating, affordable and brimming with everything you need to live a happy life.Visitbeinlincolnshire.comto find out more.
Job description
Job responsibilities
Leadership
To provide practical training to staff at all levels in direct relation to role
To promote the value and importance of the EPR and the data warehouse in day to day contact with stakeholders
To lead reporting developments within the EPR, creating specifications and making recommendation to suit business and clinical need.
To, when required, allocate and monitor the work of more junior staff in the Informatics Service
To develop and maintain EPR Development and Data Warehouse Documentation as appropriate
To facilitate working relationships across different functions of the Informatics service to ensure joint working and close understanding of issues and priorities
To understand business need and clinical need and make recommendations to staff on how this should be reflected in EPR Reporting Developments.
To line manage colleagues as appropriate to the role
Information Management
To develop and maintain the skills required to complete EPR Development
To develop and maintain the SQL skills required to support database and dashboard development.
To develop and maintain an understanding of the tools utilised to build workflows, forms and various other developments within the Trusts EPR systems to support the EPR Development Officer role as required
To develop and maintain and understanding of the trusts data warehouse structure and clinical systems database structure to be able to effectively query data and develop reports.
To create EPR workflows and system automations requiring technical system administration input. Designing these to support clinical staff with effective use of the EPR to support clinical processes.
To develop and maintain an understanding of the role of Business Intelligence (BI) in the organisation. How this impact can be captured and promoted through the EPR.
To support the development of Trusts EPR to ensure the specification meets the needs of the organisation
To support managers and clinicians in their use and interpretation of information presented via the EPR.
Understanding the needs and keeping up to date with the requirements of frontline services in respect of system requirements and automation.
Information Governance and Security
To lead and maintain robust SOPs and change management procedures for the development, design, build and edit of automated processes
To liaise with EPR System Suppliers to ensure that developments make best use of the system functionality.
To support the maintain of data warehouse documentation and change management processes.
To protect sensitive and confidential information in accordance to local practices when developing and presenting data reports using SQL.
To adhere to strategies and policies to ensure compliance with relevant legislation and other standards aimed at ensuring the confidentiality, integrity and availability of information
You may occasionally be asked to undertake such other duties that are deemed necessary in order to support business continuity within the Trust. This will only include tasks where you are appropriately trained
Job description
Job responsibilities
Leadership
To provide practical training to staff at all levels in direct relation to role
To promote the value and importance of the EPR and the data warehouse in day to day contact with stakeholders
To lead reporting developments within the EPR, creating specifications and making recommendation to suit business and clinical need.
To, when required, allocate and monitor the work of more junior staff in the Informatics Service
To develop and maintain EPR Development and Data Warehouse Documentation as appropriate
To facilitate working relationships across different functions of the Informatics service to ensure joint working and close understanding of issues and priorities
To understand business need and clinical need and make recommendations to staff on how this should be reflected in EPR Reporting Developments.
To line manage colleagues as appropriate to the role
Information Management
To develop and maintain the skills required to complete EPR Development
To develop and maintain the SQL skills required to support database and dashboard development.
To develop and maintain an understanding of the tools utilised to build workflows, forms and various other developments within the Trusts EPR systems to support the EPR Development Officer role as required
To develop and maintain and understanding of the trusts data warehouse structure and clinical systems database structure to be able to effectively query data and develop reports.
To create EPR workflows and system automations requiring technical system administration input. Designing these to support clinical staff with effective use of the EPR to support clinical processes.
To develop and maintain an understanding of the role of Business Intelligence (BI) in the organisation. How this impact can be captured and promoted through the EPR.
To support the development of Trusts EPR to ensure the specification meets the needs of the organisation
To support managers and clinicians in their use and interpretation of information presented via the EPR.
Understanding the needs and keeping up to date with the requirements of frontline services in respect of system requirements and automation.
Information Governance and Security
To lead and maintain robust SOPs and change management procedures for the development, design, build and edit of automated processes
To liaise with EPR System Suppliers to ensure that developments make best use of the system functionality.
To support the maintain of data warehouse documentation and change management processes.
To protect sensitive and confidential information in accordance to local practices when developing and presenting data reports using SQL.
To adhere to strategies and policies to ensure compliance with relevant legislation and other standards aimed at ensuring the confidentiality, integrity and availability of information
You may occasionally be asked to undertake such other duties that are deemed necessary in order to support business continuity within the Trust. This will only include tasks where you are appropriately trained
Person Specification
Qualifications
Essential
- Relevant ICT qualifications at degree level or equivalent demonstrable experience
- Relevant ICT qualifications at degree level or equivalent demonstrable experience
Desirable
- Evidence of ongoing personal development
- Evidence of training in Mental Health EPRs
Experience
Essential
- Experience of working in an health or social care setting
- Experience of transforming business requirements into a specification for development.
- Experience of developing custom screen/reports to suit business need.
- Experience of development of reports to present data clearly to a non-technical audience
- Ability to read and write SQL to an intermediate level
- Knowledge of confidentiality, system security and Data Protection
- An understanding of a relational database and their schemas
- Experience of understanding clinical pathways and translation into EPR Data Capture
- Evidence of teaching/training others
Desirable
- Experience working in Informatics
- Experience of working within NHS Mental Health
- Experience of working with Servelec RiO EPR.
- Experience working with PowerBI
- Experience of writing HTML5 code or CSS.
- Experience of change management and change control processes.
- Line management experience
Skills
Essential
- Experience of supporting organisational change & in the improvement of business processes through EPR Development
- Knowledge and experience of Microsoft office applications
Desirable
Speical requirements
Essential
- Ability to travel to LPFT bases across the Trust at short notice and nationally for relevant training and user forums
Person Specification
Qualifications
Essential
- Relevant ICT qualifications at degree level or equivalent demonstrable experience
- Relevant ICT qualifications at degree level or equivalent demonstrable experience
Desirable
- Evidence of ongoing personal development
- Evidence of training in Mental Health EPRs
Experience
Essential
- Experience of working in an health or social care setting
- Experience of transforming business requirements into a specification for development.
- Experience of developing custom screen/reports to suit business need.
- Experience of development of reports to present data clearly to a non-technical audience
- Ability to read and write SQL to an intermediate level
- Knowledge of confidentiality, system security and Data Protection
- An understanding of a relational database and their schemas
- Experience of understanding clinical pathways and translation into EPR Data Capture
- Evidence of teaching/training others
Desirable
- Experience working in Informatics
- Experience of working within NHS Mental Health
- Experience of working with Servelec RiO EPR.
- Experience working with PowerBI
- Experience of writing HTML5 code or CSS.
- Experience of change management and change control processes.
- Line management experience
Skills
Essential
- Experience of supporting organisational change & in the improvement of business processes through EPR Development
- Knowledge and experience of Microsoft office applications
Desirable
Speical requirements
Essential
- Ability to travel to LPFT bases across the Trust at short notice and nationally for relevant training and user forums
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.
