UK Health Security Agency

Database Manager

Information:

This job is now closed

Job summary

This post is primarily based within the TB Unit and is within the Travel, acute respiratory, zoonoses and emerging infections and Tuberculosis (TARZET) Division of the UKHSA Clinical and Public Health Group based on the Colindale site.

The Database Manager will work under the Database Developer and with the team of scientists in TARZET, led by Principal Scientists and under the direction of the Head of the TB Unit. You will manage and develop key information systems in the TB Unit, including database management of national surveillance of tuberculosis and other mycobacteria of public health importance. You will also contribute to the further development of the information systems, supporting system users across TARZET. You will also work with colleagues in TARZET to introduce a quality management system for Information Governance.

The TB Unit has brought together clinical and scientific leads for Tuberculosis across different Divisions within the Clinical and Public Health Group, and the post holder will work within a fully integrated Unit to forge stronger functional partnerships with colleagues in UKHSA, the NHS and international leads for TB.

Main duties of the job

  • Manage the database and associated data warehouses of the National Tuberculosis Surveillance (NTBS) system, working under the Database Developer and with the scientists responsible for this database including relevant programming for the maintenance, processing, and preparation of data for analysis.
  • Provide support for the development and management of other UKHSA surveillance databases, as required.
  • Develop stored procedures and views in SQL Server and utilise tools such as Power BI, Excel Power Query and MS Access needed for the management of the NTBS databases, including checks for data quality and cleaning data fields, identifying duplicates, updating user access settings, and matching.
  • Maintain code within GitHub repositories and utilise Jira to manage changes
  • Work with a wide range of internal and external teams for the maintenance and improvement of the NTBS system. Teams including and not limited to Cyber Security, Technology Dev Ops, IT, Network, Data Governance, Software Development Unit as well as external providers.
  • Provide support in the move to adopt new technologies, including utilising cloud-based infrastructure with Amazon Web Services (AWS)
  • Prepare and provide data for reports to external stakeholders, UKHSA and the WHO annual data request.

About us

See Job Description.

Working for the UKHSA

For more information on the UKHSA please visit: UK Health Security Agency - GOV.UK (www.gov.uk)

Benefits

  • Learning and development tailored to your role
  • An environment with flexible working options
  • A culture encouraging inclusion and diversity
  • A Civil Service pension with an average employer contribution of 27%
  • Range of health and wellbeing support

Any move to UKHSA from another employer will mean you can no longer access childcare vouchers. This includes moves between government departments. You may however be eligible for other government schemes, including Tax Free Childcare. Determine your eligibility at Childcare Choices | 30 Hours Free Childcare, Tax-Free Childcare and More | Help with Costs | GOV.UK

Details

Date posted

11 December 2023

Pay scheme

Other

Salary

£42,716 to £48,068 a year SEO, £42,716 - £48,068 (Inner)

Contract

Permanent

Working pattern

Full-time, Part-time, Job share, Flexible working, Home or remote working

Reference number

919-GB-UKHSA00986

Job locations

UKHSA Colindale

Colindale

NW9 5HT


Job description

Job responsibilities

Selection process details

STAGE 1 - APPLICATION & SIFT:

You will be required to complete an application form. This will be assessed in line with the full list of essential criteria as detailed in the attached job description please do provide evidence of how you meet this.

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

STAGE 2 INTERVIEW

This post will involve an interview by video via MS Teams.

As part of the process, candidates will be invited to interview which will involve an in-depth discussion of your previous experience and professional competence in relation to the criteria set out in the Person Specification. Candidates will also be asked to participate in a session where they will be required to prepare and deliver a 5-minute presentation to the panel. This will be followed by a question-and-answer segment. The presentation will be designed to assess each candidates experience in line with the requirements of the role. Full details will be provided prior to the interview.

Expected Timeline:

Advert close: 23:55hrs on 29th December 2023 unfortunately, late applications will not be considered. Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

