Insight Analyst

MindVault Inc.; Trowbridge; On-site; GBP 30,000 - 40,000; Full time

Job summary

A public service provider is seeking an Insight Analyst to enhance Children's Services through data reporting and analysis. In this role, you will drive data integrity, create reports using SQL and Power BI, and engage with various stakeholders. This position offers valuable employee benefits including flexible working hours and generous leave options.

Benefits

26 days annual leave

Car share scheme

Occupational health

Flexible working options

Local government pension scheme

Qualifications

• HNC or NVQ Level 4 qualification in statistical analysis or information management, or relevant experience.
• Advanced skills in data integrity, matching, analysis, and strong stakeholder engagement.

Responsibilities

• Leading on capturing and retrieving essential data for local and statutory requirement.
• Designing and creating reports using SQL and Power BI.

Skills

Data integrity assessment

Stakeholder engagement

Advanced Excel

SQL

Power BI

Education

HNC or NVQ Level 4 in statistical analysis or information management

Tools

Microsoft SQL Server Reporting Services

Power BI

Job description

Overview

Hours per week: 37 hours

Interview date: Wednesday 1 October 2025 and Thursday 2 October 2025

Are you a data enthusiast ready to make an impact in Children's Services? Join our team and use your data skills to make a real impact in Children's Services.

Join our Performance and Information team as an Insight Analyst responsible for collating, reporting, and analysing management information within Education and Skills.

The role will lead a new mandatory national and local school attendance data requirements and the development and maintenance of the technical infrastructure required for the secure, efficient, and timely handling of vast volumes of attendance data from all schools. This will include the development, ownership, and delivery of attendance tracking reports and multi-cohort analytics to inform tactical operations, strategic decision-making, and performance scrutiny.

As an Insight Analyst, you will be expected to lead on internal and external stakeholder engagement, including managing expectations, delivery of insights, and data driven recommendations. The role will include a wide cross-section of internal council departments (Targeted Education, School Effectiveness, Social Care and Family Help) and external partners (Schools, Alternative Education Provisions, Health Service providers and more).

Your Key Responsibilities Will Include

• Leading on capturing and retrieving essential data for local and statutory requirement, ensuring accuracy and clarity.
• Scope, design, and create reports using software like Microsoft SQL Server Reporting Services and Power BI, enabling us to meet statutory obligations and local performance oversight needs.

To Excel In This Role, You Should Possess

• An HNC or NVQ Level 4 qualification in statistical analysis or information management, or relevant experience.
• Skills in assessing data integrity, matching, analysis, and strong skills in stakeholder engagement.
• Advanced Excel skills.
• Strong understanding and practical use of SQL and Power BI would be an advantage
• Knowledge of Childrens Services and the Public Sector would be beneficial but not mandatory.

Employee Benefits

• 26 days annual leave, rising to 31 after 5 years of continuous service, plus bank holidays.
• Car share scheme
• Occupational health
• Flexible working - Flexi-time, compressed/part-time hours, and job shares (where possible).
• Family-friendly policies
• Local government pension scheme