Insight Support Officer - Technical

Shropshire Fire and Rescue Service is seeking a Business Intelligence Developer to join our Data Team and help develop, support and improve the data and reporting solutions our organisation relies on.

This is an exciting opportunity to use your technical skills in an organisation with a real sense of purpose. You’ll work with data and technology that supports colleagues across the Service and ultimately contributes to our work serving and protecting communities across Shropshire.

You’ll join a supportive team working across data development, business intelligence, reporting and information systems, with opportunities to learn, develop your skills and contribute ideas about how we can do things better.

What Will You Be Doing?

Reporting to the Data Team Lead, you’ll develop, maintain and support databases, data integrations, reporting solutions and information systems.

Your work will include:

• Developing and supporting solutions using SQL Server, SSIS, SSRS and Power BI;
• Creating and maintaining data integrations and ETL processes;
• Supporting our data warehouse and corporate reporting environment;
• Developing reports, dashboards and other information products;
• Working with colleagues to understand their requirements and turn them into practical technical solutions;
• Investigating and resolving data, reporting and application issues;
• Providing day-to-day support for incidents and service requests;
• Supporting internal and external information requests, including Freedom of Information requests;
• Helping ensure our data is accurate, secure and reliable; and
• Creating and maintaining clear technical documentation and operating procedures.

You’ll have the opportunity to take ownership of your work while collaborating with colleagues and sharing knowledge across the team.

We’re seeking candidates with a good technical grounding in SQL, relational databases and data or reporting development, together with strong problem-solving skills and an interest in developing effective solutions for users.

Ideally, applicants will have experience of some of the following:

• Microsoft SQL Server;
• SQL and T-SQL;
• SQL Server Integration Services (SSIS);
• SQL Server Reporting Services (SSRS);
• Power BI;
• ETL and data integration;
• data warehousing;
• Microsoft Power Platform; and
• supporting live applications, databases or reporting solutions.

You’ll also need to be able to communicate effectively with both technical and non-technical colleagues and manage your work effectively when balancing development activities with operational support.

Candidates should hold GCSE English and Mathematics at Grade C/4 or equivalent. A degree or equivalent qualification in Computer Science, Information Systems or another relevant subject would be beneficial but is not essential.

You don’t need to meet every desirable requirement to apply. If you have strong technical foundations, enjoy solving problems and are keen to develop your skills while contributing to a vital public service, we’d be pleased to hear from you.

The post is located at Service Headquarters, Shrewsbury, providing free on-site parking.

The role also includes the following benefits:

• Local Government Pension Scheme
• Flexible Working Hours Scheme
• Paycare Health Benefits
• Occupational Health Services
• Hybrid working (1 day per week homeworking)

Shropshire Fire and Rescue Service have a strong commitment to equality, diversity and inclusion at work. We want to reflect the communities we service and therefore we positively welcome applicants from disabled people and minority groups who are under-represented in our Service.