Shortlist: : Please note that that will be a slight delay in shortlisting your application due to the Christmas and new year period. Shortlisting for this post will take place w/c 1st January 2024

Interviews: w/c 15th January 2024

Please note these dates could be subject to change.

Eligibility Criteria

Open to all external applicants (anyone) from outside the Civil Service (including by definition internal applicants)

Nationality requirements

Appointments to roles within UKHSA will be made in accordance with the Civil Service nationality rules. These can be found athttps://www.gov.uk/government/publications/nationality-rulesThis job is broadly open to the following groups:

  • UK nationals
  • Nationals of Commonwealth countries who have the right to work in the UK
  • Nationals of the Republic of Ireland
  • Nationals from the EU, EEA or Switzerland with settled or pre-settled status or who apply for either status by the deadline of theEuropean Union Settlement Scheme (EUSS)
  • Relevant EU, EEA, Swiss or Turkish nationals working in the Civil Service
  • Relevant EU, EEA, Swiss or Turkish nationals who have built up the right to work in the Civil Service
  • Certain family members of the relevant EU, EEA, Swiss or Turkish nationals

We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's Recruitment Principles.

The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.

The Civil Service welcomes applications from people who have recently left prison or have an unspent conviction. Read more about prison leaver recruitment.

Security clearance level requirement

Successful candidates must pass a disclosure and barring security check. Successful candidates must meet the security requirements before they can be appointed. The level of security needed is Basic Personnel Security Standard. People working with government assets must complete Basic Personnel Security Standard checks.

For posts on UKHSA Civil Service terms and conditions, new entrants to the Civil Service are expected to start on the minimum of the pay band. For existing Civil Servants and roles advertised across government, the rules of transfer apply, i.e., level transfers move on current salary or the pay range minimum, transfers on promotion move to new pay range minimum or receive a 10% increase. Either case is determined by whichever is the highest.

Please Note

This role is to be appointed under Civil Service Terms & Conditions. Full details on the T&Cs are found https://www.ukhsa.reed.com/

Are you already a civil servant, or employed by a Civil Service Commission accredited public body? Please state home department on your application form.

Do you meet the nationality requirements for this post? https://www.ukhsa.reed.com/

Job description

Job responsibilities

Selection process details

STAGE 1 - APPLICATION & SIFT:

You will be required to complete an application form. This will be assessed in line with the full list of essential criteria as detailed in the attached job description please do provide evidence of how you meet this.

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

STAGE 2 INTERVIEW

This post will involve an interview by video via MS Teams.

As part of the process, candidates will be invited to interview which will involve an in-depth discussion of your previous experience and professional competence in relation to the criteria set out in the Person Specification. Candidates will also be asked to participate in a session where they will be required to prepare and deliver a 5-minute presentation to the panel. This will be followed by a question-and-answer segment. The presentation will be designed to assess each candidates experience in line with the requirements of the role. Full details will be provided prior to the interview.

Expected Timeline:

Advert close: 23:55hrs on 29th December 2023 unfortunately, late applications will not be considered. Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

Shortlist: : Please note that that will be a slight delay in shortlisting your application due to the Christmas and new year period. Shortlisting for this post will take place w/c 1st January 2024

Interviews: w/c 15th January 2024

Please note these dates could be subject to change.

Eligibility Criteria

Open to all external applicants (anyone) from outside the Civil Service (including by definition internal applicants)

Nationality requirements

Appointments to roles within UKHSA will be made in accordance with the Civil Service nationality rules. These can be found athttps://www.gov.uk/government/publications/nationality-rulesThis job is broadly open to the following groups:

  • UK nationals
  • Nationals of Commonwealth countries who have the right to work in the UK
  • Nationals of the Republic of Ireland
  • Nationals from the EU, EEA or Switzerland with settled or pre-settled status or who apply for either status by the deadline of theEuropean Union Settlement Scheme (EUSS)
  • Relevant EU, EEA, Swiss or Turkish nationals working in the Civil Service
  • Relevant EU, EEA, Swiss or Turkish nationals who have built up the right to work in the Civil Service
  • Certain family members of the relevant EU, EEA, Swiss or Turkish nationals

