Insight Analyst

Wiltshire Council; Trowbridge; On-site; GBP 30,000 - 40,000; Full time

Job summary

A local council is looking for an Insight Analyst to make a significant impact in Children's Services. Responsibilities include collating and analyzing attendance data, engaging with stakeholders, and designing reports using SQL and Power BI. Candidates should possess an HNC or NVQ Level 4 in statistical analysis or relevant experience, and strong Excel skills are essential. The role offers comprehensive benefits and opportunities for flexible working.

Benefits

26 days annual leave

Car share scheme

Occupational health

Flexible working options

Family-friendly policies

Local government pension scheme

Qualifications

• Relevant experience in information management.
• Strong skills in stakeholder engagement.
• Knowledge of Children’s Services and the Public Sector is beneficial.

Responsibilities

• Collate, report, and analyze management information.
• Lead on capturing and retrieving essential data.
• Design and create reports to meet statutory obligations.

Skills

Statistical analysis

Data integrity assessment

Stakeholder engagement

Advanced Excel skills

Education

HNC or NVQ Level 4 qualification in statistical analysis or information management

Tools

Microsoft SQL Server Reporting Services

Power BI

Job description

Hours per week: 37 hours

Interview date: Wednesday 1 October 2025 & 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).

Key Responsibilities:

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

Requirements:

• 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 Children’s 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