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.
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.