Student Data Analyst

The Student Data & Business Intelligence Analyst will develop and maintain the organisation’s data reporting infrastructure, ensuring high-quality outputs for statutory returns and management information. The postholder will utilise advanced technical skills in SQL, SSRS, Power BI or equivalent tools to deliver reliable, scalable reporting solutions and interactive dashboards. The role also supports system administration, data governance, and initiatives that improve the student experience.

Key Responsibilities

The postholder will be responsible for:

• Designing, developing, and optimising SQL queries, stored procedures, and views for efficient data extraction and reporting.
• Building and maintaining interactive dashboards using Power BI or equivalent tools.
• Developing and maintaining SSRS reports for operational and statutory purposes.
• Creating and managing data models to support enterprise-level analytics.
• Administering and configuring the Student Records System (e.g., workflows, codesets, permissions).
• Collaborating with IT and suppliers to test upgrades, patches, and new features.
• Ensuring system security and compliance with institutional policies.
• Implementing validation rules and automated checks to maintain data accuracy.
• Developing and maintaining data dictionaries, metadata standards, and quality dashboards.
• Contributing to organisation-wide data governance initiatives and ensuring compliance with GDPR and data policies.
• Compiling, validating, and submitting statutory returns (e.g., HESA, NSS, Graduate Outcomes, OfS datasets).
• Reconciling outputs from the student records system and responding to validation feedback.
• Working with stakeholders to ensure accuracy of statutory returns.
• Leading or supporting projects to enhance the Student Records System and related integrations.
• Assisting with ETL pipeline development to integrate data from multiple sources (e.g., CRM, VLE).
• Supporting data integration and automation projects across departments.
• Engaging stakeholders to identify reporting needs and deliver actionable data solutions.
• Contributing to initiatives that enhance the student experience, improving satisfaction and outcomes.
• Completing all statutory and mandatory training requirements.
• Taking responsibility for maintaining a safe, healthy, and compliant working environment.

Person Specification

Essential Skills & Experience

• Strong proficiency in SQL and relational databases.
• Experience with data visualisation tools (Power BI, SSRS, or equivalent).
• Demonstrated ability to manage and configure complex data systems (e.g., student records).
• Strong understanding of data quality assurance and governance frameworks.
• Knowledge of statutory reporting requirements in higher education (HESA, OfS, etc.).
• Ability to develop and support ETL processes and system integrations.
• Excellent problem-solving and analytical skills with attention to detail.
• Strong communication skills, able to translate technical outputs for non-technical stakeholders.
• Commitment to continuous professional development in data management and analytics.
• Awareness of GDPR, data protection, and compliance requirements.

Additional Information

The postholder may be required to undertake other duties as reasonably requested, in line with the nature and responsibilities of the role.