Join RCOT as a Data Analyst Lead

• 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., 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: Contract

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

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

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.