Data Access and Reporting Manager

The UKHSA Data and Digital 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. As a Data Access, Quality and Reporting Manager you will manage and facilitate all access, role and permission profiles within the Diagnostic Laboratory Data Curation System, currently called the Second-Generation Surveillance System (SGSS). You will be responsible for building and managing the suite of reporting tools to support management information, performance monitoring, surveillance and data quality needs. As a Subject Matter Expert (SME) for the use of Diagnostic Laboratory data within the SGSS environments, you will ensure full and accurate documentation, relating to all processes and policies within the area are made available. The post holder will liaise regularly with both UKHSA staff and external stakeholders to develop meaningful reports, data feeds, and inform them of data quality levels within the data. It's an exciting time to join the team because you will work matrix style with colleagues and will be joining at an interesting period where we will be transitioning to a new cloud native solution. 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., + Be responsible for approving and providing access and permissions across all Second-Generation Surveillance System environments.

• Monitor user access and produce regular user metrics, modifying the solution to best optimise the user end-user experience.
• Manage and maintain the business intelligence reporting solutions used to access the datasets.
• Through expert knowledge of the surveillance systems and alongside colleagues across UKHSA, develop a suite of reports and data models to maximise the availability of the data and utilise data visualisation tools.
• Be responsible for ensuring information governance around the access and permissions documentation is up to date.
• Develop user support documentation for SGSS and training materials for operational users of the data.
• Liaise with the Surveillance Data Team and Field Service Teams to understand data quality issues in the reported datasets, including investigation and resolution of issues where possible.
• Responsible for gathering requirements, understanding user needs, planning and building data quality dashboards to enable monitoring.
• Responsible for planning and prioritisation of the work of the access and reporting workstreams, delegating appropriately to ensure work allocated, staff upskilled, and knowledge shared leading to succession planning.
• Manage and respond to requests for support and complex analysis of the managed datasets.

Detailed job description and main responsibilities

• Support team members with the decision process of access and permission group approvals.

• Liaise with technology and database engineers to ensure the access and permission groups are set up in a secure, consistent and agile manner to cover all requirements.

• Advise and support users in the use of the reporting tools used to access the surveillance system environments.

• Project manage, when required, the implementation of reporting tools to other datasets.

• Assist users with transition of reporting solutions including the migration for analysts to Enterprise Data Analytics Platform (EDAP).

• Utilise available tools such as SharePoint to manage user support materials and develop documentation version control.

• Develop expert knowledge in the data held within the SGSS to give advice on the content to operational staff across UKHSA.

• Develop knowledge and understanding of emerging technologies, data visualisation and business intelligence tools and their application to UKHSA datasets.

• Build management information reports for internal teams so that alerts are triggered when issues occur.

• Responsible for Business Continuity Planning and application for any SGSS access and reporting requirements.

• Provide line manage support, providing leadership and direction to HEO and team. Including providing support during a changing environment, taking opportunities to feed into design, test new tooling and ensure business readiness for deployment. The above is only an outline of the tasks, responsibilities and outcomes required of the role. You will carry out any other duties as may reasonably be required by the directorate. The job description and person specification may be reviewed on an ongoing basis in accordance with the changing needs of the organisation., This vacancy is using Success Profiles and will assess your Behaviours, Experience, Technical skills. Stage 1: Application & Sift 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)

• Up to 1,200 number of words word supporting statement. Healthjobs UK has a word limit of 1, 500 but your supporting statement must be no more than 1,200 words. This should outline how you consider 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 may longlist into 3 piles of:

• Meets all essential criteria

• Meets some essential criteria

• Meets no essential criteria The following will be taken through to the next stage: Meets all essential criteria Please note feedback will not be provided at this stage. Shortlisting In the event of a large number of applications an initial sifts against the following criteria will be conducted:

• Excellent SQL querying skills.

• Line Management Experience. Following sift you will be asked to complete a technical test demonstrating and assessing your understanding and application of SQL coding and queries. If successful you will be progressed to interview stage. Stage 2: Interview (success profiles) You will be invited to a (single) remote interview. The following Behaviours will be tested at interview:

• Making Effective Decisions

• Leadership

• Communicating and Influencing

• Working Together

• Managing a Quality Service Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records. Location This role is being offered as hybrid working based at any of our Core HQ's. 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) working at one of UKHSA's core HQ's (Birmingham, Leeds, Liverpool, and London) or at one of our scientific campus sites (Colindale, Porton and Chilton). 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). 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. Security Clearance Level Requirement Successful candidates must pass a basic disclosure and barring security check. All successful candidates must meet the basic security requirements before they can be appointed. The level of security needed is:

• Basic Personnel Security Standard (BPSS)

• Security Clearance You should normally have been resident in the United Kingdom for the last 5 years to obtain Security Check (SC). UK residency less than the outlined periods may not necessarily bar you from gaining national security vetting at this higher level and applicants should contact the Vacancy Holder / Recruiting Manager listed in the advert for further advice. Eligibility Criteria - External Open to all external applicants (anyone) from outside the Civil Service (including by definition internal applicants). 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.

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)

• Educated to degree level in information science or extensive experience in data management and review, use of coding and / or processing and interpreting information.

• Proficient experience in the use of Power BI Analytics.

• Excellent SQL querying skills.

• Data Management, data quality and data flow knowledge.

• Experience of building reports and data models.

• Experience of using Microsoft Office products to an advanced level for data manipulation and presentation.

• Experience of analysis and interpretation of data in complex information systems.

• Advanced experience of using enterprise business intelligence tools such as Power BI, SQL Server Reporting Services, SQL Server Analysis Services, DAX and PowerPivot.

• Knowledge and understanding of data protection principles.

• Experience of working with a broad range of customers with varying degrees of technical skills.

• Experience of training end users and colleagues to query information systems.

• Ability to convey complex data concepts to end-uses.

• Excellent communicator with a high level of interpersonal skills.

• Line Management Experience.

• Excellent team working skills.

• Good organisational skills and ability to prioritise workload.

• Ability to adapt to changing systems and processes.

• Committed to professional development.

• Equality & Diversity: An understanding of and commitment to equality of opportunity and good working relationships, both in terms of day-to-day working practices, but also in relation to management systems.

• Ability to adapt to changing systems and processes. Desirable Criteria

• Extensive Experience as an AWS Cloud Practitioner.

Alongside your salary of £41,983, UK Health Security Agency contributes £12,162 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%