Data Analyst Lead
Royal College of Occupational Therapists
Hours
35 hours per week
Length of contract
6 months
About the Organisation
Royal College of Occupational Therapists (RCOT) is the UK’s professional membership body for occupational therapy. We lead, uphold and advance excellence within the profession through research, the development and delivery of evidence‑based standards and guidance, the provision of professional development, and the accreditation and enhancement of education.
We champion and advocate for the professional standing of occupational therapists and position the profession to have maximum impact in improving people’s health, wellbeing, participation through occupations, and quality of life now and for future generations.
In the Membership Engagement directorate, we work to create outstanding member and customer experiences that strengthen engagement, increase retention, and support membership growth. By optimising our communication channels and using data-driven insights, we listen, learn, and respond to the needs of our members, ensuring our services continue to deliver value and relevance.
About the role
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. As the Data Analyst Lead, you will play a key role in driving the collection, management, and use of our data. You’ll also provide regular reporting and analysis to enable the business to take an evidence-based approach to everything we do.
This is a Data Analyst Lead role, requiring expertise in extracting and analysing data from multiple systems. You will ‘hit the ground running’, bringing valuable data cleansing, validation and visualisation skills. You will develop impactful dashboards and reports, identify trends and opportunities, and continuously improve our reporting capabilities.
Responsibilities
Operational Delivery:
- Extract, combine and transform data from multiple systems, including CRM and operational platforms, ensuring datasets are accurate, complete and fit for reporting and analysis.
- Support the production of high-quality management information, operational reports and analytical outputs as part of an established performance cycle.
- Critically analyse membership data and organisational datasets to generate actionable insights that enhance member value and inform strategic decision-making.
- Collaborate across directorates to ensure insight and evidence inform membership, marketing, finance and wider organisational priorities.
- Respond to and support core teams ( Finance, Membership) with critical activities such as annual cycle performance and auditing.
- Provide external organisations with accurate data as and when required, for legal purposes, data sharing agreements and for market research/survey requirements.
- Shape and deliver data solutions across the organisation, ensuring good practice in the collection, storage, governance and GDPR compliance of membership and operational data.
- Improve data collection and management processes across the organisation, advising on systems and ways of working that reduce reliance on spreadsheets and improve data quality.
- Present complex analysis in clear, compelling formats tailored to different audiences, using Power BI, Excel and other appropriate methods.
- Develop mechanisms (dashboards, surveys, feedback loops) to capture, integrate and interpret intelligence from members and stakeholders.
- Mentor and support colleagues to build data confidence and champion a culture of evidence-based decision-making across teams.
- Conduct research and analysis to support organisational projects, initiatives and strategic priorities.
- Contribute to insight reports that improve understanding of member needs, behaviours and experiences, ensuring intelligence is disseminated effectively across the organisation.
- Requires resilience and adaptability to deliver outcomes through change and competing priorities. This includes remaining professional, staying calm under pressure, prioritising effectively, adapting plans quickly, learning from feedback, and escalating risks early.
Values & Culture:
- Live our values in all that you do; celebrate it when colleagues live our values and raise it, respectfully, when they don’t
- Engage in regular conversations with your manager about objectives, wellbeing and performance (data, impact and outcomes)
- Take personal ownership of your career development, seeking support and guidance as needed.
Skills, Competencies, Experience & Attributes
- 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 in 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.
Compensation & Benefits
- Holiday entitlement: 25 days annual leave
- Christmas closure: We’re closed over the Christmas period. Additional time will be given to all employees to cover any working days during this period
- Pension scheme: RCOT operates a contributory pension scheme; you are eligible to join this scheme from your date of commencement. Contributions are made on a salary exchange basis and are 6% of gross salary from the employee and 9% from the employer.
- Life cover: Four times annual salary.
- Free eyesight testing.
- Free Health and wellbeing app.
- Supportive networks and inclusive team - we have several colleague networks to support colleagues and provide a space for discussion and reflection, as well as promote allyship.
Working locations
- Hybrid model, working in the London office and remotely
How to apply
- Ready to apply? Please apply online and remember to attach your CV and cover letter in the ‘Statement of Suitability’ section.
- If you’re interested in this role, please download the full Data Analyst Lead role profile
- Data Analyst Lead Application form
- If you have any questions, get in touch with us at [email protected].
- The application closing date is 5 pm, Friday 27th November 2026
Interviews
- First Interviews are 15th and 17th December 2026
Policies
As a membership organisation, a professional body, and an employer, RCOT is committed to leading innovative change to promote equity and social justice and build a sense of belonging for all our staff, members, and the populations we serve. Our ambition is to have a diverse workforce that is representative of the communities we serve. We don’t only embrace diversity; we celebrate it, nurture it, and support our staff in realising their true potential.
We are passionate about creating an environment free from discrimination and harassment where people can be their authentic selves and recognise that each of us is unique. Therefore, our definition of diversity goes beyond those defined in equality legislation, and we will afford the same standards and principles to those with lived experience. We welcome applicants from all backgrounds and are keen to see applications from people with lived experience of disability or long-term health conditions, from minoritised ethnic and LGBTQI+ communities.
The job vacancy information provided here is from third-parties and the AAE can not guarantee the accuracy of the information.