Join RCOT as a Data Analyst Lead

Help transform reporting, insight and data quality across RCOT.

Drive Better Decisions Through Data and Insight

Location: London-based, hybrid working
Contract: Fixed Term Contract, 6 months, Full time
Salary: Circa £57,000 per annum(FTE), paid £28,500 pro rata for 6 months
Closing date: 5pm, Friday 27 November 2026

 

The Royal College of Occupational Therapists (RCOT) is the UK's professional membership body for occupational therapy. As we continue to strengthen our data and insight capabilities, we are seeking an experienced Data Analyst Lead to help improve how data is managed, reported and used across the organisation.

Working closely with the Head of Data, you will provide specialist expertise and additional capacity to deliver reporting and analytics initiatives, improve data quality and governance, and develop automated reporting solutions that support evidence-based decision-making.

You will:

  • Extract, combine and transform data from multiple systems, including CRM and operational platforms, ensuring datasets are accurate, complete and fit for reporting and analysis.
  • Analyse membership, operational and external data to identify trends, risks and opportunities, generating actionable insights that improve organisational performance.
  • Work with teams across the organisation to ensure data and insight inform decision-making and strategic priorities.
  • Support key business activities, including performance reporting, audits and annual cycles.
  • Provide accurate data and analysis for external reporting, research and data-sharing requirements.
  • Improve data collection, management and governance processes, ensuring high standards of data quality and GDPR compliance.
  • Clean, validate and maintain datasets, identifying and resolving data quality issues to improve confidence and consistency in reporting.
  • Produce management information, reports and dashboards using Power BI, Excel and other analytical tools.
  • Present complex analysis clearly and effectively to a range of audiences.
  • Develop dashboards and feedback mechanisms that capture and integrate member and stakeholder insight.
  • Support colleagues in building data confidence and champion evidence-based decision-making.

You bring:

  • Proven experience extracting, cleansing, validating and transforming data from multiple systems and sources for reporting and analysis.
  • Proven experience analysing complex datasets and turning data into actionable insights and recommendations.
  • Experience using CRM systems for reporting, segmentation, performance analysis and insight generation.
  • Strong expertise in Power BI or similar business intelligence tools, including dashboard design, data visualisation and storytelling.
  • Experience of data preparation, data modelling and creating reliable datasets for reporting and decision-making.
  • Experience building effective relationships with stakeholders at all levels, including senior leaders.
  • Experience delivering data or insight projects from inception to implementation.
  • Excellent communication skills, with the ability to explain complex information clearly.
  • Strong organisational skills and the ability to manage multiple priorities.
  • Excellent attention to detail and a commitment to high-quality outputs.
  • Strong understanding of GDPR, data protection and information governance.
  • Experience with SQL would be advantageous.

Why this role?

This is an opportunity for an experienced data professional looking to make a tangible impact. You will help accelerate improvements in reporting, dashboarding and data management, enabling RCOT to gain greater value from its data.

Working with stakeholders across the organisation, you will deliver practical improvements to reporting, insight and data quality, while identifying opportunities for greater automation and efficiency. Your work will strengthen reporting capabilities, support better decision-making and leave a lasting foundation for future data and insight development.

Work where people come first, with 25 days' holiday, Christmas closure, 9% pension, 4x life cover, hybrid working with just one office day a week and strong wellbeing support.

Location: London-based, hybrid working

Contract: Fixed Term Contract, 6 months, Full time

Salary: Circa £57,000 per annum(FTE), paid £28,500 pro rata for 6 months

If you’re interested in this role, please download the full  Data Analyst Lead role profile (PDF, 168KB).

 

Ready to apply? Follow the link below and remember to attach your CV and cover letter in the ‘Statement of Suitability’ section.

Data Analyst Lead Application form

Closing date: 5pm, Friday 27 November 2026

First Interviews: 15 and 17 December 2026

 

If you have any questions, get in touch with us at [email protected].

Full details of this vacancy can be found on our website: www.rcot.co.uk/current-vacancies