Performance & Insight Engineer

Bedfordshire Fire and Rescue Service; Bedford; Hybrid; GBP 45,000 - 65,000; Full time

Benefits offered by this job

Hybrid working patterns

Flexi-time scheme

Local Government Pension Scheme

25 days holiday (pro rata)

Free gym access and onsite parking

Lifestyle Savings platform

Blue Light Card

Job summary

Bedfordshire Fire and Rescue Service seeks a data professional to design and maintain reliable data systems, turning complex information into insight for decision-making. You will build databases, data warehouses, and ETL pipelines from internal and public data sources, ensuring data quality and governance.

Responsibilities include managing automated ETL workflows, conducting cyclical reporting, and handling FOI requests.

Qualifications

• Degree in a Mathematical, Statistical, Scientific or Technology-related subject.
• In-depth experience of SQL development, including writing complex queries and building stored procedures.
• In-depth experience of data modelling for reporting purposes.
• Significant experience of data analysis to produce insightful reports.
• In-depth experience of creating ETL workflows to process data from multiple sources.
• Skills in Microsoft SQL Server programming.

Responsibilities

• Build and maintain databases and data warehouse structures to support reporting and analysis, ensuring compliance with the Service's data governance, quality and security policies.
• Develop, optimise and maintain SQL based ETL processes to populate databases and data warehouse structures, to ensure performance, reliability and scalability and facilitate timely, accurate reporting.
• Improve governance processes by developing, documenting and maintaining automated workflows and ETL processes with associated error handling.
• Complete ad hoc imports into, and updates of, SQL data tables, SharePoint repositories and other internal data sources to ensure timely availability of non-automated data sources for reporting purposes.
• Develop and maintain auditing and monitoring for existing and new automated ETL processes to identify failures or data quality issues promptly and support rapid resolution.
• Maintain processes for the anonymisation and deletion of data in line with the Service's data retention and information governance policies.
• Use data analysis and visualisation tools to analyse data, identify trends, correlations and outliers and produce clear, compelling outputs tailored to different audiences.
• Validate data quality by identifying issues and working with data owners to address root causes, ensuring accurate and reliable data is used for reporting and decision making.
• Create and maintain technical documentation, including data dictionaries, data models and process flow diagrams, to support transparency, maintainability, auditability and business continuity.
• Respond to internal and external requests for information accurately and in a timely manner, in compliance with Service policies and statutory requirements, including preparing responses to Freedom of Information requests.

Skills

SQL development

Data modelling

Data analysis

ETL workflows

Process automation platform

FOI legislation knowledge

Education

Degree in Mathematical, Statistical, Scientific or Technology-related subject

Tools

Microsoft SQL Server

Automation platform

Job description

Are you passionate about data, able to use your skills to develop and maintain reliable data systems and turn complex information into compelling insight?

If so, we are looking for a skilled professional to join our team. This role combines technical data engineering with analytical thinking, requiring someone who can not only manage and transform data, but also interpret it, communicate its significance, and help shape decisions across Bedfordshire Fire and Rescue Service.

About The Role

You will build and maintain databases, data warehouses, pipelines and automated Extract, Transform, Load (ETL) processes that facilitate reporting, analysis and insight using internal data sets from the Service's systems, and external data shared with the Service or from the public domain.

You will ensure that databases and data warehouses are populated accurately, accessible and efficiently structured for reporting and analysis. You will make use of SQL-based data engineering and automated workflows

You will provide high-quality analysis and insight to support decision-making. You will also lead on cyclical reporting, both internal and to external stakeholders, and prepare responses to ad-hoc data requests, including Freedom of Information requests.

Key Responsibilities

• Build and maintain databases and data warehouse structures to support reporting and analysis, ensuring compliance with the Service's data governance, quality and security policies.
• Develop, optimise and maintain SQL based ETL processes to populate databases and data warehouse structures, to ensure performance, reliability and scalability and facilitate timely, accurate reporting.
• Improve governance processes by developing, documenting and maintaining automated workflows and ETL processes with associated error handling. This will benefit administration and uptime of key data for reporting and analysis purposes.
• Complete ad hoc imports into, and updates of, SQL data tables, SharePoint repositories and other internal data sources to ensure timely availability of non-automated data sources for reporting purposes.
• Develop and maintain auditing and monitoring for existing and new automated ETL processes to identify failures or data quality issues promptly and support rapid resolution.
• Maintain processes for the anonymisation and deletion of data in line with the Service's data retention and information governance policies.
• Use data analysis and visualisation tools to analyse data, identify trends, correlations and outliers and produce clear, compelling outputs tailored to different audiences.
• Validate data quality by identifying issues and working with data owners to address root causes, ensuring accurate and reliable data is used for reporting and decision making.
• Create and maintain technical documentation, including data dictionaries, data models and process flow diagrams, to support transparency, maintainability, auditability and business continuity.
• Respond to internal and external requests for information accurately and in a timely manner, in compliance with Service policies and statutory requirements, including preparing responses to Freedom of Information requests.

About You

You will have:

• You must have the right to live and work in the UK. We are unable to offer sponsorship.
• A degree or equivalent in a Mathematical, Statistical, Scientific or Technology-related subject.
• In-depth experience of SQL development, including writing complex queries and building stored procedures.
• In-depth experience of data modelling for reporting purposes.
• Significant experience of data analysis to produce insightful reports.
• In-depth experience of creating extract, transform and load (ETL) workflows to process data from multiple sources.
• Skills in Microsoft SQL Server programming.
• Skills in using a process automation platform.
• A working understanding of Freedom of Information legislation.
• Knowledge of data warehousing methodologies.

For more details on the essential criteria required for the role, please see the attached job description and person specification.

Why work with us

We recognise that you are looking for more than just a career. A few of our benefits include:

• Hybrid working patterns
• Flexi-time scheme including flexible start and finish times, variable lunch breaks and flexi-leave days
• Local Government Pension Scheme
• Holiday allowance of 25 days* (plus public holidays) on joining; increasing to 30 days* after 5 years' service and 32 days after 10 years' service (*pro rata if part time or irregular working pattern)
• Free gym access and onsite parking
• Instant access to 'Lifestyle Savings' platform includes a range of discount cards from well-known and independent retailers
• Eligible to sign up to 'Blue Light Card' with access to thousands of amazing discounts online and on the high street.

Next steps

Closing date: Thursday 22 October 2026

Interviews will take place on Monday 2 November 2026

This post will be exempt from the provisions of Section 4 (2) of the Rehabilitation of Offenders Act 1974 (Exceptions) (Amendment) (England and Wales) Order 2023. Therefore, applicants are not entitled to withhold information about convictions which for other purposes are 'spent' under the provision of the Act.

The appointment will be made subject to satisfactory pre-employment clearances, including an enhanced Disclosure and Barring Service (DBS) clearance at the level required for the role.

Bedfordshire Fire and Rescue Service's recruitment and selection procedures reflect our commitment to safer recruitment, and to safeguarding and promoting the welfare of Adults, Children and Young People and all staff and volunteers are expected to share this commitment.

Bedfordshire Fire and Rescue Service is an equal opportunities employer that welcomes applications from all sections of the community.

As a Disability Confident employer, we guarantee an interview to disabled applicants who meet the minimum criteria for the role. Reasonable adjustments are available throughout the recruitment process.

As part of our commitment to the Armed Forces Covenant, we encourage applications from those who have served, are serving, or are part of a military family. Your skills and experience are valued here.

Please note that we are unable to offer sponsorship. You must have the right to live and work in the UK.