Job summary
This role will be to join the UKHSA SIREN study team. SIREN (SARS-CoV-2 Immunity & Reinfection EvaluatioN) is a large-scale study of health care workers, focused on increasing our understanding of whether individuals with COVID-19 are protected from future SARS-CoV-2 infection and the impact of COVID-19 vaccination. The SIREN study has expanded its remit to other respiratory infections including influenza and RSV. This is a high-profile study with multiple deliverables and collaborations.
Main duties of the job
SIREN is within the Healthcare Associated Infection, Fungal, Antimicrobial Resistance, Antimicrobial Utilisation & Sepsis Division (Clinical & Public Health group) of UKHSA. The mission of the division is to protect people from healthcare-associated and antimicrobial resistant infections, through world-leading public health microbiology, outbreak response, surveillance, antimicrobial stewardship, modelling, research and interventions.
Location
10 South Colonnade, Canary Wharf, London, E14 4PU / Hybrid Working
*Please be aware that this role can only be worked from within the UK and not overseas. Relocation expenses are not available.*
Working Pattern - Full Time, Part Time, Job Share, Flexible Working, Hybrid Working
About us
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
Job description
Job responsibilities
Responsibilities section:
As the Database Manager your main responsibilities will include:
- Work on the design, implementation and management of databases to handle data flows securely and efficiently for the duration of the programme of work
- Demonstrate knowledge of suitable statistical platforms (e.g. R, STATA, SAS etc.) and/or programming languages (e.g. Python, perl etc), as well as existing software to enable large scale data manipulation as well as a thorough understanding and practical knowledge of SQL.
- Write SQL queries on request
- Maintain and create stored procedures within SQL servers
- Troubleshoot SQL problems
- Write and troubleshoot STATA scripts
- Responsible for collating and assessing the feasibility of linking health record datasets
- Work in collaboration with colleagues to identify key variables in order 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
- Address key issues with record linkage including data divergence, redundancy and data overlap
- Lead on assessing the accuracy and completeness of health record data as well as cleaning and standardizing the datasets
- Navigating and negotiating data access issues through partners within UKHSA, NHS England and Improvement and NHS Digital, etc
- Assist in the generation, evaluation and comparison of routine enhanced surveillance reports
- Contribute as part of the data team in responding to ad-hoc queries and data requests
- Responsible for producing up-to-date content for the relevant sections of the UKHSA website
The duties/responsibilities listed above describe the post as it is at present and is not intended to be exhaustive. The Job holder is expected to accept reasonable alterations and additional tasks of a similar level that may be necessary.
Please see the job description for a full list of responsibilities.
Job description
Job responsibilities
Responsibilities section:
As the Database Manager your main responsibilities will include:
- Work on the design, implementation and management of databases to handle data flows securely and efficiently for the duration of the programme of work
- Demonstrate knowledge of suitable statistical platforms (e.g. R, STATA, SAS etc.) and/or programming languages (e.g. Python, perl etc), as well as existing software to enable large scale data manipulation as well as a thorough understanding and practical knowledge of SQL.
- Write SQL queries on request
- Maintain and create stored procedures within SQL servers
- Troubleshoot SQL problems
- Write and troubleshoot STATA scripts
- Responsible for collating and assessing the feasibility of linking health record datasets
- Work in collaboration with colleagues to identify key variables in order 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
- Address key issues with record linkage including data divergence, redundancy and data overlap
- Lead on assessing the accuracy and completeness of health record data as well as cleaning and standardizing the datasets
- Navigating and negotiating data access issues through partners within UKHSA, NHS England and Improvement and NHS Digital, etc
- Assist in the generation, evaluation and comparison of routine enhanced surveillance reports
- Contribute as part of the data team in responding to ad-hoc queries and data requests
- Responsible for producing up-to-date content for the relevant sections of the UKHSA website
The duties/responsibilities listed above describe the post as it is at present and is not intended to be exhaustive. The Job holder is expected to accept reasonable alterations and additional tasks of a similar level that may be necessary.
Please see the job description for a full list of responsibilities.
Person Specification
Essential/Desirable criteria
Essential
- Degree in relevant subject
- Substantial postgraduate experience in a relevant subject or higher degree in related discipline (i.e., Statistics or Epidemiology)
- Strong analytic skills
- Statistical analysis and programming; using statistical/graphics software packages (SAS/Stata/SPSS)
- Knowledge of MS Access and Excel
- Knowledge of SQL
- Experience with NHS datasets (i.e., HES)
- Ability to work well in a multi-disciplinary team
- Excellent communication skills
- Self-motivating
- Ability to maintain required levels of confidentiality
- An understanding of and commitment to equality of opportunity and good working relationships.
Desirable
- Knowledge of Visual Basic Application (VBA)
- Communicable diseases epidemiology and surveillance
- Preparing research proposals
- Scientific report writing
Person Specification
Essential/Desirable criteria
Essential
- Degree in relevant subject
- Substantial postgraduate experience in a relevant subject or higher degree in related discipline (i.e., Statistics or Epidemiology)
- Strong analytic skills
- Statistical analysis and programming; using statistical/graphics software packages (SAS/Stata/SPSS)
- Knowledge of MS Access and Excel
- Knowledge of SQL
- Experience with NHS datasets (i.e., HES)
- Ability to work well in a multi-disciplinary team
- Excellent communication skills
- Self-motivating
- Ability to maintain required levels of confidentiality
- An understanding of and commitment to equality of opportunity and good working relationships.
Desirable
- Knowledge of Visual Basic Application (VBA)
- Communicable diseases epidemiology and surveillance
- Preparing research proposals
- Scientific report writing
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).
