Data Analyst

Birmingham, Leeds, Liverpool or London Job Summary The UKHSA Digital and Data Directorate provides strategic leadership and oversight for developing and managing a common and bespoke suite of performant, modern, secure, data and analytical tools, services, platforms and applications, ensuring access to high quality data and analytics services, internally and externally. Based within the Digital and Data Directorate, the Data Product Development Division are responsible for the development and delivery of new and existing dashboards and platforms, ensuring that data are made available to improve health security outcomes. Our flagship product is the UKHSA data dashboard, which builds on the hugely influential COVID-19 dashboard, and presents data on COVID-19, as well as other respiratory viruses such as influenza. 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 Job Description As a Data Analyst, you will play a crucial role in enabling data-driven operations and decision-making within the public health domain. Your primary responsibilities will revolve around the collection, processing, and integration of data from various sources to build robust data pipelines and dashboards, reports and visualisations. A key aspect of your work will involve designing and developing data models and schemas that facilitate efficient data storage, retrieval, and analysis. You will implement extraction, transformation, and loading (ETL) processes to ensure data quality, consistency, and integrity throughout the data lifecycle. Collaboration with public health professionals and stakeholders across the organisation will be essential to understand their data needs and develop tailored data solutions that meet their requirements. You will act as a bridge between the technical and non-technical worlds, providing guidance and support on data access, analysis, and interpretation. As part of your role, you will ensure adherence to data governance policies, security protocols, and organisational standards, safeguarding the confidentiality and integrity of sensitive public health data. Data profiling, source system analysis, and data quality checks will be crucial to identify and resolve any data integrity issues that may arise. Your role will include the production of health indicators, quality assurance of dashboard products, and the facilitation of downstream analyses by ensuring data quality, integrity, and accessibility. You will work matrix style with colleagues across UKHSA to develop and deliver national health intelligence outputs to prepare for, prevent, and respond to external hazards that threaten the health of nation’s population. As part of the main duties, you will be expected to: • Collation, analysis, interpretation and visualisation of public health information. • Implement data extraction, transformation, and loading (ETL) processes to ensure data quality and consistency. • Building and maintaining interactive dashboards and data visualisation tools to facilitate data exploration and reporting. • Participating in the “business as usual” operations of data products, such as the UKHSA data dashboard, including running data pipelines and quality assuring outputs. • Liaising, where necessary, with colleagues concerning issues of data quality and effect on analysis. • Communicating analytical/statistical matters to non-analytical/statistical professionals. • Ensuring personal and promoting team compliance with corporate policies in relation to security, confidentiality and release of information. As a Data Analyst, you will play a crucial role in enabling data-driven operations and decision-making within the public health domain. Your primary responsibilities will revolve around the collection, processing, and integration of data from various sources to build robust data pipelines and dashboards, reports and visualisations. A key aspect of your work will involve designing and developing data models and schemas that facilitate efficient data storage, retrieval, and analysis. You will implement extraction, transformation, and loading (ETL) processes to ensure data quality, consistency, and integrity throughout the data lifecycle. Collaboration with public health professionals and stakeholders across the organisation will be essential to understand their data needs and develop tailored data solutions that meet their requirements. You will act as a bridge between the technical and non-technical worlds, providing guidance and support on data access, analysis, and interpretation. As part of your role, you will ensure adherence to data governance policies, security protocols, and organisational standards, safeguarding the confidentiality and integrity of sensitive public health data. Data profiling, source system analysis, and data quality checks will be crucial to identify and resolve any data integrity issues that may arise. Your role will include the production of health indicators, quality assurance of dashboard products, and the facilitation of downstream analyses by ensuring data quality, integrity, and accessibility. You will work matrix style with colleagues across UKHSA to develop and deliver national health intelligence outputs to prepare for, prevent, and respond to external hazards that threaten the health of nation’s population. As part of the main duties, you will be expected to: • Collation, analysis, interpretation and visualisation of public health information. • Implement data extraction, transformation, and loading (ETL) processes to ensure data quality and consistency. • Building and maintaining interactive dashboards and data visualisation tools to facilitate data exploration and reporting. • Participating in the “business as usual” operations of data products, such as the UKHSA data dashboard, including running data pipelines and quality assuring outputs. • Liaising, where necessary, with colleagues concerning issues of data quality and effect on analysis. • Communicating analytical/statistical matters to non-analytical/statistical professionals. • Ensuring personal and promoting team compliance with corporate policies in relation to security, confidentiality and release of information. Person specification Essential Criteria • Experience of coding (e.g., SQL, R, Python) and familiarity with good data science practice e.g., version control • Experience working with health-related datasets or information systems in health-related organisations • Experience in using Microsoft Power BI to analyse data and build, develop, support dashboards • Working knowledge of data security, management and information governance • Perform analysts to support business decisions e.g. assess data, find trends, drill down, assess relationships or causality, create forecasts • Experience of producing data models, understanding where to use, how to compare and reverse-engineer a data model from a live system • Ability to analyse complex issues where material is conflicting and drawn from multiple sources • High degree of numeracy and literacy • Ability to present, communicate and visualise data so that it is accessible to others • Ability to communicate effectively with technical and non-technical audiences • An understanding of and commitment to equality of opportunity and good working relationships • A first or second class honours degree in a numerate subject (e.g. Statistics, Mathematics, Economics, Sciences, Business Studies, Psychology, Geography or similar) or a higher degree, e.g. a MSc or PhD, in a numerate subject or have worked in a data analysis field and are able to demonstrate Continuous Professional Development in data analysis at the same level as a foundation Alongside your salary of £33,422, UK Health Security Agency contributes £9,682 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides. • 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 employer contribution of 28.97% Selection process details This vacancy is using Success Profiles and will assess your behaviours and technical skills. Stage 1: Application & Sift Required You will be required to complete an application form. You will be assessed on the listed essential criteria, and this will be in the form of: • an application form (‘Employer/ Activity history’ section on the application) • a 750 word supporting statement This should outline how your skills, experience, and knowledge, provide evidence of your suitability for the role, with reference to the essential criteria. Please note you will not be able to upload your CV. You must complete the application form in as much detail as possible. Please do not email us your CV. The Application form and supporting statement will be marked together. 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 Only those meeting all essential criteria will be taken through to shortlisting. Shortlisting: In the event of a large number of applications we will shortlist on: • A first or second class honours degree in a numerate subject (e.g. Statistics, Mathematics, Economics, Sciences, Business Studies, Psychology, Geography or similar) or a higher degree, e.g. a MSc or PhD, in a numerate subject or have worked in a data analysis field and are able to demonstrate Continuous Professional Development in data analysis at the same level as a foundation • Experience of coding (e.g., SQL, R, Python) and familiarity with good data science practice e.g., version control • Experience working with health-related datasets or information systems in health-related organisations If you are successful at this stage, you will progress to interview and assessment. Please do not exceed 750 words. We will not consider any words over and above this number. Feedback will not be provided at this stage. Stage 2: Interview (Success Profiles) You will be invited to a remote interview. Behaviours and technical skills will be tested at interview. You will be required to complete a technical assessment and present your analysis in the first 10 minutes of the interview. 7 days before the interview, details will be provided to applicants. The main area of the assessment is data analysis. The Behaviours Tested During The Interview Stage Will Be • Changing and Improving • Working Together • Managing a Quality Service • Delivering at Pace The Following Technical Skills Will Be Assessed At Interview • Data Analyst Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records. Location (Hybrid) This role is being offered as hybrid working based at any of our Core HQ’s in Birmingham, Leeds, Liverpool or London. 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). Our core HQ offices are modern and newly refurbished with excellent city centre transport link and benefit from benefit from co-location with other government departments such as the Department for Health and Social Care (DHSC). Eligibility Criteria Open to all external applicants (anyone) from outside the Civil Service (including by definition internal applicants). 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 Security Check clearance. 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 5 years as the role requires Security Check clearance.  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. 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: https://www.civil-service-careers.gov.uk/reasonable-adjustments/ 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. Artificial Intelligence (AI) Artificial Intelligence can be a useful tool to support your application, however, all examples and statements provided must be truthful, factually accurate and taken directly from your own experience. Where plagiarism has been identified (presenting the ideas and experiences of others, or generated by artificial intelligence, as your own) applications may be withdrawn and internal candidates may be subject to disciplinary action. Please see our candidate guidance for more information on appropriate and inappropriate use. Link Below Artificial intelligence and recruitment , Civil Service Careers 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. Careers website Please visit our careers site for more information https://gov.uk/ukhsa/careers Feedback will only be provided if you attend an interview or assessment. Security Successful candidates must undergo a criminal record check. Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window).See our vetting charter (opens in a new window). People working with government assets must complete baseline personnel security standard (opens in new window) checks. Successful candidates must undergo a criminal record check. Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window).See our vetting charter (opens in a new window). People working with government assets must complete baseline personnel security standard (opens in new window) checks. Nationality requirements This Job Is Broadly Open To The Following Groups • UK nationals • nationals of the Republic of Ireland • nationals of Commonwealth countries who have the right to work in the UK • nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS) (opens in a new window) • nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS) • individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020 • Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service Further information on nationality requirements (opens in a new window) Working for the Civil Service The Civil Service Code (opens in a new window) sets out the standards of behaviour expected of civil servants. 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). 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 Code (opens in a new window) sets out the standards of behaviour expected of civil servants. 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). 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. Diversity and Inclusion The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see the Civil Service People Plan (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window). Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records. Contact point for applicants Job Contact • Name : Jon Payne • Email : jonathan.payne@ukhsa.gov.uk Recruitment team • Email : recruitment@ukhsa.gov.uk Further information The law requires that selection for appointment to the Civil Service is on merit on the basis of fair and open competition as outlined in the Civil Service Commission's Recruitment Principles. If you feel your application has not been treated in accordance with the Recruitment Principles, and you wish to make a complaint, in the first instance, you should contact UKHSA Public Accountability Unit via email: Complaints@ukhsa.gov.uk If you are not satisfied with the response you receive from the Department, you can contact the Civil Service Commission: Visit the Civil Service Commission website: https://civilservicecommission.independent.gov.uk https://www.healthjobsuk.com/job/UK/London/Birmingham_Leeds_Liverpool_London/UK_Health_Security_Agency/Data_Analysis/Data_Analysis-v7628625?set-locale=en-gb&\_ts=1