Job Title: Business Intelligence Analyst
Starting Salary: £39,481 progressing to £43,149 per annum (pro rata for part time)
Hours: 37
Location:  Stevenage SG1 2FQ
Contract Type: Fixed Term for 12 months
Directorate: Resources

About the team

Business Intelligence and Data team sits centrally and supports services across the council to make effective use of data, improve performance and enable evidence-based decision-making. You will work collaboratively with service, performance and technical colleagues to develop reliable, user-focused Power BI, data modelling and analytical solutions.

The role offers the opportunity to work closely with Children’s Services, using data and insight to support service improvement, performance monitoring and better outcomes for children, young people and families. You will help maintain high standards of data quality, governance and security, while contributing to the development of modern business intelligence, Artificial Intelligence (AI) and data solutions that turn complex data into meaningful and actionable insight.

About the role

• Develop, maintain and enhance I&S semantic models, datasets, dashboards and reports using Power BI and associated data technologies.
• Work with I&S service leads, practitioners and data owners to understand reporting needs and translate them into clear technical requirements and robust analytical products.
• Analyse complex I&S data to identify trends, risks, demand pressures and opportunities for service improvement, presenting findings clearly to operational and senior stakeholders.
• Undertake detailed data validation, reconciliation and quality assurance across source systems, resolving inconsistencies and documenting agreed definitions and business rules.
• Support the design of efficient and sustainable data flows, reporting processes and governance arrangements for I&S information.
• Produce accurate, timely and user-focused reporting to support performance management, service planning, assurance and decision-making.
• Provide technical advice and guidance to colleagues, promoting consistent interpretation and effective use of I&S data and reporting products.
• Manage assigned work packages and competing priorities, proactively identifying risks, dependencies and actions required to deliver to agreed timescales.
• Maintain clear technical and user documentation to support resilience, governance and continuous improvement.
• Contribute to wider Business Intelligence & Data standards and improvement activity where this supports effective delivery of I&S priorities.

About you

Essential:

• Demonstrable experience of working with complex structured datasets to produce accurate, reliable and user-focused analysis and reporting.
• Experience of developing end to end business intelligence solutions using Power BI, including data modelling, data transformation, DAX and interactive dashboard/report development.
• Experience of working with relational databases and SQL, including querying, joining and manipulating data from multiple tables, views and databases.
• Strong analytical and problem-solving skills, with evidence of interpreting, reconciling and validating data from multiple or inconsistent sources.
• Experience of applying data quality principles, including identifying data issues, applying agreed definitions and ensuring the accuracy and consistency of reporting outputs.
• Ability to work independently and methodically, managing competing priorities and delivering high-quality outputs to agreed deadlines.
• Excellent attention to detail, with evidence of producing accurate analysis, reports and supporting documentation.
• Understanding of data governance, security and appropriate handling of sensitive or confidential information.
• Strong communication and stakeholder engagement skills, with the ability to explain complex data and technical information clearly to both technical and non-technical audiences.
• Evidence of working collaboratively with service, business and technical colleagues, including the ability to challenge requirements or data constructively where appropriate.
• Ability to learn and apply new technical knowledge, systems and analytical approaches quickly.
• Degree-level qualification in data analytics, statistics, information technology or a related discipline, or equivalent relevant professional experience.
  
  

 Desirable:

• Knowledge or experience of Children’s Services, including relevant data, systems, performance reporting and operational processes.
• Experience of working with sensitive or personal data in a public-sector or similarly regulated environment.
• Knowledge or experience of I&S data, systems and associated business processes.

This is a varied and rewarding role where you will use data and business intelligence to support Inclusion and Skills services, helping colleagues better understand demand, performance and outcomes for children, young people, families and learners. You will tackle complex data challenges and turn them into reliable, meaningful insight that supports service improvement and informed decision-making. The role offers excellent opportunities to develop your Power BI, data modelling and analytical skills while building knowledge of I&S services. You will also have the opportunity to influence positive change by improving how data is used, challenging existing approaches and helping shape the future development of our business intelligence and reporting solutions.

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 Level 10. Please locate the job profile here:

Job profiles - Corporate services

To hear more about this opportunity please contact Albert.Essandoh@hertfordshire.gov.uk for an informal discussion about the role.

We reserve the right to close this advert early if required

Interview Date: 5 working days notice

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 role is open to secondments for eligible employees who work for HCC. If you wish to apply on a secondment basis, you must have your line manager’s approval before submitting your application. You will be asked to confirm this within your application form. If you are not eligible for a secondment (e.g., you are currently on a fixed‑term contract that would end before this positions ends) or you indicate that your manager cannot support a secondment, your application will be considered on a fixed‑term contract basis instead.

Additional information

We are changing
Hertfordshire County Council is undergoing Local Government Reorganisation (LGR), creating a unique opportunity to help shape the future of local services. To find out more, visit https://www.hertfordshire-lgr.co.uk/

DisabilityConfident
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.

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.