CS Interview Coach

Senior Database Manager

UK Health Security Agency

Department
UK Health Security Agency
Location
Colindale- Scientific Campus
Openings
1 post
Grade
SEO
Salary
£46,310 to £52,113
Closing
12 days left
Profession
Science
Contract
Permanent, Loan, Secondment
Security clearance
OTHER
Working pattern
Flexible working, Full-time, Job share, Part-time
Apply on Civil Service Jobs

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.

Working for your organisation

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

What they’re looking for

  • 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 an a health related organisation and/or in communicable disease epidemiology
  • Knowledge of Data Protection laws and the importance of maintaining security and confidentiality

Job description

The Senior Database Manager will:

  • Be involved in the design, delivery, and improvement of databases, on- premise and also 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 an 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

  • In addition to the job specific requirements above, this role will require adherence to all UKHSA Policies and Procedures. A full list of these are available on UKHSA Intranet and form part of the employment contract
  • 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

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.

Selection process

We are dedicated to providing equal opportunities for all, and are proud participants in the following initiatives:

  • Disability Confident Scheme (opens in new window).
  • Great Place to Work for Veterans (opens in a new window).
  • Prison Leavers Scheme (opens in a new window).

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

Stage 1: Application & Sift

Competency Based

You will be required to 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, experience and 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 be advised you 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 of a large number of applications, 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 of a large number of applications we will conduct an initial sift, 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 used in the event of a large number of applications or large amount of successful candidate

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 Civil Service as well as internal applicants.

If this role is fixed term and you are not currently a Civil Servant, you will take up the post on a Fixed Term appointment; you may be able to take this role up as a Secondment. If you are an existing Civil Servant, based outside of UKHSA, you will take up the post as a loan which you will need your department to agree. Loans are normally agreed for a period of two years. However, this may be extended where required, subject to agreement between UKHSA and your home department. You cannot take the post up as a fixed term. If you are an existing UKHSA member of staff, you will take up the post as either a level transfer or a temporary promotion as per the UKHSA’s Pay policy. If this role is permanent, it may also be available as a loan (for existing Civil Servants only) or secondment arrangement, subject to business need and agreement from the hiring manager and, where applicable, the employee's home organisation.

Reserve List

If more than the required number of suitable candidates pass the interview criteria, you may be kept on a reserve list for 12 months subject to your agreement. You may be contacted, in merit-order, if similar roles with closely matching essential criteria become available and the department choose to appoint from a reserve list.

The panel will assess if candidates meet the requirement of the role first, using a specific benchmark system. If you are interviewed for the post and do not meet the required threshold for the specified grade, your application may be assessed against a similar, lower grade role and you may be offered the post should one be available.

Incident Response Activity

From time to time, the role holder may be required to support UKHSA’s incident response activity by contributing their appropriate expertise within an Incident Cell; during such periods, supported by the line manager, this work will take priority over normal day-to-day responsibilities, commensurate with their grade, skills and experience.

Qualifications and Registrations

For roles where specific qualifications or registrations are required, successful applicants will be asked to provide appropriate evidence. Employment cannot commence until satisfactory documentation has been received and verified.

Future location

UKHSA is investing in a new state-of-the-art National Biosecurity Centre in Harlow, Essex, which will eventually bring together teams currently based at Canary Wharf, Colindale and Porton Down. For more details, please see: Huge biosecurity centre investment to boost pandemic protection - GOV.UK

The new facilities will start becoming operational in the mid-2030s, with full completion by 2038. Staff will move in phases as facilities become available. If you're appointed to a role currently based at Canary Wharf, Colindale or Porton Down, please note that we'll continue investing in these sites for the next decade. As we get closer to the transition, we'll provide full information about relocation support available to staff.

Reasonable Adjustments

The Civil Service is committed to making sure that our selection methods are fair to everyone. To help you during the recruitment process, we will consider any reasonable adjustments that could help you. An adjustment is a change to the recruitment process or an adjustment at work. This is separate to the Disability Confident Scheme. If you need an adjustment to be made at any point during the recruitment process you should contact the recruitment team in confidence as soon as possible to discuss your needs.

You can find out more information about reasonable adjustments across the Civil Service here: Reasonable Adjustments , Civil Service Careers

International Police check

If you have spent more than 6 months abroad over the last 3 years you may need an International Police Check.This would not necessarily have to be in a single block, and it could be time accrued over that period.

Internal Fraud Check

If successful for this role as one aspect of pre-employment screening, applicant’s personal details – name, national insurance number and date of birth - will be checked against the Cabinet Office Internal Fraud Hub, and anyone included on the database will be refused employment unless they can show exceptional circumstances. Currently this is only for external candidates to the Civil Service.

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.

Feedback will only be provided if you attend an interview or assessment.

Practise before you apply

Civil Service panels score every answer against the Success Profiles behaviours at SEO level. Practise STAR answers and get them marked against the same framework.

Start practising free

3 free questions · No card needed

Similar vacancies

Interview articles for SEO roles

All articles

Browse more like this