Senior Data and Insight Specialist

As a Senior Data and Insight Specialist, you will play a key part in transforming raw data into meaningful insight that supports strategic workforce planning and organisational decision-making. Working closely with the Data & Insight Team Manager and Strategic People Partners, you will extract, manipulate, and interpret data from multiple systems-including SAP, IBC and other management information systems-to develop high-quality reporting and analytics.

A significant element of the role will involve designing and delivering intuitive front-end Power BI dashboards, ensuring information is clear, coherent, and tells a compelling story. You will work with large and complex datasets, apply advanced Excel skills, and ideally utilise DAX to optimise data models. Experience with SQL queries would be a strong advantage. Your analysis will help shape solutions, identify root causes, and support continuous improvement across the Council.

You are an analytical thinker with a passion for turning data into actionable insight. You have strong technical skills in data manipulation, modelling, and visualisation, with experience using Power BI to create accessible, user-focused dashboards. You are confident working with multiple data sources, comfortable using Excel to a high standard, and ideally familiar with DAX and/or SQL.

You can communicate complex information in a clear and engaging way, supporting colleagues at all levels to understand and use data effectively. You are curious, proactive, and solutions-focused-able to anticipate issues, recommend improvements, and influence positive change. You enjoy collaborative working, can manage competing priorities, and take pride and accountability in delivering high-quality work that supports evidence-based decisions.

Pulled from the full job description

• Annual leave
• Company pension, You will benefit from a competitive salary, generous annual leave, access to the Local Government Pension Scheme, and a range of employee benefits including flexible working options, professional learning opportunities, staff networks, and wellbeing resources.

You will be part of a team that invests in your growth and empowers you to make a meaningful impact across the organisation.

Your office base may be subject to change as we are currently transitioning between temporary and permanent office locations due to the closure of County Hall. If this is applicable to you, you will be notified, but no reimbursement will apply in respect of travel.

Our commitment to: Equality, Diversity and Inclusion At Oxfordshire County Council we are proud of our diverse workforce. Everyone is accepted for who they are, regardless of age, disability, gender identity, marital status, race, faith or belief, sexual orientation, socioeconomic background, or on maternity or family leave. We have a number of staff network groups which provide peer support, education and safe spaces for all.

Our commitment to: Guaranteed Interview Schemes As a Disability Confident employer, we guarantee an interview for disabled applicants who meet the essential criteria for the job. We also guarantee interviews to care leavers who have completed further education and who meet the essential criteria for the job. For those leaving care without any further education, we guarantee an interview for our apprenticeships. We are also committed to helping and supporting those transitioning from HM Armed Forces to civilian life and guarantee an interview for those demonstrating the essential criteria for the role, within three years of leaving the service.

Our commitment to: Safeguarding Oxfordshire County Council are committed to safeguarding and promoting the welfare of children, young people and adults. We expect all employees, workers and volunteers to share this commitment. We will ensure that all our recruitment and selection practices reflect these commitments.

Our commitment to: Flexible Working We are open to discussions about flexible working, which can include flexi-time, part time working, job sharing, nine-day fortnights and annualised hours, depending on the requirements of the role and the service.

Follow us on Social Media

Stay up-to-date with the latest news and featured jobs from Oxfordshire County Council by following us on LinkedIn, Facebook, Twitter and Instagram.

Oxfordshire County Council is committed to improving outcomes for our communities through innovation, data-driven decision-making, and a culture that values learning, kindness, integrity, responsibility, and doing things differently. Our HR Data & Insight Team plays a central role in helping services understand their workforce, identify trends, and make evidence-based decisions. We work collaboratively across the organisation, supporting colleagues with high-quality information, analytical insight, and user-friendly reporting tools that empower services to act with confidence.