Data Analyst: Excel Business Intelligence Specialist

2 weeks ago


Liverpool, Liverpool, United Kingdom NHS Full time
Alder Hey Children's NHS Foundation Trust

An exciting opportunity is available to join our team as a Workforce Information Analyst, based at Liverpool Innovation Park, Edge Lane, Liverpool. As a member of the Human Resources Team, you will play a key role in providing high-quality workforce information to support managers in planning their workforce for the future.

The successful candidate will be responsible for producing complex workforce information, providing training and support to ESR users, and developing accurate reporting systems for the Trust. They will also have line management responsibility for the Workforce Information Assistant and be responsible for their development and support.

The ideal candidate will have a strong background in data analysis, with experience in collecting, analysing and interpreting large quantities of complex data. They will also have excellent analytical, communication and interpersonal skills, with the ability to motivate and inspire others.

This role would suit someone who has experience in HR management information systems and processes, with a detailed knowledge of the Electronic Staff Record (ESR) system and its functionality.

Main Duties of the Job

The Workforce Information Analyst will be responsible for the following duties:

  1. Specifying, designing and providing reports to meet local, regional and national requirements, using ESR tools (ESRBI).
  2. Supporting the development of action plans for Division/Corporate Service areas to attain and maintain performance levels within Trust thresholds with regard to all workforce related KPIs.
  3. Carrying out benchmarking to support the delivery of high-level management workforce information.
  4. Producing and coordinating information for external returns (e.g. NHSI, WRES) and major internal reports (corporate report), ensuring timely delivery to agreed deadlines and to high levels of accuracy.
  5. Updating records on the ESR system, including employee personal details and the organisational hierarchy.
  6. Supporting the administration of routine checking of employees professional registrations, including contacting employees, accessing the appropriate professional organisations website, managing the ESR professional registrations interfaces and updating the employees personal record accordingly.
  7. Undertaking regular audits of data, liaising with relevant departments to ensure that necessary data fields are complete, accurate and that data inputting procedures are being followed.
  8. Preparing ad-hoc reports on the workforce (e.g. FOI requests, HR team request).
  9. Reporting on learning & development, and appraisal activity, providing analysis of activity, trends, equality and diversity monitoring etc.
  10. Attending user group meetings as a deputy for the Workforce Information Manager when required and any meetings with other departments where there is a need for ESR expertise or/and the provision of workforce information to support projects.
  11. Promoting and maintaining data quality within ESR and other workforce systems.
  12. Administering ESR, including setting up new users, allocating the appropriate levels of responsibility.
  13. Auditing ESR users regularly to ensure access rights are appropriate at all times and any leavers records have been terminated.
  14. Supporting an efficient ESR helpdesk service for users by providing timely support and advice.

Training and Staff Development

