About the job

Job summary

As part of the Data, Insights & Systems team within the Commercial function, this key role is responsible for the management of commercial data and reporting. Advocating a self-serve approach to commercial data products, identifying opportunities for process improvement and applying automation where possible, and presenting to senior stakeholders.

The expectation is that the post holder will develop reports, maintain existing business intelligence dashboards, undertake analysis, automate repetitive business processes using the Power Platform suite (Power BI, Power Automate, and Power Apps) and support the management of our Source-to-Contract system (Atamis).

In addition, you will support the delivery of projects and continuous improvement initiatives in Commercial that enhance the maturity of the function. Your role also involves identifying and interpreting trends or patterns to improve data accuracy and operational performance, ensuring that these improvements are reflected and monitored in reporting.

You will be expected to work as part of a high-functioning team in delivering data solutions and ad-hoc reporting requests for stakeholders across UKHSA, central government and liaise with other government bodies on commercial data best practise. You will be working in a fast-paced commercial environment providing key management information to drive effective decision-making and strategy. The successful individual will be a self-starter, comfortable working on change and transformation.

Location

The UK Health Security Agency (UKHSA) operates 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 locations (Birmingham, Leeds, Liverpool, and London). For certain roles, some additional flexibility may be possible, which will be agreed upon with the hiring manager based on individual requirements and business needs.

*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

Job description

As the Commercial Data Manager, you will play a critical role within the Data, Insights & Systems team, situated at the heart of our Commercial function. Your role encompasses the development of reports, maintenance of business intelligence dashboards, and rigorous analysis of data to extract actionable insights. Proficiency in Power BI, Power Automate, and Power Apps is crucial, as these tools enable you to streamline workflows and automate repetitive tasks, ensuring operational efficiency.

You'll also play a pivotal role in supporting projects aimed at advancing the maturity of the Commercial function. This involves not only contributing to more informed decision-making processes, but also fostering a culture of continuous improvement by working with internal stakeholders to identify opportunities to enhance processes and systems to drive innovation and efficiency within the organisation.

Collaboration lies at the heart of your role, as you'll also engage with stakeholders across UKHSA, central government, and other bodies. This collaborative approach is essential for delivering data solutions and addressing ad-hoc reporting requests promptly and effectively. By fostering strong relationships with stakeholders, you'll maximise collaboration opportunities and enhance the organisation's overall capability to leverage data for strategic decision-making.

Your main responsibilities will include:

• Support the Commercial Data, Insights & Systems Team on: Recurring BAU performance reporting; Dealing with urgent and sometimes complex data queries delivered to tight timescales; Responding to other requests such as Commercial Senior Leadership Team requests, ministerial requests and Freedom of Information requests.
• Design, implement, and maintain automated Power BI reporting dashboards.
• Implement and manage workflows to automate repetitive tasks and streamline processes across the Commercial Workflow.
• Leverage the Power Platform suite (Power BI, Power Automate, Power Apps etc) to drive operational excellence and ensure adherence to regulatory requirements.
• Collaborate closely with stakeholders to identify process inefficiencies and compliance gaps and propose innovative Power Platform-based solutions to address them.
• Develop relationships with a range of internal and external stakeholders to maximise opportunities to collaborate on best practise and improve capability.
• Support the management of our Source-to-Contract system (Atamis).

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.

Person specification

It is important through your application and Statement of Suitability of no more than 500 words that you give evidence and examples of proven experience of each of the essential criteria (for full details of all essential criteria please refer to the attached job description):

Essential

• Experience working in an Analyst/Data Analytics role, including preparing and presenting data to senior stakeholders.
• Proven experience automating business processes and reporting using the Power Platform suite, including Power BI, Power Automate, and Power Apps.
• Advanced MS Excel
• Business Analysis capabilities including requirements gathering and structured approach to problem-solving.
• Pro-active individual to lead and deliver on projects and drive workstream forward.
• Communicate complex data details into business language and display excellent stakeholder management skills.
• Ability to manage stakeholders effectively and communicate insights through data, strong analytical skills with attention to detail, and experience in analysing data from multiple sources.

Desirable

• Experience working in a Procurement/Commercial environment.
• Public sector experience.

Benefits

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.

For more information on the UKHSA please visit: UK Health Security Agency - GOV.UK (www.gov.uk)

• 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

Any move to UKHSA from another employer will mean you can no longer access childcare vouchers. This includes moves between government departments. You may however be eligible for other government schemes, including Tax Free Childcare. Determine your eligibility at Childcare Choices , 30 Hours Free Childcare, Tax-Free Childcare and More , Help with Costs , GOV.UK

Things you need to know

Selection process details

STAGE 1 - APPLICATION & SIFT: 

You will be required to complete an application form. This will be assessed in line with the full list of essential criteria as detailed in the attached job description – please do provide evidence of how you meet this. Your Statement of Suitability should outline your skills, experience, and achievements, providing evidence of your suitability for the role, with reference to the essential criteria (outlined in the person specification section).

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.

If you are successful at this stage, you will progress to an interview.

STAGE 2 – INTERVIEW 

This competition will involve an interview by video. 

As part of the process, candidates will be invited to interview which will involve an in-depth discussion of your previous experience and professional competence in relation to the criteria set out in the Person Specification.  Candidates will also be asked to participate in a session where they will be required to prepare and deliver a 5-minute presentation to the panel.  This will be followed by a question-and-answer segment.  The presentation will be designed to assess each candidate’s experience in line with the requirements of the role.  Full details will be provided prior to the interview.

The Success Profiles framework will be used to assess and recruit the most suitable candidate.  The following behaviours will be used at the interview:

• Communicating and Influencing
• Working Together
• Delivering at Pace
• Managing a Quality Service

For further information on the selection process, please refer to the attached Candidate Pack.

Expected Timeline:

Advert close: 23:55hrs on 29th March 2023 – unfortunately, late applications will not be considered. Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

Interviews: TBD

Please note these dates could be subject to change.  

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 Basic Personnel Security Standard.  People working with government assets must complete Basic Personnel Security Standard checks.

For posts on UKHSA Civil Service terms and conditions, new entrants to the Civil Service are expected to start on the minimum of the pay band. For existing Civil Servants and roles advertised across government, the rules of transfer apply, i.e., level transfers move on current salary or the pay range minimum, transfers on promotion move to new pay range minimum or receive a 10% increase. Either case is determined by whichever is the highest. 

Please Note

This role is to be appointed under Civil Service Terms & Conditions. Full details on the T&C’s are found https://www.ukhsa.reed.com/

Are you already a civil servant, or employed by a Civil Service Commission accredited public body? Please state home department on your application form.

Do you meet the nationality requirements for this post? https://www.ukhsa.reed.com/

Complaint process:

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: Complaints1@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.

Feedback will only be provided if you attend an interview or assessment.

Security

Successful candidates must undergo a criminal record check. 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

Please note this Post is NOT regulated by the Civil Service Commission. 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.