Chelsea and Westminster Hospital NHS Foundation Trust

Data Analyst

Information:

This job is now closed

Job summary

Chelsea & Westminster Foundation Trustis looking for a data-driven individual to join their Estates and Facilities Directorate and support with the directorate vision of providing tailored Management, distinguished by safety and excellence. A proficient, responsive team, providing high quality services in an environmentally sustainable way.

The Directorate is responsible for the provision of a range of functions complementary to the provided health care services: Capital Development /Estates (Hard FM) / Facilities (Soft FM) , the team provides day-to-day management of contracted operational services, as well as planning the estate to reflect the strategic aims of the Trust.

As part of the Estates & Facilities Directorate, (E&F), the post holder will be required to analyse, reconcile and produce regular and financial information, conduct a range of reporting and analysis to meet internal and external information requirements, as well as responding to ad-hoc information requests. This will involve use of a range of software and internal computer systems. Computer systems that will be used include Windows; Microsoft Office products; Business Objects, financial and other clinical systems.

This is a great opportunity for an experienced data analyst who wants to take the next step in a sector of national significance.

Main duties of the job

To analyse general, contractual and financial data, assist in the receipt, input and validation of complex data sets and returns from Trusts, and other agencies to strict deadlines, identifying potential and actual data problems and proposing solutions, to support the submission of statutory returns.

Liaise with colleagues within the team, Finance and other relevant directorates to support the maintenance of Estates & Facilities operational information and reporting throughout the department. Support with the development and maintenance of data analysis, trends and dashboards which aid corporate information analysis and supports decision making and patient improvement within the Trust. And perform data audits as required.

  • And all duties as specified in job description.

About us

We provide services from two main hospitals, Chelsea and Westminster Hospital and West Middlesex University Hospital, and a number of clinics across London and the South-East.

We have over 6,000 members of staff that arePROUD to Carefor nearly one million people. Both hospitals provide full clinical services, including full maternity, emergency and children's, in addition to a range of community-based services across London, such as award-winning sexual health and HIV clinics.

We're one of the safest and best performing Trusts in the country. We're also one of the top trusts to work for - our staff say they're engaged, motivated, and would recommend us as a place to work and receive treatment.

In 2020 the Trust was rated by the Care Quality Commission as Outstanding in the well-led and use of resources domains and Good in the safe, effective, caring, and responsive domains. The Trust as a whole was Good, but the Chelsea site was Outstanding.

Our facilities are some of the best in the country. We have been investing around £10 million a year in our estate. We are currently spending £25 million on expanding our adult and neonatal critical care facilities at Chelsea and Westminster and redevelopment of our children's unit at West Middlesex - in partnership with our charity, CW+ and generous donors.

Details

Date posted

23 October 2023

Pay scheme

Agenda for change

Band

Band 5

Salary

£34,089 to £41,498 a year pa

Contract

Permanent

Working pattern

Full-time

Reference number

289-CR-1434

Job locations

Chelsea & Westminster Hospital

Block A Doughty House, 369 Fulham Road

London

SW10 9NH


Job description

Job responsibilities

  • Be responsible to the reconciliation, analysis and validation of internal, external general and financial streams and other corporate monitoring in line with agreed timescales and formats. In addition, produce routine internal reporting to assist in daily and weekly performance management of the Division, ensure any risks to workload are escalated.
  • Develop analysis and interpretation of reporting, looking at variances and trends to enable the department to understand and use information effectively.
  • Produce trend analysis and ad-hoc information requests as required,
  • Investigate general and financial data inconsistencies and identifying potential causes ensure any risks are escalated.
  • Assist with the development and automation of new processes and the enhancement of existing information collection and reporting procedures in order to meet the changing needs of internal and external information users.
  • Under the guidance of the Contract Manager, organise and implement programmes of work to improve data collection and reporting.
  • Provide support and advice on the availability, quality and best use of information available within the department.
  • In conjunction with the department leads, investigate and assist with the resolution of data quality issues raised. This will include monitoring progress against agreed action plans, and national targets.
  • Participate in the formal statistical analysis and interpretation of results of data analysis, e.g. reports, charts, maps, pivot tables.
  • Design and develop spreadsheets/databases to hold sometimes complex data collected for a particular purpose and maintain the integrity of the data.
  • Undertake the analysis of computerised and manual data as part of the provision of management information for both routine and ad-hoc requests.
  • Provide regular reports on progress against agreed data correction trajectories, undertake the presentation and explanation of data analysis and ensure any risks are escalated.
  • Identify and propose changes to business processes or reporting systems to improve service, bring efficiencies and/or meet new policy or guidance requirements. This includes ensuring data quality is of the highest standard working.
  • Engage with trust teams to assist the correction of poor data quality practices
  • Attend relevant meetings and steering groups relating to data quality.
  • Perform data audits as required.
  • To be a point of contact and to offer support to the trust in utilising data quality reports and how to correct any errors identified.
  • To liaise with relevant contracted out service teams and monitoring teams to ensure the quality of data collected.
  • To analyse a variety of data quality metrics, consider opportunities for improvement and produce written reports as required.
  • Establish and maintain effective working relationships with stakeholders to support the work programme of the operational divisions and data quality steering group.
  • Keep track of improvements, risks and issues associated within data analysis.
  • Contribute to the development of a culture of continuous improvement, challenging orthodoxy and the established way of doing things, promoting evidence based approach where positive change is more welcomed than resisted.
  • Ensure any data entry errors are escalated and reasonable steps are taken to address through documented training and correction of the relevant systems.
  • Complete all mandatory training within deadline.
  • Support with third party data analysis and request e.g. ERIC Return
  • Contribute and support with the department Sustainability plan
  • Contribute to the Cost Improvement Plan CIP

