Senior Database Manager

Job summary

The post holder will be responsible for developing and maintaining SQL-databases to enable the data processes within the Bacterial Vaccine Section of the Immunisation and Vaccine-Preventable Diseases Division, and data flows to other parts of the organisation.

The successful applicant will have an understanding of health informatics, information technology, and knowledge of data services and working with standards, as well as knowledge of information governance and project assurance. The post-holder should be able to demonstrate knowledge of suitable statistical platforms and/or programming languages (e.g. R, STATA, python etc), as well as existing software (e.g. MS Access) and a thorough understanding and practical knowledge of SQL.

The role will require well developed and demonstrable written and analytical skills. The post-holder must have excellent interpersonal skills and an ability to work effectively both autonomously and within a team. The post-holder will also be responsible for contributing to the strategic direction of the research and surveillance activities.

Main duties of the job

  • Lead on the design, implementation and management of databases to handle data flows securely and efficiently
  • Navigating and negotiating data access issues
  • Work with colleagues to identify key variables to link records involving a combination of formal identifiers (e.g. NHS numbers) and informal variables (e.g. sex, age etc.), and where possible, identify additional information to inform the linkage
  • Lead on assessing the accuracy and completeness of health record data as well as cleaning and standardizing the datasets
  • Work with the scientific team and other team members in identifying and implementing deterministic and probabilistic linkage algorithms, and adapting suitable data linkage methodologies and assessing the scalability of the techniques
  • Address key issues with record linkage including data divergence, redundancy and data overlap
  • Participate in the longitudinal analysis of surveillance data to address complex research questions
  • Demonstrate knowledge of suitable statistical platforms (e.g. R, STATA etc.) and/or programming languages (e.g. python etc) to enable large scale data manipulation as well as a thorough understanding and practical knowledge of SQL.
  • Contribute to the strategic direction of surveillance activities, with a focus on research outcomes including developing and piloting new methods of health record data linkage.
  • Contribute to the development of research proposals under the guidance of the project lead

Please note, the above is not exhaustive.

About us

We pride ourselves as being an employer of choice, where Everyone Matters promoting equality of opportunity to actively encourage applications from everyone, including groups currently underrepresented in our workforce.

UKHSA ethos is to be an inclusive organisation for all our staff and stakeholders. To create, nurture and sustain an inclusive culture, where differences drive innovative solutions to meet the needs of our workforce and wider communities. We do this through celebrating and protecting differences by removing barriers and promoting equity and equality of opportunity for all.

Please visit our careers site for more information https://gov.uk/ukhsa/careers

Job description

Job responsibilities

THE SENIOR DATABASE MANAGER WILL

-Be involved in the design, delivery, and improvement of databases, on- premise and on public cloud infrastructures, as well as integration of the new technologies.-Work with colleagues to design and manage pragmatic solutions to meet urgent needs in an agile way, with a focus on balancing tactical delivery and reusability. -Provide technical expertise to support the delivery of end-to-end data architecture that will rationalise and enhance the sourcing of, ingestion, transportation, processing, storage, and analysis of data.-Utilise best practises to optimise health security and protection activities on secure and access-controlled capability.-Work with colleagues and multidisciplinary teams across the organisation rapidly gaining an in depth understanding and knowledge of the database needs of the Immunisation and Vaccine Preventable Diseases Division and the existing platforms (which include legacy Microsoft Access databases), content, structure and operability of the current complex systems, interlinking programs and routines, the data and underlying processes and then apply that detailed knowledge to be able to strengthen the processes and support the optimisation of the capability.-Work alongside other data managers and SQL specialists with epidemiologists and scientists with differing levels of technical ability to support their transition into new working environments.

COMMUNICATION AND KEY WORKING RELATIONSHIPS

INTERNAL

-Other members of the Immunisation and Vaccine Preventable Diseases Division.-Members of other divisions within the Data Operations Directorate and the wider Data, Analytics and Surveillance Group with whom you may collaborate on local and national work programmes.-Colleagues working in other UKHSA Groups, especially surveillance system technical leads, health protection specialists and colleagues within the Technology Group.-Public health colleagues working in local authorities, particularly those working in health protection roles.-Colleagues in the Department of Health and Social Care and other Government Departments.-Colleagues working in NHS England and Improvement, NHS Digital, NHS X and local Clinical Commissioning Groups-Colleagues in Office for National Statistics (ONS), NHS England (formerly NHS Digital) and other external data providers

-Members of the government statistical service

EXTERNAL

-Public health colleagues working in local authorities, particularly those working in health protection roles.-Colleagues working in local Clinical Commissioning Groups-Colleagues in Office for National Statistics (ONS) and other external data providers.

- Other external partners relevant to the work of UKHSA

OTHER INFORMATION

-This role will require adherence to all UKHSA Policies and Procedures.-All staff will adhere to the UKHSA People Charter actively demonstrating the positive behaviours-All staff are expected to contribute to the delivery of corporate goals and objectives-The role holder may be expected to support corporate service activity as set out in the Corporate Services Standard Operating Procedures-As a Category 1 responder under the Civil Contingencies Act 2004, UKHSA has a set of civil protection responsibilities which it must fulfil in the response to any emergency or major incident. Staff may be asked to contribute to the preparedness for and response to major incidents and emergencies (as defined in the UKHSA Concept of Operations) as required-This document provides an outline of the tasks, responsibility and outcomes required of the role. The job holder will carry out any other duties that may reasonably be required by their line manager-The job description and person specification may be reviewed on an ongoing basis in accordance with the changing needs of the team, Directorate and the Organisation

