Senior Data & Reporting Analyst - Community

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

Lewisham and Greenwich NHS Trust, (LGT), is a community-focused provider of local and acute care, delivering high-quality services to over one million people living across the London boroughs of Lewisham, Greenwich, and Bexley. We provide whole-life care and are here to support our communities to live healthier lives as well as taking care of them when they need us the most.

Employing almost 7,500 colleagues, affectionately known as Team LGT, we provide services at Queen Elizabeth Hospital in Woolwich, University Hospital Lewisham, and at over a dozen community settings in Lewisham. We also provide some services at Queen Mary's Hospital in Sidcup.

We have recently launched our new vision and values to mark the LGT10 - the tenth anniversary of our Trust forming in 2013. Our trust vision is to be exceptional. In the quality of our patient care; our support for colleagues; and in the difference we make through our partnerships and in our communities.

To achieve this we value Respect, Compassion, and Inclusion; Being accountable over staying comfortable; Listening over always knowing best; and Succeeding together over achieving alone. You can read more about our visions and values here

Our hospitals and community sites provide a wide range of inpatient and outpatient services, as well as emergency and planned care. The Trust is rated as "good" or "outstanding" in over three-quarters of the services inspected by the Care Quality Commission.

Every year our work includes performing 10,000 procedures in our theatres; bringing seven and a half thousand new lives into the world; carrying out 570,000 visits to patients in their homes or communities and providing emergency care for more than 300,000 patients arriving in our busy Urgent and Emergency Departments.

LGT is a centre for the education and training of medical students enrolled with King's College London's GKT School of Medical Education. We are a training centre for nurses, midwives and allied health professionals. We are pioneering new roles that will support the changing needs of our patients and are one of the largest employers of physician associates in the country.

We are committed to working with our partners to deliver the best outcomes for our local communities. This means playing an active role in the South East London Integrated Care System (ICS), and in formal partnerships including the South East London Acute Provider Collaborative, provider partnerships with our local mental health trusts and borough-based boards of the ICS in Bexley, Greenwich and Lewisham.

Job overview

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.

Working for our organisation

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:

1. 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
2. Widening access (anchor institution) and employability
3. Improving the experience of staff with disability
4. Improving the EDI literacy and confidence of trust staff through training and development
5. Making equalities mainstream

Detailed job description and main 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 criteria

• Educated to post graduate degree level or equivalent and relevant experience
• Evidence of continuing professional development.

Desirable criteria

• 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 criteria

• Worked within a data related role, and has a technical background

Desirable criteria

• Knowledge of NHS data
• Worked with community data and understanding of national community data sets
• Experience working for an NHS provider organisation

Knowledge

Essential criteria

• 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 criteria

• Able to work with large incomplete datasets
• Knowledge and experience of Power BI, SSRS

We reserve the right to close the post before the stated closing date, please apply early. We do not contact applicants with the outcome of the shortlisting. If you have been shortlisted, you will receive an invite to an assessment day or interview.

As a local employer and anchor institution we work closely with our community to recruit locally and we welcome applications from the widest variety of people to ensure our workforce are reflective of the local communities which we serve. We encourage all suitable candidates to apply including if you are Black, Asian or other ethnic minorities, live with a disability (visible or not) or are LGBT+. We have a number of active staff networks including Disability, LGBT+, Multicultural Inclusion and Women's staff networks to bring staff together and celebrate diversity across our whole workforce.

Please note, not all roles will meet the criteria for a skilled worker visa.

Employer certification / accreditation badges

Documents to download

• JD (PDF, 368.6KB)
• Working at LGT (PDF, 4.2MB)
• Visa and Certificate of Sponsorship Information for Applicants (PDF, 3.8MB)