Job description
Job title –Data Engineer
Profession- Digital Data & Technology
Directorate– Data Operations
Full Time equivalent- 37.5 hours
No of Roles– 4
Contract Type– Permanent
Location– Home Working
UKHSA offers hybrid working or home working for its employees – this means that whilst the role will be based in one of our UKHSA offices, there will be opportunities for an element of working from home. The balance between home and workplace working is to be agreed with the line manager, determined primarily by business need and in line with departmental policy. Some business travel will be required to other UKHSA offices. 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
Grade & Salary –Grade 7. National banding - £49,592 - £58,769 per annum. Outer London -£51,494- £60,528 per annum. Inner London - £53,396 - £62,286 per annum.
This role comes with a Market Pay Supplement of up to £10,000
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.
COVID-19 has reinforced the impact that threats to health can have on society and the economy and driven health security as a critical component of our national security architecture. The United Kingdom Health Security Agency (UKHSA) is a system leader for health security; taking action internationally to strengthen global health security, providing trusted advice to government and the public and reducing inequalities in the way different communities experience and are impacted by infectious disease, environmental hazards, and other threats to health.
UKHSA’s remit, as an agency with a global-to-local reach, is to protect the health of the nation from infectious diseases and other external threats to health. As the nation’s expert national health security agency UKHSA will:
1. Prevent: anticipate threats to health and help build the nation’s readiness, defenses and health security
2. Detect: use cutting edge environmental and biological surveillance to proactively detect and monitor infectious diseases and threats to health
3. Analyse: use world-class science and data analytics to assess and continually monitor threats to health, identifying how best to control and mitigate the risks
4. Respond: take rapid, collaborative and effective actions nationally and locally to mitigate threats to health when they materialise
5. Lead: lead strong and sustainable global, national, regional and local partnerships designed to save lives, protect the nation from public health threats
UKHSA will build on the legacy of the COVID-19 response to ensure resilient and scalable infrastructure to secure the UK in the strongest position to protect the public from future threats to health.
UKHSA mission is challenging, innovative and in the spotlight. To achieve our objectives effectively and fairly, we commit to representing modern Britain and all its diversity. UKHSA recognises that diversity of background and life experience brings different insights, creates challenge and encourages change and innovation. This in turn produces more accountable and trusted public services and better decisions; better because they are more attuned to the needs and interests of all our communities. Differences of thought and outlook are not only respected but expected. We want all our employees to feel that they can be themselves at work and that they are valued.
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.
Main duties and responsibilities
- Programming and build -You can design, write and iterate code from prototype to production-ready. You understand security, accessibility and version control. You can use a range of coding tools and languages. You can develop code that self-generates documentation that supports Data Scientists and Data Analysts.
- Technical understanding -You know about the specific technologies that underpin your ability to deliver the responsibilities and tasks of the role. You can apply the required breadth and depth of technical knowledge.
- Testing -You can plan, design, manage, execute and report tests, using appropriate tools and techniques, and work within regulations. You know how to ensure that risks associated with deployment are adequately understood and documented
- Problem resolution -You know how to log, analyse and manage problems in order to identify and implement the appropriate solution. You can ensure that the problem is fixed.
The role requires the ingestion of a wide range of data assets, building acquisition, orchestration, data pipelines and curated data marts and data egresses. We are seeking to mature our advanced capabilities with standardised practices, machine learning and agility needed to pro-active detect and respond to new public health issues.
You will be involved in the delivery lifecycle from engaging with stakeholders on new initiatives, analysing use cases, developing optimal designs that where possible re-use and extend capabilities, and implement and operate the design. Our teams work collaboratively in an agile multi-disciplinary team mode and we are looking for engineers who have the ability to operate in feature teams, data operations and DevSecOps models. We are developing our engineering community of practice to share knowledge, enhance our standards and processes to provide a strong foundation to develop individuals, teams and innovation.
Essential Criteria
- Strong at python, unit testing (pytest) and pep8 standards
- Writing robust data pipeline code that can run unattended
- Pandas data validation, manipulation, merging, joining and at times visualisation
- Unix environment, server health and management of ongoing running processes
- Github, git, pull requests, CI and code review
- Logging and reporting pragmatically
- Ability to troubleshoot and solve numerical and technical problems
- High attention to detail
- Excellent communication and facilitation skills evidenced through verbal and written means to a wide range of stakeholders
- Experience with Agile delivery
- Data engineering experience using Python, SQL, Spark and AWS
- Hands on ETL development experience utilizing Microsoft enterprise stack / Azure and AWS Glue
- Knowledge of data management platforms and development with SQLServer
- Experience with publishing data sets for visualisation and analysis
- Experience with supporting design of data models / data flows
- Ability to work as part of a team to develop and deliver end-to-end data warehouse solutions
- Analytical skill set with an ability to understand data requirements and support the development of data solutions
- Machine learning for engineering practices, such as meta driven intelligent ETL and pipeline processes
- Experience of working with JIRA (or Azure DevOps or similar tools) within an Agile/Scrum environment
- Experience/understanding of software and data lifecycle management
- Educated to degree level (not essential, experience is key). Relevant numerate, technical or computer science discipline would be an advantage
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.
Selection Process
This vacancy is using Success Profiles, and will assess your Behaviours, Experience and Strengths
This part of the selection process should outline how you consider your skills, experience and achievements, and provide evidence of your suitability for the role, with particular reference to the essential criteria outlined.
You will also be asked to provide information within the ‘Employer/ Activity history’ section of the application form. This is equivalent to the information you would provide on a CV, setting out your career history. This will be used in sifting process and will be scored.
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 regarding the following behaviours:
- Changing and Improving
- Making Effective Decisions
- Communicating and Influencing
- Delivering At Pace
- Managing a quality Service
If you are successful at this stage, you will progress to interview
Stage 2: Panel Interview
All candidates who are successful at the sift stage will undertake a single video interview AND a written technical skills test
The Behaviours tested during the interview stage will be:
- Changing and Improving
- Making Effective Decisions
- Communicating and Influencing
- Delivering at Pace
- Managing a quality service
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.
Benefits
- Alongside your salary of £49,592, UK Health Security Agency contributes £13,390 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.
- A Civil Service pension with an average employer contribution of 27%
- Learning and development tailored to your role
- An environment with flexible working options
- A culture encouraging inclusion and diversity
- Range of health and wellbeing support
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
The Civil Service embraces diversity and promotes equal opportunities. As such, we run aDisability 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
It’s 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
Contact Details –[email protected]