Business Intelligence Analyst

Hertfordshire; Stevenage; A distancia; GBP 39.000 - 43.000; Jornada completa

Descripción de la vacante

Hertfordshire County Council in Stevenage is seeking a Business Intelligence Analyst to join the central BI and Data team. You will develop Power BI dashboards, data models and reporting to support services across the council, with a focus on Children’s Services and performance improvement.

The role requires strong SQL, data modelling and data quality practices, along with clear communication to technical and non-technical stakeholders.

Formación

• Degree or equivalent in data analytics, statistics, information technology or related field.
• Experience building BI solutions with Power BI, including data modelling and dashboards.
• Experience with relational databases and SQL querying.

Responsabilidades

• Develop, maintain and enhance Power BI dashboards, datasets and reports.
• Translate reporting needs into technical requirements and robust analytical products.
• Analyse complex data to identify trends, risks and opportunities for service improvement.
• Perform data validation, reconciliation and quality assurance across source systems.
• Support design of data flows, reporting processes and governance for information assets.
• Produce accurate, timely reports to support performance management and decision-making.
• Provide technical guidance to colleagues on data and reporting practices.
• Manage work packages, priorities and deadlines.
• Maintain technical and user documentation for resilience and governance.
• Contribute to BI data standards and improvement activities.

Conocimientos

Analytical thinking

Stakeholder engagement

Data storytelling

Attention to detail

Problem solving

Educación

Degree in data analytics or related field

Herramientas

Power BI

SQL

Data modelling

Descripción del empleo

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

• 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.
• 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:

We reserve the right to close this advert early if required

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/

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.

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.