Business Intelligence Analyst
Substantive Vacancy – Business Intelligence Analyst
Staffordshire Fire & Rescue Service – Headquarters
This is an exciting opportunity to join our Performance & Assurance Team, and to help us to influence the decision-making and continuous improvement of Staffordshire Fire & Rescue Service. The Performance and Assurance team act as a centralised hub for data within Staffordshire Fire and Rescue Service. The department is responsible for monitoring and presenting Service performance data, and providing data externally, to meet the statutory requirements of Freedom of Information requests and collections for national statistics.
Salary: Grade 5 (£22,571 to £24,920)
Hours: 37 hours per week (Flexible Working Scheme available)
Location: Based at Service Headquarters, Pirehill, Stone, Staffs, ST15 0BS
Status: Permanent contract
About the Role
The role of Business Intelligence Analyst is an important and technical one, and involves using areas of technicality in utilising SQL queries to obtain data from Service information systems, as well as the analysis and presentation of this data. The direction of the department is to implement a PowerBI platform for future reporting, with the intention to create dashboards for both strategic (public facing) and service delivery (internal) Key Performance Indicators. Previous experience in PowerBI is not essential as training will be provided, however, experience in using this product will be advantageous.
Duties to Include
To lead the Service in the provision of analytical reports and research documents that are comprehensive, accurate, and of a professional standard to meet departmental and Service requirements, as well as those of external stakeholders.
To utilise technical skills in SQL query writing in Microsoft SQL Server Management Studio, PgAdmin and PowerBI, to interrogate service systems and collate and assemble data to respond to internal, external, and statutory data requests such as Freedom of Information Requests, Home Office, and HMICFRS Data collection requirements.
To attend meetings and working groups as a subject matter expert, and to assist departments and operational staff with understanding and developing the provision of data to meet their requirements and assist in developing Key Performance Indicators; also provide advice and guidance where required.
To collate data on Key Performance Indicators for the Service’s Performance Dashboard from both internal and external data sources, and to analyse performance information to produce high quality narrative for use in strategic report writing.
To manage the Service’s HMICFRS Action Planning system effectively; adding and assigning actions, setting delivery dates and obtaining updates from action owners across the Service to monitor the progress of HMICFRS activity closely.
To manage the Service’s monitoring of annual departmental and service delivery plans, ensuring objectives are defined, setting delivery dates, and obtaining updates from action owners across the Service.
To assist the department in monitoring the progress of Fire Standards Implementation throughout the Service.
To provide support for software systems and databases, and to validate and maintain information systems and databases, providing assistance to users of these systems.
To assist with data assurance activity within the Service, ensuring that data quality checks are completed and that any data quality issues are recorded, communicated, and resolved.
To provide training, and to assist and coordinate with others within the Performance and Assurance team and also within the wider organisation on the use of data tools, reporting methods and information management systems.
To assist in the development and updating of guidance notes relating to departmental processes, procedures and system documentation.
To assist in managing the email inbox of the department, allocating and coordinating tasks as required.
Person Specification:
Essential
Education and Training
Can demonstrate previous experience in analysing data and creating high quality narrative reports.
Can demonstrate previous experience in utilising SQL queries to interrogate data systems
Knowledge and experience.
Experience and knowledge of manipulating data using Microsoft Excel
Experience of analysing and presenting information within an organisation
Experience of collating information and creating high level reports
Experience of utilising research techniques and analysing trends
Experience of utilising SQL in order to query databases and obtain information.
Skills abilities and personal qualities
Technical skill in creating SQL queries
Communicates effectively; both orally and in writing
Interacts well with colleagues to achieve workable solutions
Excellent analytical and problem-solving skills
Capable of prioritising own workload and working on own initiative
Use of Microsoft Office applications, in particular MS Excel to model data
Desirable
Experience of designing SQL reports and utilising SQL (SSRS) reporting services
Experience of using Microsoft SharePoint and office 365.
Knowledge and experience of using of data assurance and evaluation techniques
Knowledge and Experience of using Microsoft PowerBI to develop reports, dashboards and access information.
Relevant experience of working within the fire or a public sector role
Benefits of working for Staffordshire Fire and Rescue Service:
Enhanced Annual Leave Entitlement
Generous Pension scheme
Access to Onsite Gyms and Fitness Advisor
Free Parking at most sites
Enhanced Maternity Package
Benefits are paid on satisfying the eligibility criteria
Occupational Health – On-site fully funded Occupational health centre to support all employees.
Employee Assistance Programme (EAP) – An EAP is an online and telephone employee benefit designed to help you deal with personal and professional problems that could be affecting your home life or work life, health and general wellbeing.
Eye Tests
Flexible Working Scheme – Flexible working in operation to allow employees, where possible, to flexible start and finish work meeting both personal and the organisational needs.
The Firefighter Charity – “Support the mental, physical and social needs of all serving and retired members of the UK’s fire family. Here’s everything you need to know” https://www.firefighterscharity.org.uk/
Cycle Scheme
Blue Light Card
Flamesavers – A credit union offering SFRS personnel loans and saving accounts.
Rewards for Rescue
Staffordshire have a strong commitment to equality and diversity in our people, within the organisation and in the services we provide to our communities.
We want to reflect the communities we serve and one way we can try to achieve this is through a ‘positive action’ approach. Positive action is activity which helps employers identify and remove barriers and issues to the recruitment, retention and progression of people who identify with underrepresented groups of the Equalities Act 2010 (i.e. LGBT+, ethnicity, disability), whilst still employing people on merit.
Click here to register your interest in being involved in positive action opportunities and support; Positive.action@staffordshire.pnn.police.uk
Additional Information:
This Business Intelligence Analyst vacancy is being advertised internally and externally.
Closing date for receipt of all applications is midnight 11th September 2022.
All communication regarding this vacancy will be issued via email, so please check your email account on a regular basis.
If you have any enquiries please contact:-
Recruitment@staffordshirefire.gov.uk, or
Will Parkinson – Performance & Assurance Manager, 07967 573588 or
Steph Cooper – HR Officer, 07528 083155