Data Analyst

Scrumconnect

Newcastle upon Tyne

On-site

GBP 42,000 - 66,000

Full time

37 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Impactful UK public sector projects
Collaborative environment
Professional development

Job summary

Scrumconnect Consulting is recruiting an experienced Data Analyst to join our team and support a UK public sector client. You will analyse complex datasets, build insightful dashboards, and deliver data-driven recommendations to inform decision-making.

You will work with stakeholders and multidisciplinary teams to integrate data from multiple sources, identify trends and communicate findings effectively. Strong Power BI, DAX, SQL and Python skills are essential.

Qualifications

  • Strong expertise in Power BI, DAX, SQL and Python.
  • Ability to translate stakeholder requirements into dashboards.
  • Experience with data modelling, data integration and visualisation.

Responsibilities

  • Translate stakeholder requirements into intuitive, accessible dashboards and reports.
  • Develop interactive dashboards using Power BI, DAX and Excel for self-service data exploration.
  • Build scalable data models and reporting solutions.
  • Design clear visualisations for technical and non-technical stakeholders.
  • Ensure dashboards are accurate, accessible and aligned with business needs.
  • Integrate data from multiple sources and develop conformed data models.
  • Apply SQL and Python to extract and interpret complex datasets.
  • Communicate analytical findings to drive evidence-based decisions.
  • Promote best practices in data modelling, dashboard design and performance.

Skills

Stakeholder engagement
Analytical thinking
Problem solving

Tools

Power BI
DAX
Excel
SQL
Python
Power Query
M
Data Modelling
Data Integration
Data Visualisation
Statistical Analysis
Dashboard Development

Job description

Newcastle, United Kingdom | Posted on 18/11/2026

Scrumconnect Consulting is a multi-award-winning UK digital consultancy delivering impactful technology and digital transformation services across the public sector.

We work with central government departments and public sector organisations to build user-centred digital services, improve operational efficiency and deliver meaningful outcomes for citizens.

We are looking for an experienced Data Analyst to join our team and support one of our UK public sector clients.

Role Overview

The Data Analyst will be responsible for analysing complex datasets, developing insightful dashboards and delivering data-driven recommendations to support informed decision-making.

The successful candidate will have strong expertise in Power BI, DAX, SQL, Python and statistical analysis, alongside the ability to translate stakeholder requirements into intuitive dashboards and meaningful business insights.

You will work closely with stakeholders and multidisciplinary teams to integrate data from multiple sources, identify trends and patterns, and communicate analytical findings effectively.

Key Responsibilities

Translate stakeholder requirements into intuitive, accessible and user-friendly dashboards and reports.

Develop interactive dashboards using Microsoft Power BI, DAX and Excel to support self-service data exploration.

Build efficient, optimised and scalable data models and reporting solutions.

Design clear and meaningful visualisations to communicate complex information to technical and non-technical stakeholders.

Ensure dashboards and reports are accurate, consistent, accessible and aligned with business requirements.

2. Data Analysis & Synthesis

Integrate data from multiple sources and develop conformed data models to support consistent reporting and analysis.

Use SQL and Python to extract, analyse and interpret complex datasets.

Apply Power Query and M for data transformation, cleansing and preparation.

Identify data quality issues, inconsistencies and trends, recommending appropriate improvements.

Translate analytical findings into actionable insights that support business and operational decisions.

Apply a range of statistical techniques to identify patterns, trends and relationships within datasets.

Demonstrate a strong understanding of statistical concepts, including averages, standard deviation, correlation, regression and statistical significance testing.

Interpret statistical results and explain their implications clearly to technical and non-technical stakeholders.

Use appropriate analytical methods to support evidence-based decision-making.

4. Dashboarding Technology & Innovation

Keep up to date with emerging technologies and developments in data analytics and visualisation.

Evaluate new tools, techniques and technologies that could improve dashboarding and reporting capabilities.

Recommend improvements to existing reporting solutions, analytical processes and data visualisation products.

Promote best practices in data modelling, dashboard design, performance optimisation and reporting.

Strong hands-on experience in data analysis and business intelligence.

Advanced experience with Microsoft Power BI, including dashboard development, DAX and data modelling.

Strong proficiency in SQL and experience working with complex datasets.

Practical experience using Python for data analysis and manipulation.

Strong experience with Power Query and M.

Advanced Excel skills, including data analysis and reporting.

Experience integrating multiple data sources into conformed data models.

Strong understanding of statistical analysis and techniques.

Ability to translate complex data into clear insights and actionable recommendations.

Excellent communication and stakeholder engagement skills.

Ability to explain analytical findings to both technical and non-technical audiences.

Key Technical Skills

Power BI | DAX | Excel | SQL | Python | Power Query | M | Data Modelling | Data Integration | Data Visualisation | Statistical Analysis | Dashboard Development

What We Offer

The opportunity to work on impactful UK public sector digital transformation projects.

A collaborative environment working alongside experienced data and technology professionals.

Opportunities to develop technical and analytical expertise.

A supportive culture that encourages continuous learning and professional development.

Diversity & Inclusion

At Scrumconnect Consulting, we believe that diversity drives innovation and better outcomes. We are committed to fostering an inclusive environment where every individual is valued, respected and supported.

We welcome applications from candidates of all backgrounds and actively encourage individuals from under-represented groups, including women, people with disabilities and diverse communities, as well as those seeking flexible working arrangements.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst
Data Analyst

Scrumconnect • United Kingdom

Hybrid
GBP 40,000 - 65,000
Flexible working
Disability Confident Level 1
Data Analyst (SC Cleared)
Data Analyst (SC Cleared)

Scrumconnect Consulting • Newcastle upon Tyne

Hybrid
GBP 45,000 - 65,000
Senior Data Engineer
Senior Data Engineer

Scrumconnect Consulting • Bridgend

On-site
GBP 70,000 - 110,000
Senior Data Engineer
Senior Data Engineer

Scrumconnect Ltd • Newcastle upon Tyne

On-site
GBP 65,000 - 90,000
Data Scientist
Data Scientist

Scrumconnect Ltd • Greater London

On-site
GBP 60,000 - 90,000
Data Engineer (SC Eligible/ SC Cleared)
Data Engineer (SC Eligible/ SC Cleared)

Scrumconnect Ltd • Newcastle upon Tyne

Hybrid
GBP 65,000 - 90,000
Flexible part-time hours
Mostly remote working
Learning opportunities
+1
Data / MI Business Analyst (SC Cleared)
Data / MI Business Analyst (SC Cleared)

Scrumconnect Ltd • Greater London

On-site
GBP 60,000 - 90,000
Diversity & Inclusion
Disability Confident Level 1 employer
Senior Data Analytics Engineer ( SC Cleared/ SC Eligible )
Senior Data Analytics Engineer ( SC Cleared/ SC Eligible )

Scrumconnect • Greater London

Hybrid
GBP 70,000 - 95,000
Public Sector Data Analyst — Power BI, SQL & Python
Public Sector Data Analyst — Power BI, SQL & Python

Scrumconnect • Newcastle upon Tyne

On-site
GBP 42,000 - 66,000
Impactful UK public sector projects
Collaborative environment
Professional development
AWS Data Engineer – Power BI
AWS Data Engineer – Power BI

Scrumconnect Ltd • Lancashire

On-site
GBP 90,000 - 120,000
Flexible working arrangements