Technical Data Analyst

HAMPSHIRE COUNTY COUNCIL; Winchester; On-site; GBP 80,000 - 100,000; Full time

Job summary

A local government organization in Winchester is hiring a Technical Data Analyst to join their Data and Systems Team. The role involves developing SQL-based reports, collaborating with stakeholders, and ensuring data integrity for informed decision-making. Ideal candidates will have advanced technical certifications, proficiency in SQL and reporting tools like Power BI and SSRS, and strong analytical skills. This position offers a competitive benefits package, professional development opportunities, and the chance to make a significant impact in Children’s Services.

Benefits

Employee Assistance Programme

Generous annual leave

Occupational sick pay

Local Government Pension Scheme

Qualifications

• Proficient in writing complex SQL queries and working with relational databases.
• Experience using reporting tools like Power BI and SSRS.
• Strong analytical skills to support data-driven decision-making.

Responsibilities

• Develop and maintain SQL queries and stored procedures.
• Build and optimise reports and dashboards.
• Collaborate with stakeholders to gather and translate requirements.

Skills

Complex SQL queries

Data analysis

Attention to detail

Stakeholder collaboration

Problem-solving

Education

Advanced technical certificate or diploma

Tools

SQL Server

Power BI

SSRS

Job description

Joining our Data and Systems Team within Children’s Services Shared Service as a skilled Technical Data Analyst, you’ll be passionate about transforming data into actionable insights. In this key role, you’ll design, develop, and maintain SQL-based reports and dashboards that drive data-informed decision-making across the organisation.

Reporting to the Data Architect, you’ll be a main point of contact for reporting development, supporting analytics, reporting, and learning across the team. You’ll work on a variety of projects, proactively identifying efficiencies, streamlining processes, and delivering technical solutions to multiple customers.

What you’ll do:

• Develop and maintain SQL queries, stored procedures, and views to support reporting requirements.
• Build and optimise reports and dashboards using SQL and reporting tools such as Power BI and SSRS.
• Collaborate with stakeholders to gather requirements and translate them into technical specifications.
• Ensure data accuracy, consistency, and integrity across all reports.
• Monitor and troubleshoot report performance and data issues.
• Document report logic, data sources, and processes for transparency and future maintenance.
• Support ad-hoc data requests and analysis, data quality initiatives, and contribute to the continuous improvement of reporting processes.

What we’re looking for:

• Advanced technical certificate or diploma, or A levels, or equivalent.
• Proficient in writing complex SQL queries and working with relational databases (e.g., SQL Server).
• Experience with reporting tools such as SSRS and Power BI.
• Strong analytical and problem-solving skills.
• Ability to interpret business requirements and translate them into technical solutions.
• Attention to detail and commitment to data accuracy.

Why join us:

• Be part of a collaborative team driving innovation in Children’s Services.
• Work on projects that make a real difference to service delivery.
• Opportunities for professional development and to contribute to service improvement.
• Access to Health Assured's comprehensive Employee Assistance Programme to support your physical and mental wellbeing, 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.

To learn more about this role, please review our Candidate Pack available on our website. Please click on the Apply button for details.

Applicants can expect to hear from us within two weeks of the advertised closing date.

Please note:We are unable to offer sponsorship for this role and therefore it is essential that you already have the right to work in the UK before applying.

Other roles you may have experience of may include: Data Reporting Specialist, Data Solutions Analyst, Data Insights Analyst, Data Reporting Developer, Information Systems Analyst, Data Analytics Specialist, Reporting and Insights Analyst, Analytics & Reporting Consultant