Job summary
The Business Intelligence Service at Gloucestershire Health and Care NHS Foundation Trust is looking for a Senior Data Developer to join our team to advance and maintain the data processes for our high-quality reports and dashboards.
In this interesting and rewarding role, you will take responsibility developing specific data sets and data sources. You will also assist with implementing Business Intelligence Reporting Tools and be required to line manage (an)other member(s) of the team.
If you have an eye for detail, appreciate the role of data in health care and can translate technical concepts into non-technical language, this is the role for you.
Please note that the majority of the time the work will be from home.
Main duties of the job
The role will have a specific focus on the design of processes to pull data together from varied sources to generate information that can be used by a team of analysts. This will require a working knowledge of SQL Server. Familiarity with the NHS information environment, SQL Server Integration Services (SSIS) and/or Tableau Server would be an advantage.
The post holder will develop and maintain processes to support the provision of high-quality data for use within the organisation, including the organisation's BI solutions and manages the production of highly complex data from clinical and corporate systems to (help) produce reports and dashboards.
o Develop and maintain the automated processes for extracting, transforming, loading and disseminating data in-line with organisational requirements.o Support the Data Warehouse Manager in development, optimisation, management and troubleshooting of the organisation's Microsoft SQL Server estate.o Aid in the efficient design and implementation of new data sources.o Deliver expert technical knowledge in support of the organisation's SQL Estate, databases and data flow processes.o Identify problems and inconsistencies within complex datasets and identify solutions.o Identifying current gaps in information provision through close working with BI Analysis and other stakeholderso Manage, motivate and inspire team members, investing time in their development
About us
We have in excess of 5000 staff working over 50 sites, providing a diverse range of services. We strive to support an organisational culture that is welcoming, builds and celebrates inclusivity and diversity and provides a sense of belonging and trust.
The annual NHS Staff Surveygives our people the opportunity to tell us about their experience working at the Trust. For the 2023 survey just over 2800 colleagues gave us their views (58.5%). It was great to see from the results that colleagues are saying that:
- 89.7% believe they are making a positive difference to patients/service users;
- 73.3% would recommend the organisation as a place to work;
- 82.4% agree that care of patients and service users is the organisations priority;
- 76.7% would be happy with the standard of care for a friend or relative
Our results put us as 5th nationally as a Community, Mental Health and Learning Disabilities NHS Employer of Choice and 1st equal amongst all NHS Provider Trusts in the South West. However, we know we have more to do and will continue to drive forward our commitment to making GHC a Great Place to Work.
Job description
Job responsibilities
Gloucestershire Health and Care is committed to embedding and providing personalised care through all of its services as part of our high-quality care strategy. The purpose of personalised care is to empower people to lead the lives they want to live. Personalised care starts with a conversation with people about what matters to them. It builds on what people can do, as well as addressing their health needs. Including new ways of working and delivering care, emphasising that we need to make effective use of the full range of our peoples skills and experience to deliver the best possible patient care. So we want to know What Matters to You and that you will share our values and join us on this very important journey.
The qualification, training & experience requirements for the role are underlined in the Job Description/Person Specification.
Job description
Job responsibilities
Gloucestershire Health and Care is committed to embedding and providing personalised care through all of its services as part of our high-quality care strategy. The purpose of personalised care is to empower people to lead the lives they want to live. Personalised care starts with a conversation with people about what matters to them. It builds on what people can do, as well as addressing their health needs. Including new ways of working and delivering care, emphasising that we need to make effective use of the full range of our peoples skills and experience to deliver the best possible patient care. So we want to know What Matters to You and that you will share our values and join us on this very important journey.
The qualification, training & experience requirements for the role are underlined in the Job Description/Person Specification.
Person Specification
QUALIFICATIONS
Essential
- Graduate, degree, diploma or equivalent, relevant experience
- Formal Project Management qualification or similar experience
- Evidence of continued professional development
LENGTH AND / OR NATURE OF EXPERIENCE
Essential
- Experience of working in an NHS (or similar) information management team; including data extraction and processing, information analysis and data validation
- Experience of working as an Information of Data Analyst/Developer/ Architect (or equivalent) in a NHS information management team
PROFESSIONAL / MANAGERIAL / SPECIALIST KNOWLEDGE
Essential
- Experience in designing Microsoft SQL Server databases
- Experience of implementing, optimising, maintaining and troubleshooting Microsoft SQL Server databases
- Experience of importing data via Microsoft SQL Server Integration Services and other tools
- Has an awareness of political and other external influences on the health industry and/or use of information
- Competent in the use of data analysis software and other relevant computer systems including standard Microsoft products
- Ability to consider problems and link issues in a broad context and look beyond the immediate situation
- Ability to demonstrate complex data issues, negotiate and be prepared to justify or defend their position when required
- Excellent planning and organisational skills to co-ordinate a complex workload and balance key deliverables which may at times be conflicting. This may involve re-allocating or re-prioritising tasks and forward planning where possible
- Detailed understanding and experience of NHS Planning, Performance Management and Commissioning processes as well as the NHS Data Model and routine central returns
Desirable
- Has managerial experience
- Knowledge of XML and HL7 processing amongst other data formats including the use of MESH
- Evidence of T-SQL, SSIS, SSRS and OLAP skills
- Knows Tableau
- Knowledge of server specifications and maintenance
- Knowledge of compiling command prompts
- Has an accredited course in NHS Informatics
Person Specification
QUALIFICATIONS
Essential
- Graduate, degree, diploma or equivalent, relevant experience
- Formal Project Management qualification or similar experience
- Evidence of continued professional development
LENGTH AND / OR NATURE OF EXPERIENCE
Essential
- Experience of working in an NHS (or similar) information management team; including data extraction and processing, information analysis and data validation
- Experience of working as an Information of Data Analyst/Developer/ Architect (or equivalent) in a NHS information management team
PROFESSIONAL / MANAGERIAL / SPECIALIST KNOWLEDGE
Essential
- Experience in designing Microsoft SQL Server databases
- Experience of implementing, optimising, maintaining and troubleshooting Microsoft SQL Server databases
- Experience of importing data via Microsoft SQL Server Integration Services and other tools
- Has an awareness of political and other external influences on the health industry and/or use of information
- Competent in the use of data analysis software and other relevant computer systems including standard Microsoft products
- Ability to consider problems and link issues in a broad context and look beyond the immediate situation
- Ability to demonstrate complex data issues, negotiate and be prepared to justify or defend their position when required
- Excellent planning and organisational skills to co-ordinate a complex workload and balance key deliverables which may at times be conflicting. This may involve re-allocating or re-prioritising tasks and forward planning where possible
- Detailed understanding and experience of NHS Planning, Performance Management and Commissioning processes as well as the NHS Data Model and routine central returns
Desirable
- Has managerial experience
- Knowledge of XML and HL7 processing amongst other data formats including the use of MESH
- Evidence of T-SQL, SSIS, SSRS and OLAP skills
- Knows Tableau
- Knowledge of server specifications and maintenance
- Knowledge of compiling command prompts
- Has an accredited course in NHS Informatics
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
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).