Job summary
The post-holder will be expected to change, diagnose and fix problems with a wide range of reporting products; chiefly SQL Scripts and SSRS Reports.
They will work closely with other teams within Data Services to ensure that such changes are communicated effectively and do not impact on the day to day business.
Please see main duties of the job for further information along with full Job Description and Person Specification attached as supporting documentation.
*PREVIOUS APPLICANTS NEED NOT APPLY*
Main duties of the job
- Support the Performance and Information Manager.
- Support, apply technical fixes to and change Data Services reporting products, such as dashboards and database SQL scripts.
- Play a key role in advising on development processes.
- Look after the development and testing lifecycle of systems changes.
- Production of detailed technical documentation.
- Execution of other duties appropriate to the skills and experience of the post holder which may be identified by the manager.
- Take a proactive approach to developing own skills and experience.
- Work autonomously within professional and NHS guidelines, interpreting and acting on this interpretation as appropriate.
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
- Develop new and maintain existing bespoke ETL packages and applications.
- Advise on the software requirements for application development, and implement new software as required.
- Follow an appropriate development model when working on projects.
- Design and build systems in adherence with the Software Development Life Cycle making use of the Teams development, testing and live environment and deployment process.
- Work with Business Analysts and stakeholders to gather requirements for new applications.
- Create mock-ups, wireframes, and UML (Unified Modelling Language) diagrams that help visualise and construct new systems to assist in designing and explaining systems, data flows etc.
- Produce high standard technical and user documentation.
- Fix issues and bugs in products in the production environment
- Take responsibility for the development and testing lifecycle of systems changes.
- Play a key role in the development of the Trust's data warehouse.
- Ensure that all reports produced meet quality control requirements and are delivered on time.
- Recommend changes and improvements to processes and policies.
- Design and develop business and analytical reports, SQL Server objects such as t-SQL queries, tables, stored procedures, views, SQL Server Reporting Services objects, Integration Services packages
Job description
Job responsibilities
- Develop new and maintain existing bespoke ETL packages and applications.
- Advise on the software requirements for application development, and implement new software as required.
- Follow an appropriate development model when working on projects.
- Design and build systems in adherence with the Software Development Life Cycle making use of the Teams development, testing and live environment and deployment process.
- Work with Business Analysts and stakeholders to gather requirements for new applications.
- Create mock-ups, wireframes, and UML (Unified Modelling Language) diagrams that help visualise and construct new systems to assist in designing and explaining systems, data flows etc.
- Produce high standard technical and user documentation.
- Fix issues and bugs in products in the production environment
- Take responsibility for the development and testing lifecycle of systems changes.
- Play a key role in the development of the Trust's data warehouse.
- Ensure that all reports produced meet quality control requirements and are delivered on time.
- Recommend changes and improvements to processes and policies.
- Design and develop business and analytical reports, SQL Server objects such as t-SQL queries, tables, stored procedures, views, SQL Server Reporting Services objects, Integration Services packages
Person Specification
Qualifications & Experience
Essential
- Computer Science degree, or 5 year equivalent experience
- 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
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
Desirable
- Knowledge and understanding of GDPR
- Understanding of Clinical Information/Patient Management Systems or equivalent systems
Person Specification
Qualifications & Experience
Essential
- Computer Science degree, or 5 year equivalent experience
- 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
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
Desirable
- Knowledge and understanding of GDPR
- Understanding of Clinical Information/Patient Management Systems or equivalent systems
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).
