Apply Now
Details
Reference number
Salary
Job grade
Contract type
Type of role
Architecture and Data
Digital
Science
Working pattern
Number of jobs available
Contents
Location
About the job
Job summary
Job Title Database Manager
Profession– Data
Directorate Clinical & Emerging Infections
Full Time equivalent – 37.5 hours
No of Roles 1
Contract Type Permanent
Location Colindale, London, NW9 5EQ
Working Pattern Full Time /Flexible Working/ Hybrid Working
Grade & Salary Grade SEO. Inner Banding – £40,876 – £45,998
New entrants to the Civil Service are expected to start on the minimum of the pay band.
The internal roles rules apply to existing Civil Servants, i.e. level transfers move on current salary or the pay range minimum, transfers on promotion move to new pay range minimum or receive 10% increase. Either case is determined by whichever is the highest.
This role is to be appointed under Civil Service Terms & Conditions. Full details on the T&Cs are found https://www.ukhsa.reed.com/.
Closing Date 21/08/2023. 23:55pm. Unfortunately, late applications will not be considered
Interview Date 04/09/2023 & 05/09/2023 Please note, these dates are subject to change.
Job Overview
This post is in the TB Unit 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 post holder will work with the Database Developer and the TB Unit Principal Scientist and under the direction of the Head of the TB Unit. The post-holder will have responsibility for the day to day management and development of a number of key Microsoft SQL Server databases in the TB Unit along with databases for the National Tuberculosis Surveillance (NTBS) system. The post holder will ensure code is maintained within respective github repositories and utilise Jira to manage code changes through development, review and quality assurance stages. The post holder will also develop and enhance Power BI reports for use within NTBS.
The post holder will have the opportunity to scope and deliver changes to data flows to improve automation and resilience using a variety of tools and methods.
The post holder may also take responsibility for managing the Data Quality and Information officer.
Job description
The post holder will undertake tasks in the following areas:
- Manage the database of the National Tuberculosis Surveillance (NTBS) system, working with the scientists responsible for this database including relevant programming for the maintenance, processing and preparation of data for analysis.
- Develop queries and programs, both in Access and SQL Server, needed for the management of the NTBS database, including checks for data quality and cleaning data fields, identifying duplicates, updating user access settings, and matching.
- Prepare and provide data for reports to external stakeholders, UKHSA and the WHO annual data request.
- Lead the extraction of information from the information systems held by the TB Unit to support the preparation of reports and responses to parliamentary questions or outbreaks and incidents as requested by the Principal Scientist.
- Lead on the management and development of data warehouses to enable data cleaning, and reporting.
- Contribute to the testing of software developed by the Software Development Unit to support the TB surveillance system (NTBS), and the development of accompanying user guides.
- Contribute to the security of the information contained within the information systems for the TB Unit and across TARZET.
- Provide support for the development and management of other UKHSA surveillance databases, as required.
- Any other duties commensurate with the grade as specified by the line manager or section or department head.
Person specification
Essential Criteria:
- Educated to degree level in relevant subject or equivalent level qualification or significant experience of working at a similar level in specialist area
- Higher degree in related discipline (e.g. information systems) or substantial experience at senior level
- Relevant work experience in data management, analysis and reporting
- Experience of version control management using GitHub or similar tools
- Experience of developing Power BI reports or using other business intelligence tools
- Experience with NHS datasets (i.e. HES)
- Demonstrated experience of co-ordinating projects in complex and challenging environments
- Experience of managing and reporting risks
- Statistical analysis and programming; using statistical/graphics software packages (SAS/Stata/SPSS/ SQL and MS Access queries)
- Ability to work as part of a team.
- Good interpersonal and communications skills
- An understanding of and commitment to equality of opportunity and good working relationships
Desirable Criteria:
- Comprehensive knowledge of project principles, techniques and tools, such as Prince 2 Foundation and Microsoft Project
- Interpreting and evaluating epidemiological data
- Please see the attached Full job description for duties and responsibilities, professional development and key working relationships in the attached document.
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%
Things you need to know
Selection process details
You will be required to complete an application form. This will be assessed and sifted in line with the essential criteria.
This vacancy is using Success Profiles and will assess your Behaviours and Experience and technical skill
Stage 1: Application & Sift
As part of the application process, you will be asked to provide a Statement of Suitability in no more than 750 words providing examples of how you meet the essential criteria & the following behaviours:
It should also detail what you and your experience can bring to the role.
Feedback will not be provided at this stage.
If you are successful at this stage, you will progress to interview
Stage 2: Panel Interview
All applicants that progress to interview will be assessed on behaviours / experience / technical / ability through Success Profiles The interview will be conducted remotely via teams. You may be required to do a presentation.
The behaviours you will be tested on are:
Changing and improving
Making effective decisions
Delivering at pace
Reserve List:
Candidates who pass the interview criteria but are not offered a post will be kept on a reserve list for 12 months and may be contacted if similar roles become available.
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.
DBS – People working with government systems must complete Basic Personnel Security Standard (BPSS) checks which includes a disclosure and barring security check. Successful candidates must meet the security requirements before they can be appointed. The level of security needed for this role is BPSS however there may be a requirement for this role to be SC cleared and you should familiarise yourself with the criteria of security clearance.
This role is Open to all external applicants (anyone) from outside the Civil Service (including by definition internal applicants. Appointments to roles within UKHSA will be made in accordance with the Civil Service nationality rules. These can be found at https://www.gov.uk/government/publications/nationality-rules This 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 the European 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.
Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.
Government baseline personnel security standard
Its important to note that there are currently exceptions to applications being considered if your conviction relates to any of the following:
- life sentences
- arson
- sexual offences
- hate and terror offences
Some departments will also consider the specific offence against the nature of the business, i.e., a conviction for fraud may rule you out for a finance role
Contact Details Sophie.Rigney@reed.com
Feedback will only be provided if you attend an interview or assessment.
Security
Nationality requirements
Working for the Civil Service
We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission’s recruitment principles (opens in a new window).
Apply and further information
You may want to save a copy for your records.
Contact point for applicants
Job contact :
- Name : sophie rigney
- Email : sophie.rigney@reed.com
Recruitment team
- Email : hradmin@phe.gov.uk