We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's Recruitment Principles.

The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.

The Civil Service welcomes applications from people who have recently left prison or have an unspent conviction. Read more about prison leaver recruitment.

Security clearance level requirement

Successful candidates must pass a disclosure and barring security check. Successful candidates must meet the security requirements before they can be appointed. The level of security needed is Basic Personnel Security Standard. People working with government assets must complete Basic Personnel Security Standard checks.

For posts on UKHSA Civil Service terms and conditions, new entrants to the Civil Service are expected to start on the minimum of the pay band. For existing Civil Servants and roles advertised across government, the rules of transfer apply, i.e., level transfers move on current salary or the pay range minimum, transfers on promotion move to new pay range minimum or receive a 10% increase. Either case is determined by whichever is the highest.

Please Note

This role is to be appointed under Civil Service Terms & Conditions. Full details on the T&Cs are found https://www.ukhsa.reed.com/

Are you already a civil servant, or employed by a Civil Service Commission accredited public body? Please state home department on your application form.

Do you meet the nationality requirements for this post? https://www.ukhsa.reed.com/

Person Specification

Skills and Experience

Essential

  • Educated to degree level in relevant subject or equivalent level qualification or significant experience of working at a similar level in specialist area
  • Experience in complex relational database design and development of stored procedures and views
  • Experience of version control management using GitHub or similar tools
  • Using computers and database software packages (particularly SQL, Microsoft Access and Excel to an advanced level including the use of Power Query)
  • Relevant work experience in data management, analysis and reporting
  • Experience of developing Power BI reports or using other business intelligence tools
  • Demonstrated experience of co-ordinating projects in complex and challenging environments

Desirable

  • Knowledge of project principles, techniques and tools, such as Prince 2 Foundation and Microsoft Project
  • Statistical analysis and programming; using statistical/graphics software packages (SAS/Stata/SPSS/ R)
Person Specification

Skills and Experience

Essential

  • Educated to degree level in relevant subject or equivalent level qualification or significant experience of working at a similar level in specialist area
  • Experience in complex relational database design and development of stored procedures and views
  • Experience of version control management using GitHub or similar tools
  • Using computers and database software packages (particularly SQL, Microsoft Access and Excel to an advanced level including the use of Power Query)
  • Relevant work experience in data management, analysis and reporting
  • Experience of developing Power BI reports or using other business intelligence tools
  • Demonstrated experience of co-ordinating projects in complex and challenging environments

Desirable

  • Knowledge of project principles, techniques and tools, such as Prince 2 Foundation and Microsoft Project
  • Statistical analysis and programming; using statistical/graphics software packages (SAS/Stata/SPSS/ R)

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 (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.

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 (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).

Employer details

Employer name

UK Health Security Agency

Address

UKHSA Colindale

Colindale

NW9 5HT


Employer's website

https://www.gov.uk/government/organisations/uk-health-security-agency (Opens in a new tab)

Employer details

Employer name

UK Health Security Agency

Address

UKHSA Colindale

Colindale

NW9 5HT


Employer's website

https://www.gov.uk/government/organisations/uk-health-security-agency (Opens in a new tab)

Employer contact details

For questions about the job, contact:

Lead Recruiter

Gurkamal Bhambra

ukhsa.recruitment@ukhsa.com

Details

Date posted

11 December 2023

Pay scheme

Other

Salary

£42,716 to £48,068 a year SEO, £42,716 - £48,068 (Inner)

Contract

Permanent

Working pattern

Full-time, Part-time, Job share, Flexible working, Home or remote working

Reference number

919-GB-UKHSA00986

Job locations

UKHSA Colindale

Colindale

NW9 5HT


Supporting documents

Privacy notice

UK Health Security Agency's privacy notice (opens in a new tab)