Business Intelligence Analyst - Children's (Reforms)

North Somerset Council; Weston-super-Mare; Hybrid; GBP 30,000 - 45,000; Full time

Job summary

A local government organization in Weston-super-Mare is seeking a Business Intelligence Analyst to support the Children’s BI team. This role involves data analysis and visualization using SQL and Power BI, with responsibilities including data collection and interpretation to improve children's outcomes. The ideal candidate will have strong Excel skills and some knowledge of business intelligence protocols. Flexible working arrangements are available, along with a competitive salary and various employee benefits.

Benefits

Competitive salary

Flexible working arrangements

Opportunities for professional development

Salary sacrifice cycle to work schemes

Access to wellbeing resources

Qualifications

• Strong experience with intermediate to advanced Excel.
• Experience in collecting, analysing, and interpreting data to support decision making.
• Awareness of business intelligence protocols, including GDPR.

Responsibilities

• Collect, analyse, and interpret data for reporting requirements.
• Produce comparative data and performance reports.
• Extract data using SQL and visualize using Power BI.

Skills

Data analysis

SQL

Power BI

Excel

Education

NVQ Level 4 in relevant field

Tools

Microsoft Office Suite

Power BI

Tableau

Job description

About Us

North Somerset Council is dedicated to providing high-quality services to our community. We are committed to creating a fair, green, and more inclusive environment for all our residents. Join us and contribute to making a positive impact on our community.

The Role

Our Business Intelligence Service is responsible for council-wide data collection, analysis, visualisation, and performance reporting. We have an exciting opportunity for a Business Intelligence Analyst to join our service in the Children’s BI team. You will be dealing primarily with children social care data using tools such as SQL, Power BI and excel to analyse that data and provide insight.

We’re looking for someone who is interested in data and information and curious to apply any insights to improve outcomes for our children. You will have strong expertise in using excel and ideally have some knowledge of using SQL and PowerBi. You should also have some awareness of the roles and responsibilities of local authorities.

If you’re ready to use your analytical skills to make a real impact, we’d love to hear from you.

Key Responsibilities

• Collect, analyse, and interpret data to meet statutory reporting requirements and produce ad hoc reports.
• Present clear, accurate evidence to inform decision making.
• Produce comparative data and performance reports.
• Develop ways to improve data accuracy and quality.
• Respond to Freedom of Information Requests and any other adhoc requests for information, data and analysis.
• Extract data using SQL.
• Visualise data using Power BI.

Work Style

At North Somerset Council, we offer a hybrid working environment based on four distinct work styles. Depending on the role and personal circumstances, you will fall into one of these categories. However, please note that during the induction period, it may be necessary to spend more time in the office to support your learning and development. We are flexible and open to discussions about your preferred working style, and if you wish to be in the office more frequently, this can be negotiated.

This role falls into the category of Mobile Worker which means you can expect to work in the following way:

• 0-1 day in the office.
• Includes field workers who primarily work remotely.
• Comes into the office for meetings or focused work. Virtual connections with the team are essential, with portable technology supporting work on the go.

About You

We are looking for an individual who is passionate about data, analysis and who possesses the following skills and experience:

Essential Criteria

• Technically specific skills relevant to business intelligence/data analysis at NVQ Level 4 standard.
• Strong experience with Microsoft Office Suite, especially intermediate to advanced Excel.
• Ability to undertake statistical and analytical reasoning in specific work areas.
• Experience in collecting, analysing, and interpreting data to support decision making.
• Awareness of business intelligence protocols, including GDPR, statutory returns, and performance monitoring.

Desirable Criteria

• Familiarity with advanced statistical tools or BI platforms (e.g., Power BI, Tableau, SQL).
• Experience of working within a local authority or public sector environment.
• Knowledge of performance indicator frameworks and statutory reporting requirements.

What We Offer

At North Somerset Council, we value our employees and provide a supportive and inclusive work environment.

• Competitive salary and benefits.
• Flexible working arrangements.
• Opportunities for professional development.
• Staff groups.
• Opportunity to purchase up to an additional 10 days annual leave each year.
• Dedicated Wellbeing Team.
• Salary sacrifice cycle to work and Electric vehicle schemes.

Further details of our excellent rewards package can be found in our Benefits booklet.

How To Apply

If you share our vision and values and are ready to make an impact to North Somerset, please select the apply button below. If you are interested in this exciting opportunity, please submit your application by 11.59pm on the application closing date. When completing our online application form, please detail how you meet the essential criteria for the role.

Contact Information

For further information about the role, please contact Hannah Batts, Principal Business Intelligence Lead, by email [e-mail].

Important Information

Anticipated Interview Date: Friday 05 December 2025.

We are currently only able to accept applications from candidates who have full permission to work in the UK.

Equal Opportunities

At North Somerset Council we want all our employees to feel valued and appreciated. We aim to ensure equality of opportunity and prevent discrimination irrespective of your sex, gender identity, sexual orientation, religion or belief, race, age, disability, including neurodiversity, if you are married or in a civil partnership or are pregnant or currently on maternity leave. We strive to create a workplace that reflects the communities we serve and where everyone feels empowered to bring their full, authentic selves to work.

We are committed to safeguarding and promoting the welfare of children and young people and expect all our staff and volunteers to share this commitment.

As a Disability Confident Leader, we guarantee to interview all disabled applicants who meet the essential criteria for the job role.