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. This role is hybrid, with a mix of home working and office. 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 is committed to providing first rate care and services to its local community? First Community is a CQC rated Good staff owned social enterprise, which delivers NHS community services to residents across east Surrey and in parts of West Sussex. First Community is a great place to work, everyone here 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 employee benefits including a car salary sacrifice scheme. First Community values diversity and inclusion and is committed to the recruitment and retention of under-represented minority groups. We particularly welcome applications from black, Asian and minority ethnic candidates, LGBTQ candidates and candidates with disabilities. Sustainability is integral to First Community achieving the NHS Net Zero target. All staff are therefore actively encouraged and supported to implement new ways of working within their field of expertise. Applicants are advised to apply early as we reserve the right to close the advert prior to the advertised closing date should we receive a large number of applications. Date posted 22 April 2025 Pay scheme Agenda for change Band Band 7 Salary £46,148 to £52,809 a year 5% HCAS Contract Permanent Working pattern Full-time, Flexible working Reference number B9078-FC1029-1 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, co-ordination, 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. Please see attached document for full job description. 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, co-ordination, 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. Please see attached document for full job description. Person Specification 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 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 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 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 Well-developed ability to use the full range of Microsoft Ability to work effectively within corporate structures and to effectively organise workflow through existing governance processes. Desirable Office applications in addition to Microsoft SQL. Other Essential Able to travel to various sites across the East Surrey region. 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 Person Specification 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 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 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 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 Well-developed ability to use the full range of Microsoft Ability to work effectively within corporate structures and to effectively organise workflow through existing governance processes. Desirable Office applications in addition to Microsoft SQL. Other Essential Able to travel to various sites across the East Surrey region. 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 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)