Data & Intelligence Analyst

Job Title: Data & Intelligence Analyst
Starting Salary: £42,839 progressing to £47,181 per annum (pro rata for part time)
Hours: 37
Location: Countywide
Contract Type: Fixed Term - 2 years
Directorate: Community Protection

About the team

We are seeking a skilled and motivated Data and Intelligence Analyst to join our Community Protection Data Team. You will contribute to high-quality data solutions that support strategic decision-making across Hertfordshire Fire and Rescue Service (HFRS), working with a high degree of autonomy and confidence.

You’ll be part of a dynamic and collaborative team that plays a critical role in supporting the Community Protection Directorate. The team provides performance reporting, data analysis, and strategic insights that inform planning and operational decisions. You’ll work closely with internal stakeholders and external partners, contributing to a culture of continuous improvement and innovation.

About the role

The following key responsibilities outline the scope and expectations of the role:

- Design, develop, and refine SQL queries, ETL processes, and data warehouse solutions to support business intelligence needs

- Lead the implementation of source/version control systems and ensure proper documentation across all BI processes

- Develop and support Power BI dashboards and reports, collaborating with the GIS Analyst on spatial data analysis

- Provide technical mentorship to colleagues on enterprise analytics tools (Azure SQL Server, Azure Data Factory, Azure Synapse Analytics)

- Work with Digital Services (ICT) to modernise legacy reporting systems and implement scalable BI solutions

- Propose innovative approaches to continuously improve data infrastructure and reporting capabilities

About you

We’re looking for someone with a strong data analytical background and a passion for data. You’ll be confident working independently and collaboratively, with excellent problem-solving skills and a proactive approach.

Essential:
Ideally educated to bachelor degree level and/ or holds a relevant professional qualification, although consideration will be given to those applicants without these qualifications, but who can demonstrate they have worked at a similar level.

Proven experience with the Microsoft BI Stack, including:
- Transact SQL
- SQL Server (Azure or on-premise)
- Power BI (including DAX)
- SharePoint

Experience in data warehouse development and administration.

Proficiency in developing ETL/ELT processes using tools such as SSIS, PowerShell, SQL Agent, or equivalent cloud-based tools.

Experience with Microsoft DevOps or similar environments, including source/version control.

Full, clean, and current UK driving licence.

Desirable: - Experience with Microsoft Synapse Analytics, Azure, and Fabric. - Familiarity with GIS tools such as ESRI or QGIS. - Experience in agile project management. - Understanding of

We welcome applications from candidates who currently reside in the UK with established proof of right to work documentation. We are not able to offer sponsorship at this time for this role.

This job role is within the Corporate Services, level CORP11 job profile. Please locate this via:

Job profiles - Corporate services

To hear more about this opportunity please contact John Howard on 01992 507596 for an informal discussion about the role.

Interview Date: TBC

Benefits of working for us

How to apply

As part of your application, please upload your most recent CV. Ensure your CV is up to date with your employment history (including any employment gaps), and including any training/qualifications. We encourage you to include examples of where you have demonstrated the requirements/criteria in the advert / job profile to allow the panel to fully recognise your skills and abilities. You will have the opportunity to include a short covering paragraph within your application to give us a little more information about your skills, knowledge, and experiences.

Secondment
This position is open to secondments. If you work for HCC or any other Local Authority and would like to be considered as a Secondment contract, please ensure you complete the Secondment Form as part of your application. If you do not, your application will be considered as a Fixed Term Contract only.

Additional information

Disability Confident
We are proud to be a Disability Confident employer and guarantee an interview to anyone disclosing a disability whose application meets the minimum criteria for the post.

Safeguarding
This role has been identified as requiring a Disclosure & Barring Service (DBS) check.

Driving required
You’ll need to have the ability to drive and/or travel around Hertfordshire, either using your own mode of transport or a company car to travel to other locations.

English Fluency
The ability to converse at ease with members of the public and provide advice in accurate spoken English is essential for the post (for those whose language is a signed language the provision of a sign language interpreter who speaks English to the necessary standard of fluency will be required). Further information about the legal requirement can be found here.