Senior Returns, Planning and Insight Officer

NHS; London; Hybrid; GBP 44,000 - 45,000

Job description

Senior Returns, Planning and Insight Officer

Tavistock and Portman NHS Foundation Trust

Please note this role does not allow for Visa sponsorship.

At the Tavistock and Portman NHS Foundation Trust, we are proud to be one of the largest providers of mental health education globally and the only NHS Trust registered with the Office for Students. We offer over 100 education and training courses to more than 4,000 students, including postgraduate master's and doctoral-level programs, which are currently validated by university partners. Our unique clinician-tutor model and multidisciplinary approach allow us to train a wide range of professionals, including clinicians, social workers, nurses, and teachers.

Our Directorate of Education and Training has ambitious goals for increasing student numbers, diversifying its portfolio and extending its reach. To achieve these goals, it is essential that we provide effective professional support services for our students and staff.

A vacancy has now arisen for a Senior Returns, Planning and Insight Officer, to lead the work of the Division in delivering insight in our education and training activities, and to lead for the Division and Trust in preparing statutory student returns via our validating partner institution.

Main duties of the job

1. Assist with the delivery of regulatory reporting to our University Partners/ Office for Students (OfS), such as HESA and HESES, undertaking data cleansing, data queries and data production.
2. Assist with the requirements, management and build of a suite of validation and exception reports, using SQL and Power BI, ensuring that data quality is optimal at key points during the academic year.
3. Maintain a thorough knowledge of forthcoming changes in statutory reporting, attending and participating in sector events as required. The post holder will assist how best to implement statutory reporting requirements as they change.
4. Working with the Head of Academic Registry, Statutory Returns, Planning and Insights Manager and the Finance Manager, communicate change requirements by developing and facilitating training and workshops.
5. A primary user of student data systems at the Trust to assist with the development and delivery of BI dashboards for management teams within the Division and across the Trust that will drive forward strategic change, in line with KPI targets and other objectives.

About us

You will join a dedicated and dynamic team based in Belsize Park (Hampstead) in north-west London. Our hybrid working model allows for flexibility, with 2-3 days per week in the office. We are committed to supporting students from diverse backgrounds and work together to manage all aspects of the student journey, from enrolment to graduation. Our team operates on a portfolio basis, sharing expertise and fostering a collaborative, supportive environment.

This role is ideal for someone with previous experience in Higher Education, particularly in the preparation and delivery of Statutory Returns. Strong organisational and communication skills are essential, along with the ability to manage multiple priorities and work effectively within a team. If you are a motivated and experienced professional looking to contribute to a leading mental health education provider, we encourage you to apply for this exciting opportunity.

For a confidential and informal conversation about this role, please contact Stephen Rowlstone at [e-mail].

Job responsibilities

Please see the attached Job Description and Person Specification for more information on the role requirements and duties.

Person Specification

Qualifications

• Degree or equivalent experience, ideally in a numerate subject
• Evidence of further professional development, in an area relevant to the role

Experience

• Knowledge and experience of using effective dashboard design for business intelligence practice in conjunction with a data warehouse
• Experience of databases, preferably including SITS
• Experience of student records and databases, preferably including SITS
• Experience of working in a relevant role at a UK Higher Education institution

Skills

• Advanced analysis skills on Microsoft Excel
• Advanced SQL skills
• Power BI design and development
• Project Management

Knowledge

• Knowledge of using analytics platforms such as Power BI, Tableau, SQL, etc.
• Knowledge of producing Statutory Returns
• Knowledge of developing Power BI Reports

Personal Attributes (demonstrable)

• Able to demonstrate a commitment to and a desire to live by the Trust's values
• Excellent oral and written communication skills
• A demonstrable ability to communicate complex data to a varied audience, drawing out key learning and action points
• Ability to work flexibly and participate in key tasks from elsewhere within the Directorate on occasion as required

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.

Tavistock and Portman NHS Foundation Trust

Depending on experience, £44,806 per annum, inclusive of HCAS