Job summary
The Business Intelligence Service at Gloucestershire Health and Care NHS Foundation Trust is looking for two Database Administrators which reports directly to the Data Warehouse Manager and deputises where required.
The first role will have a specific focus on the design of processes to pull data into the data warehouse from varied sources to generate data sets that can be used by a team of developers. This will require expert technical knowledge of SQL Server and SQL Server Integration Services (SSIS).
The second role will have a specific focus on the design of processes to pull data into the Exasol data engine and the creation of Tableau data sets. This will require expert technical knowledge of the Exasol product set. This role will also require a strong knowledge of SQL Server.
In both roles a familiarity with the NHS information environment, and Tableau Server would be an advantage.
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.
Main duties of the job
The post-holder will provide technical support and expertise to the Business Intelligence Team and wider organisation with regards to knowledge of the processes, structure, system and databases needed to generate reports, and be responsible for training and development.
Supports the Data Warehouse Manager and Data Development Manager by managing the day-to-day workload of the technical development business plan.
Assists the Data Warehouse Manager and Data Development Manager in corporate information functions.
The Database Administrator reports directly to the Data Warehouse Manager and deputises where required.
Has lead responsibility for the development and provision of information, analysis and data quality issues for specific care groups.
Line management responsibilities for the Business Intelligence Unit - Data Warehouse - Exasol/SQLServer function and associated structure.
The qualification, training & experience requirements for the role are underlined in the Job Description/Person Specification.
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
The Database Administrator is responsible for adapting and designing processes to support the provision of high-quality data for use within the organisation including the organisations BI Solution.This will include the development and implementation of the Business Intelligence technical architecture and associated system management.The post-holder will provide technical support and expertise to the Performance and Information Team and wider organisation with regards to knowledge of the processes, structure, system and databases needed to generate reports, and be responsible for training and development.
Job description
Job responsibilities
The Database Administrator is responsible for adapting and designing processes to support the provision of high-quality data for use within the organisation including the organisations BI Solution.This will include the development and implementation of the Business Intelligence technical architecture and associated system management.The post-holder will provide technical support and expertise to the Performance and Information Team and wider organisation with regards to knowledge of the processes, structure, system and databases needed to generate reports, and be responsible for training and development.
Person Specification
QUALIFICATIONS
Essential
- Educated to degree level in an IT related subject (or equivalent experience)
- Attended recognised professional training courses (e.g. SQL) or equivalent experience MCSA Database Administration, MSCE
Desirable
- Postgraduate qualification such as an MSc, MBA or other appropriate business, engineering or scientific qualification
- Data Management or similar ITIL Foundation Certificate (or equivalent experience) PRINCE2 or similar
LENGTH AND / OR NATURE OF EXPERIENCE
Essential
- Evidence of experience working with NHS information systems including data extraction and processing, information analysis and data validation
PROFESSIONAL / MANAGERIAL / SPECIALIST KNOWLEDGE
Essential
- Experience in designing Microsoft SQL Server databases
- Experience of implementing, optimising, maintaining and troubleshooting Microsoft SQL Server databases
- Importing data via Microsoft SQL Server Integration Services and other tools
- Knowledge of XML and HL7 processing amongst other data formats including the use of MESH
- Evidence of T-SQL, SSIS, SSRS and OLAP skills
- Knowledge of server specifications and maintenance
- Knowledge of compiling command prompts
Desirable
- An accredited course in NHS Informatics would be desirable
- Understanding of Clinical Governance and Information Governance requirements
PERSONAL SKILLS ABILITIES AND ATTRIBUTES
Essential
- Excellent numeric and analytical skills to degree level
- Excellent knowledge of NHS data definitions
- Ability to analyse complex information and present in a meaningful manner to staff
- Strong negotiation skills
- Excellent written, verbal and presentation skills
- Experience of multi-task working
- Ability to work under considerable pressure with conflicting and tight deadlines
- Training skills to pass on knowledge to team members
- Ability to undertake all statutory and mandatory training
OTHER REQUIREMENTS
Essential
- Ability to work as a Team player
- Proactive and innovative approach to development of ideas to improve the quality and effectiveness of the reporting databases
- Ability to work flexibly under pressure to tight deadlines
- Ability to travel locally
- Ability to work without direct supervision
- Able to attend and participate in all mandatory and statutory training events
Person Specification
QUALIFICATIONS
Essential
- Educated to degree level in an IT related subject (or equivalent experience)
- Attended recognised professional training courses (e.g. SQL) or equivalent experience MCSA Database Administration, MSCE
Desirable
- Postgraduate qualification such as an MSc, MBA or other appropriate business, engineering or scientific qualification
- Data Management or similar ITIL Foundation Certificate (or equivalent experience) PRINCE2 or similar
LENGTH AND / OR NATURE OF EXPERIENCE
Essential
- Evidence of experience working with NHS information systems including data extraction and processing, information analysis and data validation
PROFESSIONAL / MANAGERIAL / SPECIALIST KNOWLEDGE
Essential
- Experience in designing Microsoft SQL Server databases
- Experience of implementing, optimising, maintaining and troubleshooting Microsoft SQL Server databases
- Importing data via Microsoft SQL Server Integration Services and other tools
- Knowledge of XML and HL7 processing amongst other data formats including the use of MESH
- Evidence of T-SQL, SSIS, SSRS and OLAP skills
- Knowledge of server specifications and maintenance
- Knowledge of compiling command prompts
Desirable
- An accredited course in NHS Informatics would be desirable
- Understanding of Clinical Governance and Information Governance requirements
PERSONAL SKILLS ABILITIES AND ATTRIBUTES
Essential
- Excellent numeric and analytical skills to degree level
- Excellent knowledge of NHS data definitions
- Ability to analyse complex information and present in a meaningful manner to staff
- Strong negotiation skills
- Excellent written, verbal and presentation skills
- Experience of multi-task working
- Ability to work under considerable pressure with conflicting and tight deadlines
- Training skills to pass on knowledge to team members
- Ability to undertake all statutory and mandatory training
OTHER REQUIREMENTS
Essential
- Ability to work as a Team player
- Proactive and innovative approach to development of ideas to improve the quality and effectiveness of the reporting databases
- Ability to work flexibly under pressure to tight deadlines
- Ability to travel locally
- Ability to work without direct supervision
- Able to attend and participate in all mandatory and statutory training events
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).