The Workforce Information Analyst will be responsible for the following duties:

  1. Regularly training HR and Managers across the Trust in the use of ESR, producing relevant training, guidance and support documentation.
  2. Providing training and development to the Workforce Information Assistant, being a point of contact for queries and escalations.
  3. Supporting the Workforce Information Manager to plan, manage and implement defined ESR related projects.
  4. Assisting where appropriate in the delivery of internal HR events, including induction as directed.
  5. Participating in specific project areas as agreed with the Workforce Information Manager.
  6. Liaising and working with HR colleagues as appropriate to maintain effective communication, ensuring that best practice is shared and developed and to facilitate cross cover for colleagues.


  • Liverpool, Liverpool, United Kingdom Launch Resources Limited Full time

    About the RoleWe are seeking a highly skilled Business Intelligence Analyst to join our team at Launch Resources Limited. As a key member of our Business Intelligence & Information Systems team, you will be responsible for developing new reporting solutions, implementing enhancements, and providing day-to-day support.Key ResponsibilitiesDevelop and implement...


  • Liverpool, Liverpool, United Kingdom Launch Resources Limited Full time

    About the RoleWe are seeking a highly skilled Business Intelligence Analyst to join our team at Launch Resources Limited. As a key member of our Business Intelligence & Information Systems team, you will be responsible for developing new reporting solutions, implementing enhancements, and providing day-to-day support.Key ResponsibilitiesDevelop and implement...


  • Liverpool, Liverpool, United Kingdom Launch Resources Limited Full time

    About the RoleWe are seeking a highly skilled Business Intelligence Analyst to join our team at Launch Resources Limited. As a key member of our Business Intelligence & Information Systems team, you will be responsible for developing new reporting solutions, implementing enhancements, and providing day-to-day support.Key ResponsibilitiesDevelop and implement...


  • Liverpool, Liverpool, United Kingdom Launch Resources Limited Full time

    About the RoleWe are seeking a highly skilled Business Intelligence Analyst to join our team at Launch Resources Limited. As a key member of our Business Intelligence & Information Systems team, you will be responsible for developing new reporting solutions, implementing enhancements, and providing day-to-day support.Key ResponsibilitiesDevelop and implement...

  • "Data Analyst

    1 week ago


    Liverpool, Liverpool, United Kingdom Launch Resources Limited Full time

    Job Title: Data Analyst - BI SpecialistAbout the Role:We are seeking a skilled Data Analyst - BI Specialist to join our Business Intelligence & Information Systems team. As a key member of our team, you will be responsible for developing new reporting solutions, implementing enhancements, and providing day-to-day support.Main Responsibilities:Develop new...


  • Liverpool, Liverpool, United Kingdom Matalan Full time

    We are seeking a skilled Business Intelligence Analyst to join our team at Matalan Support Hub. The ideal candidate will have a strong background in data analysis and be able to develop bespoke insights and reporting to inform business decisions.The successful candidate will be responsible for gathering data from various sources, developing data...


  • Liverpool, Liverpool, United Kingdom Launch Resources Limited Full time

    Our client, a leading law firm in the UK, is seeking a skilled Business Intelligence Analyst to join their team. As a key member of the Business Intelligence & Information Systems team, you will be responsible for developing new reporting solutions, implementing enhancements, and providing day-to-day support.The ideal candidate will have strong SQL skills,...


  • Liverpool, Liverpool, United Kingdom Agility Resoucing Full time

    Job Summary:We are seeking a recent graduate to join our team as a Data Analyst, where you will be part of an exciting graduate scheme to develop your skills in data analysis and business intelligence.Key Responsibilities:Conduct business discovery and statistics to drive business decisionsCommunicate complex data insights to stakeholdersProduce reports for...

  • Intelligence Analyst

    3 weeks ago


    Liverpool, Liverpool, United Kingdom Royal Air Force Full time

    Job DescriptionThe Royal Air Force (RAF) is seeking highly skilled Intelligence Analysts to join our team. As an Intelligence Analyst, you will play a critical role in collecting, analyzing, and disseminating intelligence to support RAF operations.Key Responsibilities:Collect and analyze intelligence from various sources, including human intelligence,...


  • Liverpool, Liverpool, United Kingdom Fashion Jobs Full time

    About the RoleWe are seeking a skilled Business Intelligence Analyst to join our team at Matalan. The successful candidate will be responsible for gathering data from various sources, developing insights and reporting, and communicating findings to stakeholders.The ideal candidate will have a strong understanding of database technologies, including SQL...

  • Data Analyst

    2 months ago


    Liverpool, Liverpool, United Kingdom Agility Resoucing Full time

    Join Our Team as a Data AnalystWe are seeking a recent graduate to join our team as a Data Analyst, where you will have the opportunity to develop your skills in data analysis and business intelligence.Key Responsibilities:Business discovery and statisticsCommunicating with stakeholdersProducing reports to be used by Accounts departmentsGenerating and...


  • Liverpool, Liverpool, United Kingdom Agility Resoucing Full time

    Agility Resourcing is seeking a talented Graduate Data Analyst to join their team in a fast-paced retail environment. As a key member of the team, you will be responsible for analysing data to identify trends and patterns, and providing insights to inform business decisions.Key Responsibilities:Develop and maintain databases to store and analyse dataDesign...

  • Data Analyst

    1 month ago


    Liverpool, Liverpool, United Kingdom Keoghs Full time

    Job Title: Adults Data AnalystThis is a unique opportunity to join a growing division, working across a variety of corporate insurance programmes and for some of the best known and loved UK brands. The opportunity is for a Data Analyst to support the Client Service Team, Sector Leaders and Client Account Managers with delivery of analytical insight by...

  • Data Analyst

    1 month ago


    Liverpool, Liverpool, United Kingdom Keoghs Full time

    Job Title: Adults Data AnalystThis is a unique opportunity to join a growing division, working across a variety of corporate insurance programmes and for some of the best known and loved UK brands. The opportunity is for a Data Analyst to support the Client Service Team, Sector Leaders and Client Account Managers with delivery of analytical insight by...


  • Liverpool, Liverpool, United Kingdom Serco Full time

    Serco's Citizen Services team is seeking an experienced Senior Business Intelligence Analyst to join our UK & Europe Division.Key ResponsibilitiesMaximise the use of PowerBI tools across all contracts and ensure all relevant processes are adhered to.Maintain regular communication with stakeholders, providing regular business commentary.Complete operational...


  • Liverpool, Liverpool, United Kingdom Serco Full time

    Serco's Citizen Services team is seeking an experienced Senior Business Intelligence Analyst to join our UK & Europe Division.Key ResponsibilitiesMaximise the use of PowerBI tools across all contracts and ensure all relevant processes are adhered to.Maintain regular communication with stakeholders, providing regular business commentary.Complete operational...


  • Liverpool, Liverpool, United Kingdom Matalan Full time

    About the RoleWe are seeking a highly skilled Loyalty and CRM Analyst to join our team at Matalan Support Hub. As a key member of our Data and Analytics team, you will play a crucial role in driving business growth through data-driven insights.Key ResponsibilitiesDevelop and maintain analyses related to customer understanding, CRM, and marketing...


  • Liverpool, Liverpool, United Kingdom Matalan Full time

    About the RoleWe are seeking a highly skilled Loyalty and CRM Analyst to join our team at Matalan Support Hub. As a key member of our Data and Analytics team, you will play a crucial role in driving business growth through data-driven insights.Key ResponsibilitiesDevelop and maintain analyses related to customer understanding, CRM, and marketing...


  • Liverpool, Liverpool, United Kingdom Serco Full time

    Serco's Citizen Services team is seeking an experienced Senior Business Intelligence Analyst to join our UK & Europe Division. Key Responsibilities Maximise the use of PowerBI tools across all contracts and ensure all relevant processes are adhered to.Maintain regular communication with stakeholders in area of expertise providing regular business...


  • Liverpool, Liverpool, United Kingdom Agility Resoucing Full time

    Lead Business Intelligence and Data AnalyticsWe are seeking a senior business intelligence leader to drive business growth and profitability through data-driven decision making. As a key member of our team at Agility Resourcing, you will leverage your expertise in data analytics to develop and implement robust initiatives that deliver exceptional results.Key...