Close

Finance & Workforce Data Analyst Apprentice X2

INTRODUCTION 

Public Health England provides strategic leadership and vision for protecting and improving the nation’s health. Its ambition is to lead nationally, and enable locally, a transformation in the health expectations of all people in England, regardless of where they live and the circumstance of their birth. It will achieve this through the application of research, knowledge and skills. PHE is an executive agency of the Department of Health. It is a distinct delivery organisation with operational autonomy to advise and support government, local authorities and the NHS in a professionally independent manner. 

The Finance & Commercial Directorate’s aim is to provide PHE with efficient, effective and economic financial, IT, estates and facilities and business development services to enable PHE to achieve its strategic goals, as well as taking the lead on a number of general activities. 

The Financial Management (FM) service sits within the wider finance function and is formed of local teams whose roles cover budget setting and budget monitoring, financial analysis & financial modelling, revenue activity and for the provision of a comprehensive business partnering service.  Revenue project accounting and the accounting for the local authority public health grant also fall under the remit of the FM department. Management and maintenance of the Agency’s financial systems also sits within the FM service. 

JOB SUMMARY  

The FM Department, formed of a network of staff based in the PHE’s operational centres/divisions, is the primary resource for financial management, analysis and decision support. 

The purpose of the role is to support the FM Section in the production of accurate, meaningful and insightful reporting of workforce information using the tools available to aid decision support within FM and the wider agency and to provide the corporate workforce reports to external organisations as required. 

DESCRIPTION OF TRAINING  

The post holder will be supported to achieve a Level 4 Apprenticeship as Data Analyst. Through academic and work place activities, the post holder will develop the skills required in the job description, to work in a quality driven, responsive and customer orientated department.  

An apprentice will do 80% on the job training – work based learning activity and the remaining 20% is off the job training (self-directed learning and classroom attendance.)  

The apprenticeship is a work-based qualification evidenced via learning activity at work, a portfolio of work and observations. Training and assessment are completed on work-site, with some off the job training involving a combination of online learning, classroom attendance, webinars and self-directed learning. An external assessor will carry out observations in the workplace to assess practical competence.  

All apprenticeship standards have End-point assessment (EPA). End-Point Assessments will involve an independent assessor carrying out final assessments with the apprentice, to ensure that the competences and learning within the ‘Apprenticeship Standard’ have been met. Apprentices can achieve a pass, merit or distinction dependent on how well they perform in their End-Point Assessment.  

You will be required to commit to the apprenticeship training study requirements and complete the training activities and assessments, in given timescales.  

Training: Level 4 Data Analyst Apprenticeship 

COMMUNICATION AND KEY WORKING RELATIONSHIPS 

Internal 

  • Head of Finance (Reporting, Integrated Workforce and Systems) 
  • Senior Financial Reporting and Workforce Information Manager 
  • Deputy Financial Reporting and Workforce Information Manager 
  • All staff within the Financial Management department and the wider home Directorate 
  • Staff within Human Resources 

External 

  • External Stakeholders and bodies, especially Department of Health and Office of National Statistics. 
  • External Auditors. 
MAIN DUTIES AND RESPONSIBILITIES 
  • To be responsible for executing the scheduled and ad hoc workforce and establishment reports, created by a senior team member, in a timely fashion as required to meet FM and wider PHE requirements. 
  • To analyse the reporting requirements and assess delivery mechanisms to ensure that the accurate, meaningful and insightful reports are produced and delivered in the most efficient manner along with the senior team member. 
  • To liaise with PHE People Directorate and external payroll provider to ensure data is correct can be reported on to agreed requirements. 
  • To produce regular reports on workforce, headcount, WTE, turnover and sickness for the PHE Board and other levels of the agency as required. 
  • To analyse and recommend, new procedures relating to workforce and establishment reporting to continue to meet the evolving needs of the organisation.  
  • Work with colleagues to revise and improve procedures.  
  • To fulfill PHE’s external workforce reporting requirements with a senior team member, especially, but not limited to, the Department of Health and Office of National Statistics 
  • To carry out other projects and functions as agreed with the Deputy Head of Financial Management (Reporting, Workforce and Systems)’, Senior Financial Reporting and Workforce Information Manager or Deputy Financial Reporting and Workforce Information Manager
Essential qualifications

Good standard of education – minimum GCSEs A-C level including English and maths or equivalent (Level 2 is equivalent to GCSE grades A*- C ; new GCSE 4  9) 

Please note: Applicants with a Diploma, Level 4 Qualification or Higher in a Similar field will be ineligible for this post as it is an Apprenticeship. 

Knowledge and experience (Experience as defined by type/level, not length)

Desirable:

  • Experience of data management, including input, analysis and reporting to a non-technical audience 
  • Experience of analysing complex data from a variety of sources and producing meaningful reports 
  • Experience of working with multiple database and reporting packages 
Essential skills and capabilities 
    • Working knowledge of databases, spreadsheets and reporting software packages. 
    • Ability to analyse requirements and recommend presentation of information from a variety of sources using multiple database applications 
    • Microsoft Office packages with advanced knowledge of Excel. 
    • Prioritising and managing own time 
    • Skills for manipulating information 
    • Advanced keyboard skills, use of a range of software
    • 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
Other 

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. 

The details:

Salary: £20,360/annually

Hours: 37.5 hrs, Monday to Friday

Location: Public Health England, 61 Colindale Ave, London NW9 5EQ

Apprenticeship:  Data Analyst L4