Job overview
The postholder will work within the Workforce Intelligence Team, deputising for the Workforce Intelligence lead and ensuring the most efficient use of resources and building resilience to enable the team to deliver a proactive workforce information service that can adapt to the needs of the business with agility.
You will support the timely and accurate production of performance reports to key management forums of the Trust’s governance framework, including the Board and its sub committees. The post holder will be support and contribute to designing reports to meet customer requirements and undertaking thorough analysis of performance issues, including working with Collaboratives.
*Please note that this post and job description is subject to job evaluation/matching*
Main duties of the job
Deputise for the Workforce Intelligence Lead to manage the workload of the Workforce Intelligence Team.
Support the utilisation of ESR, MS 365, SQL, Microsoft Forms, Power Apps, Sharepoint and MS Power BI reporting function/software with creating bespoke reports and dashboards to fulfil organisational needs including SQL queries to extract, join, and validate data from data warehouse.
Plan the maintenance of the data warehouse for People Services.
Work with teams within People Services, Finance, E-Roster and Recruitment to ensure accurate data flow between interfaced systems, understanding the flow of information between these areas.
Ensure that information requests are completed in a timely manner and that excellent customer service is provided at all times.
Support the delivery of projects assigned by the ESR Systems Manager, e.g. the implementation of Self Service and other projects utilising ESR and/or other systems feeding from/to ESR.
Continuously support and implement the use of innovative workforce related technology supported by ESR including promotion of the use of mobile phone apps, manager and employee self-service and electronic employee contract/payroll/expense related forms.
Detailed job description and main responsibilities
Please see attached job description and person specification for further information regarding the role and the essential and desirable criteria required to be met by applicants.
CERTIFICATE OF SPONSORSHIP
Please note, due to changes implemented by the Government to the UK immigration policy, individuals who require a Health and Care Visa or a Skilled Worker Visa may no longer be eligible for sponsorship where the UKVI salary threshold is not met or if the occupation is not included in the updated Immigration Salary List (ISL). Applicants must check their eligibility to be employed in any role they are interested in applying for, prior to completing an application for employment. Any applicants who do not meet the eligibility criteria will not be progressed. For further information visit the UK Visas and Immigration website (Opens in a new tab).
If you are applying under the Disability Confident Scheme or Armed Forces Covenant and you meet all the essential criteria for a post, you will be guaranteed an interview.
Relocation assistance may be available for successful applicants moving to the region for certain posts. Please see our Policy for eligible vacancies.
Disclosure and Barring Service:
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
The cost of the DBS must be met by the successful candidate(s) through salary deduction. DBS charges are as follows if applicable to the post:
Standard Check: £21.50 + Administration cost of £6.50 = £28.00 Deducted from salary over a 4 month period or a one-off payment.
Enhanced Check: £49.50 + administration cost of £6.50 = £56.00 Deducted from salary over a 4 month period or a one-off payment.
NCIC can offer successful future employees the following benefits:
27-day holiday scheme rising to 33 after 10 years
Flexible working Scheme
NHS Discounts*
Salary Sacrifice schemes including lease cars and Cycle to Work*
Excellent opportunities for development*
Competitive NHS Pension scheme
Vivup is a free, confidential counselling and information service to assist with personal or work-related problems
*Subject to eligibility
Important Information
Please ensure that you document evidence of meeting all the essential criteria in the supporting information.
If sufficient response is received this post could be closed earlier than the specified closing date, please apply as soon as possible to ensure that your application is considered.
Candidates who have been successfully shortlisted for interview will be asked via an email notification to log on to their Trac account to select an interview time. This will usually be within 2 weeks of the closing date.
Person specification
Knowledge
Essential
- Good working knowledge of Electronic Staff Record (ESR) or other Oracle based workforce/payroll system
- Knowledge of SQL queries to extract, join, and validate data from data warehouse
- Understanding of MS SQL Server including SSMS,SSIS,SSRS
- Knowledge of legislation as it applies to workforce information e.g. GDPR
- Advanced knowledge of IT packages including but not limited to MS Office Suite and MS 365 and an ability to manipulate data.
- Knowledge and understanding of the NHS with a broad understanding of roles and workforce issues
- Knowledge of Information Governance and associated issues
- Knowledge of performance indicators (KPI’s) and performance management.
Desirable
- Knowledge of workforce informatics
- Knowledge of NHS data standards. Knowledge of other Health Care Information, e.g. Public Health, Manpower, etc.
- Knowledge of commissioning data flows.
Experience
Essential
- Experience working at a supervisory level in an admin role
- Experience in managing a team
- Skilled in ETL transformation using SQL Server and Power BI
- Experience in setting up new processes or process redesign
- Experience of delivering training or presenting information to an audience or similar experience
- Expert core user of data models in SQL and Power BI (star/snowflake schema understanding: fact and dimension table)
Desirable
- Service improvement experience
- Experience of working with managers at all levels
- Database administration experience
Qualifications
Essential
- Educated to degree level in an IT related subject or equivalent qualification or experience
Desirable
- Prince 2 / project. management
- Evidence of management training or in a challenging environment
Skills and Aptitudes
Essential
- Ability to provide and receive complex information
- Developed analytical/investigative skills gained through appropriate qualification or working experience
- Excellent interpersonal skills including the ability to build working relationships with internal and external colleagues
- Systematic approach to problem solving
- Excellent proven customer service skills
- Good level of numeracy and literacy
- Ability to work without close supervision and use own initiative
- Ability to work to flexibly and to deadlines whilst under pressure, balancing conflicting workloads.
- Work methodically with accuracy ensuring attention to detail
- Good SQL skills to extract data from multiple sources
- Good information technology skills, particularly database related.
- Ability to manage multiple tasks and projects.
- Ability to relate effectively to a wide range of stakeholders in a variety of settings and cultures.
Desirable
- Demonstrable recent experience
Personal Circumstances
Essential
- Ability to travel county wide across Cumbria and the North East to attend meetings/deliver training independent of public transport
- Ability to organise own and team workload and prioritise appropriately
- Positive/Assertive
- Approachable
- Demonstrate initiative
- Ability to work under pressure
- Assertive, polite and tactful
WhatsApp job alerts
Get instant WhatsApp alerts for Band 5 Manager and Corporate roles in Carlisle
Create your Job Clerk account first. We'll collect your alert preferences during onboarding and help you turn on WhatsApp notifications for matching healthcare roles.
Applying for this NHS job
This advert is for Deputy Workforce Intelligence Lead with North Cumbria Integrated Care NHS Foundation Trust in Carlisle, North East and Yorkshire, England. It is listed as a Band 5 Manager and corporate role. The advertised salary is £32,073 - £39,043 Per Annum Pro Rata. The contract type is Permanent. The application deadline is 06 Aug 2026.
Before you apply, compare the job description with the person specification and mirror the employer's essential criteria in your supporting information. Use the vacancy title, employer, location, salary, contract type, closing date and posted date (23 Jul 2026) to decide whether this role fits your current NHS job search. If the employer can close applications early, prepare the application before the stated deadline rather than waiting for the final day.
For more context, review related Job Clerk pages for the same profession, band or location where they exist, then use the application-support guides to tailor your statement and prepare for interview.