ESSENTIAL CRITERIA

-A first- or second-class honours degree in a numerate discipline, computer science or IT equivalent which demonstrates core statistical skills or have worked in a statistical/data science field and are able to demonstrate continuous professional development in statistics/data science at the same level as a foundation degree/HND (Level 5)-High standard of data management, analysis and producing reports-Experience of database management systems (including SQL)-Experience of health record data linkage-Experience with existing record linkage tools (deterministic and/or probabilistic)-Experience in the analysis and interpretation of complex datasets-Knowledge and experience of a statistical software package (R/STATA/SAS etc.)

DESIRABLE CRITERIA

-Working in a health related organisation and/or in communicable disease epidemiology-Knowledge of Data Protection laws and the importance of maintaining security and confidentiality

SELECTION PROCESS DETAILS

This vacancy will be assessed using a competency-based framework which will assess your qualifications,knowledgeand experience and / or skills and abilities outlined in the essential criteria.

STAGE 1 APPLICATION & SIFT

COMPETENCY BASED

You willbe requiredto complete an application form. You will be assessed on the listed 7 essential criteria, and this will be in the form of a-Application form (Employer/ Activity history section on the application)-750 word supporting statement.

This should outline how you consider your skills, experienceand knowledge provide evidence of your suitability for the role, with reference to the essential criteria.You will receive a joint score for your application form and statement. (The application form is the kind of information you would put into your C.V please beadvisedyou will not be able to upload your CV. Please complete the application form in as much detail as possible). Please do not email us your CV.

Healthjobs UK has a word limit of 1500, but your supporting statement must be no more than 750 words. We will not consider any words over 750 words.

LONGLISTING

In the event ofa large number ofapplications,we will longlist into 3 piles of

-Meets all essential criteria-Meets some essential criteria-Meets no essential criteria

If used, the pile(s) Meets all essential criteria will proceed to shortlisting.SHORTLISTING

In the event ofa large number ofapplications we will conductan initialsift, on the lead criteria of

-High standard of data management, analysis and producing reports-Experience of database management systems (including SQL)

Desirable criteria may be usedin the event ofa large number of applications or large amount of successful candidates.

If you are successful at this stage, you will progress to interview & assessment.

Feedback will not be provided at this stage.

STAGE 2 INTERVIEW

COMPETENCY BASED

You will be invited to a single face to face interview in Colindale.Knowledge, experience, skills & abilities will be tested at interview.

You will be required to complete a technical assessment where you will be provided with a test database schema and a problem to consider.

You will have 30 minutes to prepare your solution, which you will then be asked to talk through during the interview.

Interview dates to be confirmed.

Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

LOCATION

This role is being offered as hybrid working based at our Scientific Campus in Colindale.

We offer great flexible working opportunities at UKHSA and operate using a hybrid working model where business needs allow. This provides us with greater flexibility about how and where we work, to get the best from our workforce. As a hybrid worker, you will be expected to spend a minimum of 60% of your contractual working hours (approximately 3 days a week pro rata, averaged over a month) working at our campus.

When based at our scientific campus, you will be required to have a minimum of a Counter Terrorism Check security vetting check as a minimum. For meaningful National Security Vetting checks to be carried out individuals need to have lived in the UK for a sufficient period of time. You should normally have been resident in the United Kingdom for the last 3 years as the role requires Counter Terrorism Check (CTC) clearance. In exceptional circumstances UK residency less than the outlined periods may not necessarily bar you from gaining national security vetting and applicants should contact the Vacancy Holder/Recruiting Manager listed in the advert for further advice.

SECURITY CLEARANCE LEVEL REQUIREMENT

Successful candidates must pass a basic disclosure and barring security check before they can be appointed.Successful candidates must meet the security requirements before they can be appointed. The level of security needed is Counter-Terrorist Check.

ELIGIBILITY CRITERIA

This vacancy is open to all external applicants (anyone) from outside the CivilService as well as internal applicants.

SALARY INFORMATION

If you are successful at interview, and are moving from another government department, NHS, or Local Authority, the relevant starting salary principles for level transfers or promotions will apply. Otherwise, roles are offered at the pay scale minimum for the grade, but in exceptional circumstances there may be flexibility if you are able to demonstrate you are already in receipt of an existing, higher salary. Pay increases are through the relevant annual pay award for the role and terms.



Person Specification

Application and supporting statement

Essential
  • Application and supporting statement

Essential Criteria

Essential
  • Questions on experience, knowledge and skills

Technical Assessment

Essential
  • Technical Assessment

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.

Certificate of Sponsorship

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.

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.

Employer details

Employer name

UK Health Security Agency

Address

Scientific Campus

Colindale

NW9 5EQ

United Kingdom

Employer's website

https://www.gov.uk/government/organisations/uk-health-security-agency

Job Details

Company
UK Health Security Agency
Location
Colindale, NW9 5EQ, United Kingdom
Hybrid / Remote Options
Salary
£46310.00 to £52113.00
Posted