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