Job summary
The post holder will work as part of the Business Intelligence (BI) Department, reporting to a Lead BI Developer within the Report Development team, to deliver a dedicated data, reporting and analytics service primarily to Lewisham community services.
This will involve working with other members of the Performance & Business Intelligence team, in addition to other key stakeholders including Data Warehouse and IT (RiO), community service leads, population health team and the local authority, to support the aims and ambitions in the delivery of high quality, safe and timely community services.
The post holder will support the data analysis needs of all community services commissioned from LGT. This will include investigating the need for data analysis and reporting where there is some complexity and ambiguity. It will involve the selection, acquisition and integration of data for analysis, identifying opportunities to digitise and streamline operational data handling and optimise data analysis capabilities.
The post holder will support work on understanding inequalities within the served population and will be expected to deliver high quality analytical and reporting outputs, using relevant technical skills in data management, business intelligence and analytics, and data science. This will also include identifying deficiencies in the data and working with services and other colleagues to drive improvement in all aspects of data quality as appropriate to the role.
Main duties of the job
As a dynamic and enthusiastic analyst you will be capable of demonstrating a methodical and structured approach to analysing, interpreting and advising on complex data or information, together with the ability to communicate with stakeholders at all levels both within, and external to, the organisation.
The post holder will be expected to develop an extensive understanding of community data and reporting requirements, both internally and those required through nationally driven strategies and statutory requirements such as the Community Health Services Data Plan, Community Services Data Set (CSDS) and Faster Data Flows (FDF).
The post holder will require strong communication skills and the ability to write complex SQL data queries. The post holder will also contribute to the testing of changes to data flows, system upgrades etc. as appropriate.
About us
Our people are our greatest asset. When we feel supported and happy at work, this positivity reaches those very people we are here for, the patients. Engaged employees perform at their best and our Equality, Diversity & Inclusion (EDI) initiatives contribute to cultivate a culture of engagement. We have four staff networks, a corporate EDI Team and a suite of programmes and events which aim to insert the 5 aspirations:
- Improving representation at senior levels of staff with disabilities, from black, Asian, and ethnic minorities background, identify as LGBTQ+ and women, through improved recruitment and leadership development
- Widening access (anchor institution) and employability
- Improving the experience of staff with disability
- Improving the EDI literacy and confidence of trust staff through training and development
- Making equalities mainstream
Job description
Job responsibilities
To support the provision and distribution of relevant statutory submission, intelligence reports, monitoring trends, patterns and providing forecasts.
To lead and provide advice on the collection, collation and dissemination of activity & performance reports and analytics and to provide interpretation of these to all key stakeholders, both within and external to the Trust.
To highlight and provide expertise on data deficiencies (data quality), assisting in devising strategies to drive improvement where necessary and to report on progress against agreed actions.
To support improvement in the capture, accuracy and accessibility of community services data, with an associated focus on inequalities to include:1. The routine disaggregation of data by protected characteristics, identifying where there are particular data coding or completeness issues for services to resolve;2. Allowing services to more easily engage with inequalities issues for the benefit of people across the borough of Lewisham;3. Identifying and supporting the resolution of data reporting issues relating to protected characteristics.
To determine what information is required and define search and other criteria to meet the specified requirement.
To develop and apply processes to support the analysis needs of the supported services, define standard and non-standard techniques and tools to deliver data analysis such as OLAP reporting, data mining, predictive analysis and data storytelling.
To plan, design and conduct tests of data visualisations to assure it meets the needs of end users, that data is succinct and that information maps to underlying raw data through known and appropriate translation and visual representation techniques. To correct errors and retest to achieve an error-free result.
To undertake testing of changes to data flows and support the implementation of or upgrades to relevant systems.
To take responsibility for the prioritisation of requests and to deliver tasks and projects to agreed specifications and deadlines.
- To use external packages, such as Model Hospital, to analyse trends and monitor comparative performance against peers as appropriate.
Job description
Job responsibilities
To support the provision and distribution of relevant statutory submission, intelligence reports, monitoring trends, patterns and providing forecasts.
To lead and provide advice on the collection, collation and dissemination of activity & performance reports and analytics and to provide interpretation of these to all key stakeholders, both within and external to the Trust.
To highlight and provide expertise on data deficiencies (data quality), assisting in devising strategies to drive improvement where necessary and to report on progress against agreed actions.
To support improvement in the capture, accuracy and accessibility of community services data, with an associated focus on inequalities to include:1. The routine disaggregation of data by protected characteristics, identifying where there are particular data coding or completeness issues for services to resolve;2. Allowing services to more easily engage with inequalities issues for the benefit of people across the borough of Lewisham;3. Identifying and supporting the resolution of data reporting issues relating to protected characteristics.
To determine what information is required and define search and other criteria to meet the specified requirement.
To develop and apply processes to support the analysis needs of the supported services, define standard and non-standard techniques and tools to deliver data analysis such as OLAP reporting, data mining, predictive analysis and data storytelling.
To plan, design and conduct tests of data visualisations to assure it meets the needs of end users, that data is succinct and that information maps to underlying raw data through known and appropriate translation and visual representation techniques. To correct errors and retest to achieve an error-free result.
To undertake testing of changes to data flows and support the implementation of or upgrades to relevant systems.
To take responsibility for the prioritisation of requests and to deliver tasks and projects to agreed specifications and deadlines.
- To use external packages, such as Model Hospital, to analyse trends and monitor comparative performance against peers as appropriate.
Person Specification
Qualifications and Training
Essential
- Educated to post graduate degree level or equivalent and relevant experience
- Evidence of continuing professional development.
Desirable
- IT / Information related qualification
- Statistics qualification
- PowerBI certification or equivalent
- Active member of an appropriate professional body e.g. AphA / FEDIP
- Hold or working towards professional registration
Experience
Essential
- Worked within a data related role, and has a technical background
Desirable
- Knowledge of NHS data
- Worked with community data and understanding of national community data sets
- Experience working for an NHS provider organisation
Knowledge
Essential
- Good interpersonal skills, able to build and develop working relationships both internally and externally
- Able to translate and communicate complex issues verbally
- Ability to integrate databases using Structured Query Language (SQL)
- Excellent numerical and analytical skills
- Excellent organisation skills
- Advanced knowledge of Microsoft applications, specifically Excel, Word and Access
Desirable
- Able to work with large incomplete datasets
- Knowledge and experience of Power BI, SSRS
Person Specification
Qualifications and Training
Essential
- Educated to post graduate degree level or equivalent and relevant experience
- Evidence of continuing professional development.
Desirable
- IT / Information related qualification
- Statistics qualification
- PowerBI certification or equivalent
- Active member of an appropriate professional body e.g. AphA / FEDIP
- Hold or working towards professional registration
Experience
Essential
- Worked within a data related role, and has a technical background
Desirable
- Knowledge of NHS data
- Worked with community data and understanding of national community data sets
- Experience working for an NHS provider organisation
Knowledge
Essential
- Good interpersonal skills, able to build and develop working relationships both internally and externally
- Able to translate and communicate complex issues verbally
- Ability to integrate databases using Structured Query Language (SQL)
- Excellent numerical and analytical skills
- Excellent organisation skills
- Advanced knowledge of Microsoft applications, specifically Excel, Word and Access
Desirable
- Able to work with large incomplete datasets
- Knowledge and experience of Power BI, SSRS
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.
