Deputy Workforce Intelligence Lead
Job summary
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.
About us
At NCIC, we have an ambition to deliver outstanding healthcare services to the population of North Cumbria. The Trust is committed to creating a centre of excellence in providing rural and remote healthcare and provides a wide range of community and acute services throughout our county.
Our 5 key principles demonstrate our belief in the delivery of 'safe, high quality care every time':
- Being a clinically led organisation
- Quality and safety at the heart of our Trust
- A positive patient experience every time
- A great place to work
- Managing our money well
As an organisation we are serious about supporting a diverse workforce that reflects our local community and are very much focused on being an inclusive and compassionate place to work.
Across the North East and North Cumbria we are working together to deliver our ambition to be the greenest region in England by 2030. All staff are expected to support sustainability.
Job description
Job 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 theUK Visas and Immigration website.
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
Qualifications
- Educated to degree level in an IT related subject or equivalent qualification or experience
- Prince 2 / project. management
- Evidence of management training or in a challenging environment
Experience
- 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)
- Service improvement experience
- Experience of working with managers at all levels
- Database administration experience
Knowledge
- 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.
- 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.
Skills and Aptitudes
- 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.
- Demonstrable recent experience
Personal Circumstances
- 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
Disclosure and Barring Service Check
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.
Certificate of Sponsorship
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website.
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants.
Employer details
Employer name
North Cumbria Integrated Care NHS Foundation Trust
Address
Parkhouse
Kingmoor Park, Baron Way
Carlisle
CA6 4SJ
United Kingdom
Employer's website
https://www.ncic.nhs.uk/