Senior Data Analyst

Job Reference: HCC624436
Salary Range: £40,643 - £45,077 per annum
Work Location: Elizabeth II Court, Winchester (Hybrid Working)
Hours per week: 37
Contract Type: Temporary for 24 months
Closing Date: 15 July 2026

Join our Adults and Children's Shared Services Performance Improvement Team as a highly skilled, motivated, and forward-thinking Senior Data Analyst, and play a pivotal role in delivering insight and intelligence across the Adults' Health and Care Directorate. This role offers an exceptional opportunity to apply your analytical expertise in a position where data directly informs decisions that improve outcomes for vulnerable residents. As part of a highly regarded Business Intelligence function, you'll transform complex datasets into meaningful insights, leveraging modern tools such as Azure and Power BI to influence services and support a period of significant transformation, including local government restructuring. You'll help drive the development of high-quality management and performance information that supports both strategic and operational decision making.

• Lead the design and delivery of high quality management information and performance reporting across Adults' Health and Care.
• Extract, manipulate, and analyse complex datasets using SQL Server.
• Design and build engaging and visually compelling Power BI dashboards and reports.
• Translate complex data into clear, actionable insights for a range of stakeholders.
• Capture business requirements and develop specifications for reporting solutions.
• Combine and analyse data from multiple sources to create unified datasets.
• Work with operational and project leads to support performance frameworks and service improvements, contributing to transformation programmes.

• Significant experience in an IT support environment, with strong expertise in relational databases and complex SQL queries (e.g., SQL Server).
• Previous experience of working within local government or Health with an understanding of the nature of public services delivery particularly in a social care or health setting.
• Proven expertise in Power BI, including Power Query and Power Automate.
• Advanced Excel skills and ability to analyse large, complex datasets.
• Solid understanding of data modelling, database design, and data structures.
• Ability to communicate technical insights to non technical audiences.
• Strong analytical thinking, with the ability to solve problems, innovate, and work independently under pressure.

• Make a real impact - your work will directly influence services that support vulnerable residents.
• Collaborate with experienced professionals across data, operations and strategic leadership teams.
• A supportive environment that encourages innovation, development and continuous improvement.
• Access to Health Assured's comprehensive Employee Assistance Programme to support your physical and mental well being, including 24/7 telephone support, a suite of online resources and legal and financial advice.
• A competitive benefits package that includes generous annual leave entitlement, occupational sick pay and access to the Local Government Pension Scheme. Find more information here.

We recruit for attitudes and values in Adults' Health and Care. We invite you to evidence how you demonstrate our 5 core values in your application. For more information on our values, please refer to the candidate pack.

This post is subject to a Criminal Records Check.

For an informal chat about the role, please contact Kevin Andrews, Head of Performance & Improvement on

Hampshire County Council is 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 this commitment.

In order to combat discrimination, no unnecessary conditions or requirements will be applied which could have a disproportionately adverse effect on any one group. All sections of the population will have equal access to jobs. No applicant or employee will receive less favourable treatment because of age, disability, gender reassignment, race, religion or belief, sex, sexual orientation, marriage or civil partnership and pregnancy or maternity, unless a Genuine Occupational Requirement (GOR) applies.

We are a Disability Confident Employer - committed to ensuring that our recruitment and selection process is inclusive and accessible.