Job summary
The post holder is responsible for timely issue resolution in existing products across various technologies, from simple to complex systems such as SQL queries, SSRS reports and data flow packages.
They will also contribute to technical development improvements, maintain technical documentation, and perform additional duties as assigned by the manager.
Main duties of the job
-
Support the Business Intelligence Systems Manager.
-
Work closely with stakeholders to understand and resolve issues, and to deliver change to existing products.
-
Support, apply technical fixes and change to Data Services reporting products, such as ETL packages, reports & dashboards and database objects.
-
Play a key role in advising on development processes.
-
Look after the development and testing lifecycle of systems changes.
-
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
-
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
-
Work on own initiative within professional guidelines to achieve agreed objectives.
-
Devise best practice principles and assist in their implementation.
-
Regularly audit own working practices and implement changes for improvement.
-
Shares knowledge and best practices with colleagues.
-
Demonstrates a proactive approach and 'customer-focused' thinking.
-
Communicates effectively in writing and verbally with internal and external stakeholders.
-
Collaborating with colleagues and stakeholders to troubleshoot and resolve issues with products.
-
Guide and advise Data Services colleagues to adopt new and best practices
-
Take a proactive approach to developing own skills and experience and that of others.
-
Recommends changes and improvements to processes and policies.
-
Ensure that all reporting protocols are documented.
-
Ensure appropriate action is taken to resolve anomalies found within the reports produced.
-
Undertake any other duties as required which are consistent with the grade and nature of the post.
-
Lead role in advising, guiding and supporting colleagues.
-
Liaise with Data Services team to ensure that systems developments and associated reports meet the needs of the Trust.
-
Deliver regular technical training to the Data Services team and other relevant areas.
-
Supervise junior colleagues and manage projects.
Job description
Job responsibilities
-
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
-
Work on own initiative within professional guidelines to achieve agreed objectives.
-
Devise best practice principles and assist in their implementation.
-
Regularly audit own working practices and implement changes for improvement.
-
Shares knowledge and best practices with colleagues.
-
Demonstrates a proactive approach and 'customer-focused' thinking.
-
Communicates effectively in writing and verbally with internal and external stakeholders.
-
Collaborating with colleagues and stakeholders to troubleshoot and resolve issues with products.
-
Guide and advise Data Services colleagues to adopt new and best practices
-
Take a proactive approach to developing own skills and experience and that of others.
-
Recommends changes and improvements to processes and policies.
-
Ensure that all reporting protocols are documented.
-
Ensure appropriate action is taken to resolve anomalies found within the reports produced.
-
Undertake any other duties as required which are consistent with the grade and nature of the post.
-
Lead role in advising, guiding and supporting colleagues.
-
Liaise with Data Services team to ensure that systems developments and associated reports meet the needs of the Trust.
-
Deliver regular technical training to the Data Services team and other relevant areas.
-
Supervise junior colleagues and manage projects.
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)
- Troubleshooting and issue resolutions using reverse engineering and diagnosing skills
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)
- Troubleshooting and issue resolutions using reverse engineering and diagnosing skills
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).
