NHS

Business Analytics Manager


Pay43,742.00 - 50,056.00 / year
LocationRedhill/England
Employment typeFull-Time

This job is now closed

  • Job Description

      Req#: B9078-FC991?language=en&page=957&sort=publicationDateDesc

      Job summary

      The Performance & Business Intelligence Team has a fantastic opportunity for an enthusiastic professional to join our team as Business Analytics Manager.

      We are looking for a motivated, proactive self-driven individual who is ready and willing to make an impact in our small team.

      We are a close-knit team and work very collaboratively with our colleagues throughout the organisation and beyond within the wider NHS. You must be passionate about delivering positive change, embrace problem-solving opportunities, and take pride in data quality.

      You will be responsible for the production of performance reports, the development of new dashboards in Power BI while overseeing the maintenance and modifying existing ones, creating and running SQL queries to provide data that our operational team, managers, ICB and NHSE requires.

      Keen data analysis skills and strong quality focus will be very useful in the role as well as being able to work to deadlines.

      The role provides a great opportunity to use your current skill-set and grow it in a busy environment where your work really makes a difference to our Patients in the local community. This brings real satisfaction to the role.

      Main duties of the job

      The overall purpose of the Performance and Business Intelligence manager role is to identify and support performance improvement and sustainability by developing and managing robust performance management processes that provide the Organisation, its commissioners and partners with assurance and business intelligence in relation to current and future performance.

      This will include working with the Head of Performance and Business Intelligence to support the design of specific Corporate projects and to develop our overall corporate assurance process, utilising developed organisational, inter- personal, and project management skills, as well as then managing the testing and implementing of the resulting systems.

      About us

      Do you want to be part of an organisation that was rated best provider of NHS care to work for nationwide? (2023 staff survey results)

      First Community is a staff owned social enterprise rated Good by CQC, which delivers NHS community services across east Surrey and parts of West Sussex. We are looking for individuals who share our values First-rate care, First-rate people, First-rate value.

      First Community is a great place to work, everyone has a voice and is supported to develop their career to its full potential. We offer all our staff: NHS terms and conditions, high quality training and development opportunities, flexible working to enable a good work life balance, an inclusive and friendly work environment, an NHS pension, flexible retirement options and various employee benefits.

      Please talk to us before applying or at interview about the flexibility you need. We may not be able to meet your needs exactly, but we do promise to fully consider your request and meet your needs where possible. Please note, flexible working options may vary depending on the role.

      At First Community we welcome applications from black, Asian and minority ethnic candidates, LGBTQ+ candidates and candidates with disabilities. We ensure that all applicants are treated fairly and consistently at every stage of the recruitment process, including the consideration of reasonable adjustments.

      Sustainability is integral to First Community achieving the NHS Net Zero target.

      Date posted

      13 September 2024

      Pay scheme

      Agenda for change

      Band

      Band 7

      Salary

      £43,742 to £50,056 a year +5% HCAS, per annum, pro rata

      Contract

      Permanent

      Working pattern

      Full-time, Flexible working

      Reference number

      B9078-FC991

      Job locations

      First Community Health & Care

      Bonehurst Road

      Redhill

      RH1 5EL


      Job description

      Job responsibilities

      The overall purpose of the Performance and Business Intelligence manager role is to identify and support performance improvement and sustainability by developing and managing robust performance management processes that provide the Organisation, its commissioners and partners with assurance and business intelligence in relation to current and future performance.

      The managers aim is to empower the organisation to gain a holistic understanding of performance, to facilitate improved and sustained outcomes and enable the growth of the organisation, supported by robust Business Intelligence.

      The Performance and Business Intelligence Manager will support the development and monitoring of the Organisations Performance Management Framework including, coordination, performance assessment and performance management of the Key Performance Indicators (KPIs) and CQUINS.

      This will include working with the Head of Performance and Business Intelligence to support the design of specific Corporate projects and to develop our overall corporate assurance process, utilising developed organisational, inter- personal, and project management skills, as well as then managing the testing and implementing of the resulting systems.

      The role requires significant leadership, co-ordination, information analysis, time management, in addition to the ability to produce clear, concise and well- articulated written responses.

      The role will also require agile and creative solutions as part of implementing the overarching Performance and Business Intelligence Strategy.

      When completing your application please refer to both the Application Guide and full Job Description - these can be found under supporting documents.

      Job description

      Job responsibilities

      The overall purpose of the Performance and Business Intelligence manager role is to identify and support performance improvement and sustainability by developing and managing robust performance management processes that provide the Organisation, its commissioners and partners with assurance and business intelligence in relation to current and future performance.

      The managers aim is to empower the organisation to gain a holistic understanding of performance, to facilitate improved and sustained outcomes and enable the growth of the organisation, supported by robust Business Intelligence.

      The Performance and Business Intelligence Manager will support the development and monitoring of the Organisations Performance Management Framework including, coordination, performance assessment and performance management of the Key Performance Indicators (KPIs) and CQUINS.

      This will include working with the Head of Performance and Business Intelligence to support the design of specific Corporate projects and to develop our overall corporate assurance process, utilising developed organisational, inter- personal, and project management skills, as well as then managing the testing and implementing of the resulting systems.

      The role requires significant leadership, co-ordination, information analysis, time management, in addition to the ability to produce clear, concise and well- articulated written responses.

      The role will also require agile and creative solutions as part of implementing the overarching Performance and Business Intelligence Strategy.

      When completing your application please refer to both the Application Guide and full Job Description - these can be found under supporting documents.

      Person Specification

      Knowledge

      Essential

      • Knowledge of Performance Management and project management tools and techniques
      • Knowledge of relevant national policy drivers and regional/local commissioning priorities
      • Advanced level of technical expertise and physical skills in the manipulation of spreadsheets and databases
      • Expert knowledge of Business Intelligence and Data Warehouse methodology and concepts (SQL Server 2008 onwards) and associated products (i.e. SSRS & SSAS)
      • Competent in dashboard creation using visualisation tools (e.g. Power BI & SSRS)
      • Excellent understanding of data modelling, report development, performance tuning and query

      Desirable

      • Understanding of NHS Contracting processes including CQUIN and Key Performance Indicators

      Other

      Essential

      • Able to travel to various sites across the East Surrey region

      Experience

      Essential

      • MS SQL Server - development
      • Design and implementation of complex data models used for Business Intelligence and Advanced Analytics
      • Design and implementation of complex ETL/ELT processes used for Business Intelligence and Advanced Analytics
      • Experience in a supervisory role
      • In-depth knowledge of NHS data and issues
      • Visualization and report writing skills
      • Significant experience of Performance management
      • Experience of complex change management and the delivery of successful outcomes
      • Experience of conversing with technical and non-technical colleagues to ensure robust requirements capture with staff at all levels of the organisation
      • Experience of working in a Public Sector organisation such as the NHS, Social Services or a Local Authority
      • Experience of working with managers and staff at all levels of an organisation.
      • Significant experience of Performance management
      • Significant experience of Performance management
      • Significant experience of report writing and the production of business documents
      • Significant project management experience
      • Experience of working with senior leadership and non- executive layers of an organisation

      Skills

      Essential

      • Ability to maintain a high degree of confidentiality at all times
      • Ability to analyse and assimilate a wide range of complex information and formulate it into appropriate presentational formats.
      • Ability to critically analyse complex and difficult situations and apply problem-solving skills
      • Ability to maintain a high degree of confidentiality at all times
      • Ability to manage a complex workload with conflicting demands on time and resources
      • Ability to produce work of a high standard to tight deadlines
      • Ability to think creatively, generate ideas and put them into practice, responding positively in a constantly changing environment in a motivational way
      • Ability to work with a significant degree of autonomy, seeking external reference points and guidance as appropriate.
      • Ability to work with various grades of staff and to adjust personal communication styles as required
      • Excellent interpersonal, communication and relationship building skills.
      • Flexible, reliable, conscientious, professional
      • Methodical approach with a high standard of accuracy
      • Office applications in addition to Microsoft SQL
      • Ability to work effectively within corporate structures and to effectively organise workflow through existing governance processes

      Desirable

      • Well-developed ability to use the full range of Microsoft

      Qualifications

      Essential

      • Master level qualification or Diploma level qualification with significant equivalent experience
      • Evidence of willingness to undertake further personal development.
      • Post-graduate Management / Project Management qualification, and/or significant equivalent experience
      Person Specification

      Knowledge

      Essential

      • Knowledge of Performance Management and project management tools and techniques
      • Knowledge of relevant national policy drivers and regional/local commissioning priorities
      • Advanced level of technical expertise and physical skills in the manipulation of spreadsheets and databases
      • Expert knowledge of Business Intelligence and Data Warehouse methodology and concepts (SQL Server 2008 onwards) and associated products (i.e. SSRS & SSAS)
      • Competent in dashboard creation using visualisation tools (e.g. Power BI & SSRS)
      • Excellent understanding of data modelling, report development, performance tuning and query

      Desirable

      • Understanding of NHS Contracting processes including CQUIN and Key Performance Indicators

      Other

      Essential

      • Able to travel to various sites across the East Surrey region

      Experience

      Essential

      • MS SQL Server - development
      • Design and implementation of complex data models used for Business Intelligence and Advanced Analytics
      • Design and implementation of complex ETL/ELT processes used for Business Intelligence and Advanced Analytics
      • Experience in a supervisory role
      • In-depth knowledge of NHS data and issues
      • Visualization and report writing skills
      • Significant experience of Performance management
      • Experience of complex change management and the delivery of successful outcomes
      • Experience of conversing with technical and non-technical colleagues to ensure robust requirements capture with staff at all levels of the organisation
      • Experience of working in a Public Sector organisation such as the NHS, Social Services or a Local Authority
      • Experience of working with managers and staff at all levels of an organisation.
      • Significant experience of Performance management
      • Significant experience of Performance management
      • Significant experience of report writing and the production of business documents
      • Significant project management experience
      • Experience of working with senior leadership and non- executive layers of an organisation

      Skills

      Essential

      • Ability to maintain a high degree of confidentiality at all times
      • Ability to analyse and assimilate a wide range of complex information and formulate it into appropriate presentational formats.
      • Ability to critically analyse complex and difficult situations and apply problem-solving skills
      • Ability to maintain a high degree of confidentiality at all times
      • Ability to manage a complex workload with conflicting demands on time and resources
      • Ability to produce work of a high standard to tight deadlines
      • Ability to think creatively, generate ideas and put them into practice, responding positively in a constantly changing environment in a motivational way
      • Ability to work with a significant degree of autonomy, seeking external reference points and guidance as appropriate.
      • Ability to work with various grades of staff and to adjust personal communication styles as required
      • Excellent interpersonal, communication and relationship building skills.
      • Flexible, reliable, conscientious, professional
      • Methodical approach with a high standard of accuracy
      • Office applications in addition to Microsoft SQL
      • Ability to work effectively within corporate structures and to effectively organise workflow through existing governance processes

      Desirable

      • Well-developed ability to use the full range of Microsoft

      Qualifications

      Essential

      • Master level qualification or Diploma level qualification with significant equivalent experience
      • Evidence of willingness to undertake further personal development.
      • Post-graduate Management / Project Management qualification, and/or significant equivalent experience

      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.

      Employer details

      Employer name

      First Community Health and Care

      Address

      First Community Health & Care

      Bonehurst Road

      Redhill

      RH1 5EL


      Employer's website

      https://www.firstcommunityhealthcare.co.uk/ (Opens in a new tab)

      Employer details

      Employer name

      First Community Health and Care

      Address

      First Community Health & Care

      Bonehurst Road

      Redhill

      RH1 5EL


      Employer's website

      https://www.firstcommunityhealthcare.co.uk/ (Opens in a new tab)

  • About the company

      National Health Service (NHS) is the umbrella term for the publicly-funded healthcare systems of the United Kingdom (UK). The founding principles were that services should be comprehensive, universal and free at the point of delivery—a health service based on clinical need, not ability to pay. Each service provides a comprehensive range of health services, free at the point of use for people ordinarily resident in the United Kingdom apart from dental treatment and optical care.