Job summary
Are you a data enthusiast with a passion for transforming raw information into actionable insights?
Join us as a Business Intelligence Analyst, where you'll leverage your SQL expertise to extract and analyse data, creating compelling reports through SSRS and PowerBi.
Your analytical skills will be crucial in providing valuable insights, making complex data understandable for staff across our organization.
As a key player in our business intelligence initiatives, you'll have the opportunity to contribute to our growth and success. If you thrive on challenges, excel in data interpretation, and enjoy translating information into meaningful stories, this role is tailor-made for you. Be part of a dynamic team where your skills make a real impact.
Main duties of the job
As a Business Intelligence Analyst, you'll spearhead data-driven decision-making by writing intricate SQL queries for data extraction and analysis.
Your expertise in developing visually compelling reports using SSRS and PowerBi will be pivotal. Leverage your analytical skills to interpret complex datasets, providing valuable insights that resonate across the organisation.
Your role includes translating raw data into understandable narratives for diverse stakeholders, contributing to strategic decision-making.
Collaboration is key, working closely with teams to identify opportunities for process improvement. This role demands a keen eye for detail, a passion for data storytelling, and effective communication skills to convey insights to a broad audience.
About us
We are a provider of NHS
Community Health Services, CityCare exists to support the health and wellbeing
of all local people, working alongside other health and care partners to
achieve this. We are a value driven, people business with a passion for excellence.
Our vision and social purpose is to make a difference everyday to the health
& wellbeing of our communities and our values of kindness, respect, trust
and honesty lie at the heart of everything we do, guiding how we work together
with partners and each other to consistently deliver high quality compassionate
care. As a social enterprise we aim to add social value by investing in the
future of our local communities and helping to make a difference in peoples
lives.
CityCare value the benefits of a diverse and inclusive
workforce. We encourage applications from candidates who identify as disabled,
LGBT+ or from a Black, Asian or Minority Ethnic (BAME) background, as they are
currently under-represented within our organisation.
CityCare is an equal opportunities employer. We are positive
about employing people with disabilities. If you require your application in a
different format please contact Human Resources on 0115 8839418. CityCare is
committed to the protection of vulnerable adults and children.
Job description
Job responsibilities
Job Purpose
- Nottingham CityCare Partnership is a Social Enterprise providing a range of HealthCare services in community settings within the City of Nottingham. The Business Team is responsible for monitoring contracts with our commissioners and supporting the business functions of the organisation.
- The Business Intelligence Analyst will be part of a small team and will support and develop the delivery of information and business intelligence throughout the organisation. The role will be responsible for the development and management of key performance indicators across a portfolio of services, providing data analysis and business intelligence support to the Business and Contracts Managers, Assistant Directors, Senior Managers, Clinical Managers and operational staff.
- The post holder will work with partner organisations and clinical services to ensure that information systems are efficient, robust and able to collect accurate information on the activity undertaken by the services. Analysis of this data will support both the ongoing work of CityCare, new innovations and opportunities to develop the business.
- An important part of the role will be to provide first level support to clinical services to enable them to monitor and resolve data quality issues and to support development of their understanding of performance information, enabling them to make decisions based on the analysis provided.
- The role will further support the Business Intelligence Developer in maintaining and developing the server, data warehouse and reporting tools for the organisation.
Dimensions
- To develop complex analysis and insight across adult and childrens services
- To be responsible for a portfolio of services alongside local and national data returns
- To be involved in the training and support for managers and services
- Supervision of junior staff, apprenticeships or agency staff as required
- Based at Aspect House with an expectation to visit services within other CityCare locations when required, to attend meetings and provide support on data and analysis
Key Responsibilities
Business & Commissioners
- To be responsible for the development and management of key performance indicators and meeting the information needs of operational teams; leading on providing accurate and timely reports across an agreed portfolio of services, evidencing performance and providing headline analysis and information to services, the CityCare Board and commissioners.
- As part of the Business Team, the post holder will support the creation and continuous development of the organisations contractual submissions, across both adult and childrens services. In this capacity the post holder will work autonomously within the remit of their portfolio, accessing advice and support from their line manager as needed.
- To develop and implement processes and solutions to assist senior managers and relevant project teams to meet planning, performance and service information requirements.
- To provide timely and accurate headline performance information to inform reviews, contract meetings and on an ad-hoc basis, including early identification of any performance issues.
- To provide accurate information to support new business opportunities, tenders and bids in the format required and to deadlines.
- To support clinical services in future decision making and operational changes by providing and developing analytical tools and solutions.
- To undertake analyses to support CityCares key functions, providing information that will inform key business decisions made by CityCare and their commissioners.
- To participate, interpret and develop reports and submissions to support the wider Integrated Care System.
Analysis and Strategic Reporting
- To develop complex analysis and insight across adult and childrens services by using a wide range of extraction and analytical techniques to interrogate and report from both corporate clinical systems and stand-alone data bases including SystmOne, data warehouse and other smaller stand-alone systems. It is therefore essential the post holder have experience in specialist application software and programming languages, including SQL Server Integration Services (SSIS) packages, SQL Server Reporting Services (SSRS), Power BI and advanced skills in SQL and Excel.
- The post holder will be expected to use specialist skills, knowledge and experience to support their portfolio of services in achieving contractual reporting requirements and internal metrics as appropriate, whilst working as part of a team to share such skill, knowledge and experience over the wider adult, childrens and corporate services. As well as this, the post holder would also be expected to support their portfolio of services in making operational decisions and improvement via the use of their analytical skills.
- To be responsible for the analytical development and management of key performance indicators across a portfolio of services, using a range of tools to provide data analysis and business intelligence, to support the development and management of the performance report, CCG submission and Board report.
- There would be an expectation that the post holder will be enthusiastic in attending training and building knowledge in using new reporting tools, working as part of the team to ensure technical skills are shared and advanced to support the organisation in moving business intelligence forward.
To develop reports and analysis that :
- Highlight variations in past performance and predict future performance, trends, anomalies and outliers
- To provide an expert resource in both the technical skills required to create reports and also the design of dashboards to communicate information and intelligence effectively.
- Inform of potential benefits to the business and develop understanding of new and existing markets
- Highlight any assumptions, levels of confidence and shortfalls of the approach taken.
- Incorporate financial information where required to enable an analysis of cost and activity
- Meet ad-hoc requests as necessary
- To support the collection, analysis and delivery of data and performance management information on third party contracts.
- To produce and validate information that contributes to statutory reporting to the Department of Health and fulfils CityCares corporate information reporting commitments
- To communicate highly complex concepts of specialist software to a wide audience of varying technical ability including difficult to understand concepts related to Business Intelligence including how it works and how to use it most effectively
Services
- To be responsible for the analytical development and management of key performance indicators and meeting the information needs of operational teams, against an agreed portfolio of services, through Reporting System in SQL Server Reporting Services (SSRS), Power BI and through the use of the organisations clinical system, SystmOne.
- The post holder will be expected to work with operational staff, Team Managers and Heads of Services to deal with all manner of queries, supporting requests from internal and external parties.
- To support third party sub-contracts in gathering and delivering in contractual information.
- To support services to improve their information knowledge, enabling them to make decisions based on the information the post holder provides, and to develop an ownership of their performance data, enabling them to use their information as a management tool to develop their service and identify new business opportunities.
- To develop a suite of data quality and validation reports to be used by the portfolio of services, and the continuous management and development of these, ensuring the service is fully engaged in the understanding of how such reports support the service, wider performance and business intelligence.
- To promote to services the importance of using high quality information to support business decisions and to help services identify and address data quality issues to support this.
- To provide support and guidance for SystmOne projects for new services and current service reviews, taking responsibility to ensure information requirements, both contractual and internal are met and reportable.
- To identify and facilitate any required changes to SystmOne and other clinical systems in use, on an ongoing basis to support performance monitoring, future strategic service development and potential new business.
- To proactively engage with services, enabling and supporting them to deliver high quality accurate performance information to deadlines.
To act as a first point of contact for services requiring first line support within agreed timescales:-
- In the use and interpretation of data
- One-off/short term problem solving and advice on data and information related problems.
- Adapting any first line solutions to the understanding and technical ability of the audience.
- If necessary escalate any serious issues requiring sustained input or training.
- To provide second line, detailed support and training to services who have been identified through the escalation procedure. This will be in a problem solving and enabling role.
- To support services with audit processes, research and development, and evaluation of clinical outcomes.
- To support services to develop ownership of their performance data and enable them to use their information as a management tool to develop their service and identify new business opportunities.
Please see the attached Job Description for full details of the job role.
Job description
Job responsibilities
Job Purpose
- Nottingham CityCare Partnership is a Social Enterprise providing a range of HealthCare services in community settings within the City of Nottingham. The Business Team is responsible for monitoring contracts with our commissioners and supporting the business functions of the organisation.
- The Business Intelligence Analyst will be part of a small team and will support and develop the delivery of information and business intelligence throughout the organisation. The role will be responsible for the development and management of key performance indicators across a portfolio of services, providing data analysis and business intelligence support to the Business and Contracts Managers, Assistant Directors, Senior Managers, Clinical Managers and operational staff.
- The post holder will work with partner organisations and clinical services to ensure that information systems are efficient, robust and able to collect accurate information on the activity undertaken by the services. Analysis of this data will support both the ongoing work of CityCare, new innovations and opportunities to develop the business.
- An important part of the role will be to provide first level support to clinical services to enable them to monitor and resolve data quality issues and to support development of their understanding of performance information, enabling them to make decisions based on the analysis provided.
- The role will further support the Business Intelligence Developer in maintaining and developing the server, data warehouse and reporting tools for the organisation.
Dimensions
- To develop complex analysis and insight across adult and childrens services
- To be responsible for a portfolio of services alongside local and national data returns
- To be involved in the training and support for managers and services
- Supervision of junior staff, apprenticeships or agency staff as required
- Based at Aspect House with an expectation to visit services within other CityCare locations when required, to attend meetings and provide support on data and analysis
Key Responsibilities
Business & Commissioners
- To be responsible for the development and management of key performance indicators and meeting the information needs of operational teams; leading on providing accurate and timely reports across an agreed portfolio of services, evidencing performance and providing headline analysis and information to services, the CityCare Board and commissioners.
- As part of the Business Team, the post holder will support the creation and continuous development of the organisations contractual submissions, across both adult and childrens services. In this capacity the post holder will work autonomously within the remit of their portfolio, accessing advice and support from their line manager as needed.
- To develop and implement processes and solutions to assist senior managers and relevant project teams to meet planning, performance and service information requirements.
- To provide timely and accurate headline performance information to inform reviews, contract meetings and on an ad-hoc basis, including early identification of any performance issues.
- To provide accurate information to support new business opportunities, tenders and bids in the format required and to deadlines.
- To support clinical services in future decision making and operational changes by providing and developing analytical tools and solutions.
- To undertake analyses to support CityCares key functions, providing information that will inform key business decisions made by CityCare and their commissioners.
- To participate, interpret and develop reports and submissions to support the wider Integrated Care System.
Analysis and Strategic Reporting
- To develop complex analysis and insight across adult and childrens services by using a wide range of extraction and analytical techniques to interrogate and report from both corporate clinical systems and stand-alone data bases including SystmOne, data warehouse and other smaller stand-alone systems. It is therefore essential the post holder have experience in specialist application software and programming languages, including SQL Server Integration Services (SSIS) packages, SQL Server Reporting Services (SSRS), Power BI and advanced skills in SQL and Excel.
- The post holder will be expected to use specialist skills, knowledge and experience to support their portfolio of services in achieving contractual reporting requirements and internal metrics as appropriate, whilst working as part of a team to share such skill, knowledge and experience over the wider adult, childrens and corporate services. As well as this, the post holder would also be expected to support their portfolio of services in making operational decisions and improvement via the use of their analytical skills.
- To be responsible for the analytical development and management of key performance indicators across a portfolio of services, using a range of tools to provide data analysis and business intelligence, to support the development and management of the performance report, CCG submission and Board report.
- There would be an expectation that the post holder will be enthusiastic in attending training and building knowledge in using new reporting tools, working as part of the team to ensure technical skills are shared and advanced to support the organisation in moving business intelligence forward.
To develop reports and analysis that :
- Highlight variations in past performance and predict future performance, trends, anomalies and outliers
- To provide an expert resource in both the technical skills required to create reports and also the design of dashboards to communicate information and intelligence effectively.
- Inform of potential benefits to the business and develop understanding of new and existing markets
- Highlight any assumptions, levels of confidence and shortfalls of the approach taken.
- Incorporate financial information where required to enable an analysis of cost and activity
- Meet ad-hoc requests as necessary
- To support the collection, analysis and delivery of data and performance management information on third party contracts.
- To produce and validate information that contributes to statutory reporting to the Department of Health and fulfils CityCares corporate information reporting commitments
- To communicate highly complex concepts of specialist software to a wide audience of varying technical ability including difficult to understand concepts related to Business Intelligence including how it works and how to use it most effectively
Services
- To be responsible for the analytical development and management of key performance indicators and meeting the information needs of operational teams, against an agreed portfolio of services, through Reporting System in SQL Server Reporting Services (SSRS), Power BI and through the use of the organisations clinical system, SystmOne.
- The post holder will be expected to work with operational staff, Team Managers and Heads of Services to deal with all manner of queries, supporting requests from internal and external parties.
- To support third party sub-contracts in gathering and delivering in contractual information.
- To support services to improve their information knowledge, enabling them to make decisions based on the information the post holder provides, and to develop an ownership of their performance data, enabling them to use their information as a management tool to develop their service and identify new business opportunities.
- To develop a suite of data quality and validation reports to be used by the portfolio of services, and the continuous management and development of these, ensuring the service is fully engaged in the understanding of how such reports support the service, wider performance and business intelligence.
- To promote to services the importance of using high quality information to support business decisions and to help services identify and address data quality issues to support this.
- To provide support and guidance for SystmOne projects for new services and current service reviews, taking responsibility to ensure information requirements, both contractual and internal are met and reportable.
- To identify and facilitate any required changes to SystmOne and other clinical systems in use, on an ongoing basis to support performance monitoring, future strategic service development and potential new business.
- To proactively engage with services, enabling and supporting them to deliver high quality accurate performance information to deadlines.
To act as a first point of contact for services requiring first line support within agreed timescales:-
- In the use and interpretation of data
- One-off/short term problem solving and advice on data and information related problems.
- Adapting any first line solutions to the understanding and technical ability of the audience.
- If necessary escalate any serious issues requiring sustained input or training.
- To provide second line, detailed support and training to services who have been identified through the escalation procedure. This will be in a problem solving and enabling role.
- To support services with audit processes, research and development, and evaluation of clinical outcomes.
- To support services to develop ownership of their performance data and enable them to use their information as a management tool to develop their service and identify new business opportunities.
Please see the attached Job Description for full details of the job role.
Person Specification
Qualifications
Essential
- Educated to degree level or equivalent in a relevant subject
- Further specialist training or equivalent experience in use of analytical tools e.g. SQL/SSRS/Power BI
- Evidence of continuing professional/vocational development
Desirable
- A Prince 2 qualification or equivalent
Experience
Essential
- Experience of working in a data analysis and insight role
- Significant experience in using, MS SQL server, MS SSRS, Power Bi, MS Excel
- Previous experience of initiating, developing, planning and prioritising multiple complex information/data analysis plans and project specifications in order to deliver customer requirements.
- Previous experience of managing and developing staff
- Experience of analysing and interrogating complex databases and case management systems
Desirable
- Experience of working with Clinicians in a multi-disciplinary/multi-agency/partnership environment
- Experience of working in an NHS environment
- Experience of delivering projects
- Previous experience of using clinical systems/case management systems, such as SystmOne
- MS Access
Knowledge and skills
Essential
- Experience in using complex statistical and analytical tools and techniques to evaluate impact and monitor outcomes
- Ability to analyse and interpret complex data from multiple sources
- Highlight the impact of quality on analysis undertaken
- Ability to work with colleagues at all levels to present key information in a method appropriate to the audience
- Identifies issues, devises solutions and presents to a wide audience
- Able to assess a situation, set priorities and problem solve quickly and effectively
- Ability to communicate statistical and analytical information to non-technical professionals
- Understanding and awareness of information governance and client confidentiality
- Experience of developing effective relationships across a wide range of partners
- Effective persuasion and negotiation skills
Person Specification
Qualifications
Essential
- Educated to degree level or equivalent in a relevant subject
- Further specialist training or equivalent experience in use of analytical tools e.g. SQL/SSRS/Power BI
- Evidence of continuing professional/vocational development
Desirable
- A Prince 2 qualification or equivalent
Experience
Essential
- Experience of working in a data analysis and insight role
- Significant experience in using, MS SQL server, MS SSRS, Power Bi, MS Excel
- Previous experience of initiating, developing, planning and prioritising multiple complex information/data analysis plans and project specifications in order to deliver customer requirements.
- Previous experience of managing and developing staff
- Experience of analysing and interrogating complex databases and case management systems
Desirable
- Experience of working with Clinicians in a multi-disciplinary/multi-agency/partnership environment
- Experience of working in an NHS environment
- Experience of delivering projects
- Previous experience of using clinical systems/case management systems, such as SystmOne
- MS Access
Knowledge and skills
Essential
- Experience in using complex statistical and analytical tools and techniques to evaluate impact and monitor outcomes
- Ability to analyse and interpret complex data from multiple sources
- Highlight the impact of quality on analysis undertaken
- Ability to work with colleagues at all levels to present key information in a method appropriate to the audience
- Identifies issues, devises solutions and presents to a wide audience
- Able to assess a situation, set priorities and problem solve quickly and effectively
- Ability to communicate statistical and analytical information to non-technical professionals
- Understanding and awareness of information governance and client confidentiality
- Experience of developing effective relationships across a wide range of partners
- Effective persuasion and negotiation skills
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.