This job description may be subject to change according to the varying needs of the service, such changes will be made after discussion between the post holder and his/her manager.

There may be a requirement for flexible working, including weekends where appropriate and to undertake any other delegated duties as appropriate and commensurate with the grade. All duties must be carried out within Trust policy and procedure.

Job description

Job responsibilities

  • Be responsible to the reconciliation, analysis and validation of internal, external general and financial streams and other corporate monitoring in line with agreed timescales and formats. In addition, produce routine internal reporting to assist in daily and weekly performance management of the Division, ensure any risks to workload are escalated.
  • Develop analysis and interpretation of reporting, looking at variances and trends to enable the department to understand and use information effectively.
  • Produce trend analysis and ad-hoc information requests as required,
  • Investigate general and financial data inconsistencies and identifying potential causes ensure any risks are escalated.
  • Assist with the development and automation of new processes and the enhancement of existing information collection and reporting procedures in order to meet the changing needs of internal and external information users.
  • Under the guidance of the Contract Manager, organise and implement programmes of work to improve data collection and reporting.
  • Provide support and advice on the availability, quality and best use of information available within the department.
  • In conjunction with the department leads, investigate and assist with the resolution of data quality issues raised. This will include monitoring progress against agreed action plans, and national targets.
  • Participate in the formal statistical analysis and interpretation of results of data analysis, e.g. reports, charts, maps, pivot tables.
  • Design and develop spreadsheets/databases to hold sometimes complex data collected for a particular purpose and maintain the integrity of the data.
  • Undertake the analysis of computerised and manual data as part of the provision of management information for both routine and ad-hoc requests.
  • Provide regular reports on progress against agreed data correction trajectories, undertake the presentation and explanation of data analysis and ensure any risks are escalated.
  • Identify and propose changes to business processes or reporting systems to improve service, bring efficiencies and/or meet new policy or guidance requirements. This includes ensuring data quality is of the highest standard working.
  • Engage with trust teams to assist the correction of poor data quality practices
  • Attend relevant meetings and steering groups relating to data quality.
  • Perform data audits as required.
  • To be a point of contact and to offer support to the trust in utilising data quality reports and how to correct any errors identified.
  • To liaise with relevant contracted out service teams and monitoring teams to ensure the quality of data collected.
  • To analyse a variety of data quality metrics, consider opportunities for improvement and produce written reports as required.
  • Establish and maintain effective working relationships with stakeholders to support the work programme of the operational divisions and data quality steering group.
  • Keep track of improvements, risks and issues associated within data analysis.
  • Contribute to the development of a culture of continuous improvement, challenging orthodoxy and the established way of doing things, promoting evidence based approach where positive change is more welcomed than resisted.
  • Ensure any data entry errors are escalated and reasonable steps are taken to address through documented training and correction of the relevant systems.
  • Complete all mandatory training within deadline.
  • Support with third party data analysis and request e.g. ERIC Return
  • Contribute and support with the department Sustainability plan
  • Contribute to the Cost Improvement Plan CIP

This job description may be subject to change according to the varying needs of the service, such changes will be made after discussion between the post holder and his/her manager.

There may be a requirement for flexible working, including weekends where appropriate and to undertake any other delegated duties as appropriate and commensurate with the grade. All duties must be carried out within Trust policy and procedure.

Person Specification

Qualifications

Essential

  • Degree or equivalent level of experience
  • High level of proficiency in computer and information systems

Experience

Essential

  • Being able to identify and articulate data quality gaps, risks and opportunities relevant to change programmes
  • Experience of complex data analysis, information and contract monitoring information

Skills and knowledge

Essential

  • Excellent communication skills, both written and verbal
  • Experience with Microsoft Office products including the ability to create and manipulate complex spreadsheets to analyse and present large amounts of complex data using including, Excel, Access, Outlook, Word and Powerpoint.

Personal qualities

Essential

  • Openness, honesty and inclusiveness
  • Analytical thinking
Person Specification

Qualifications

Essential

  • Degree or equivalent level of experience
  • High level of proficiency in computer and information systems

Experience

Essential

  • Being able to identify and articulate data quality gaps, risks and opportunities relevant to change programmes
  • Experience of complex data analysis, information and contract monitoring information

Skills and knowledge

Essential

  • Excellent communication skills, both written and verbal
  • Experience with Microsoft Office products including the ability to create and manipulate complex spreadsheets to analyse and present large amounts of complex data using including, Excel, Access, Outlook, Word and Powerpoint.

Personal qualities

Essential

  • Openness, honesty and inclusiveness
  • Analytical thinking

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.

Employer details

Employer name

Chelsea and Westminster Hospital NHS Foundation Trust

Address

Chelsea & Westminster Hospital

Block A Doughty House, 369 Fulham Road

London

SW10 9NH


Employer's website

https://www.chelwest.nhs.uk/ (Opens in a new tab)

Employer details

Employer name

Chelsea and Westminster Hospital NHS Foundation Trust

Address

Chelsea & Westminster Hospital

Block A Doughty House, 369 Fulham Road

London

SW10 9NH


Employer's website

https://www.chelwest.nhs.uk/ (Opens in a new tab)

Employer contact details

For questions about the job, contact:

Contract Manager

Sonia Silva

sonia.silva4@nhs.net

02033152145

Details

Date posted

23 October 2023

Pay scheme

Agenda for change

Band

Band 5

Salary

£34,089 to £41,498 a year pa

Contract

Permanent

Working pattern

Full-time

Reference number

289-CR-1434

Job locations

Chelsea & Westminster Hospital

Block A Doughty House, 369 Fulham Road

London

SW10 9NH


Supporting documents

Privacy notice

Chelsea and Westminster Hospital NHS Foundation Trust's privacy notice (opens in a new tab)