Business Intelligence Analyst

Hertfordshire; Farnham; Presencial; CAD 75.000 - 82.000; A tiempo parcial

Descripción de la vacante

Hertfordshire County Council is seeking a Business Intelligence Analyst to develop, maintain and enhance Power BI dashboards and data models within the Resources directorate. You will work closely with service leads, practitioners and data owners to deliver robust analytics products that inform decision-making and service improvement.

The role emphasizes data quality, governance and secure handling of information, with opportunities to influence how data supports performance management and

Formación

• Experience with complex, structured datasets for reliable reporting.
• End-to-end BI solutions with Power BI, data modelling and DAX.
• SQL querying across multiple tables and databases.
• Strong analytical and problem-solving skills with data quality focus.

Responsabilidades

• Develop and maintain Power BI dashboards and reports.
• Translate reporting needs into technical requirements.
• Analyse data to identify trends, risks and improvement opportunities.
• Validate and reconcile data across source systems.
• Support data governance and secure data handling.
• Produce timely, user-focused reporting for performance management.

Conocimientos

Power BI

SQL

Data modelling

Data analysis

Stakeholder engagement

Attention to detail

Governance & security

Educación

Bachelor's degree in data analytics, information technology or related discipline

Herramientas

DAX

SQL Server

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.