Data Analyst

Scrumconnect Consulting; Staines-upon-Thames; On-site; GBP 53,000 - 93,000; Full time

Job summary

Scrumconnect Consulting is seeking a data analytics professional to translate stakeholder requirements into accessible dashboards and reports. You will develop data models, optimize dashboards with Power BI, DAX, Excel and SQL, and deliver scalable visualisations for diverse stakeholders.

You will integrate multiple data sources, cleanse and prepare data, and apply statistical techniques to support data-driven decisions.

Qualifications

• Advanced experience translating stakeholder requirements into intuitive, accessible dashboards and reports that enable self-service data exploration.
• Strong experience with Microsoft Power BI, DAX and Excel to develop data models and create efficient, optimised and scalable reports and visualisations.
• Ability to design dashboards that clearly communicate complex data and insights to a range of stakeholders.
• Strong experience integrating multiple data sources into a conformed data model for analysis.
• Proficiency in SQL, Python, Power Query and M.
• Experience in data cleansing, transformation and preparation for reporting and analysis.
• Proven experience applying a broad range of statistical techniques to support data-driven decision-making.
• Strong understanding of averages, standard deviation, correlation, regression and statistical significance testing.
• Ability to interpret statistical results and communicate findings clearly to both technical and non-technical stakeholders.
• Experience monitoring emerging technologies and assessing their potential application to dashboard and data visualisation products.
• Ability to provide recommendations on tools and technologies that can improve reporting and data visualisation capabilities.
• Key skills: Power BI, DAX, Excel, SQL, Python, Power Query, M, Data Modelling, Data Visualisation, Statistical Analysis.

Responsibilities

• Analyse data and develop insightful dashboards.
• Provide data-driven insights to support informed decision-making.
• Translate stakeholder requirements into intuitive, accessible dashboards and reports.
• Develop data models and create efficient, optimised and scalable reports and visualisations.
• Design dashboards that communicate complex data and insights to a range of stakeholders.
• Integrate multiple data sources into a conformed data model for analysis.
• Carry out data cleansing, transformation and preparation for reporting and analysis.
• Apply statistical techniques to support data-driven decision-making.
• Interpret statistical results and communicate findings clearly to technical and non-technical stakeholders.
• Monitor emerging technologies and assess their potential application to dashboard and data visualisation products.
• Provide recommendations on tools and technologies that can improve reporting and data visualisation capabilities.

Skills

Power BI

DAX

Excel

SQL

Python

Power Query

M

Data Modelling

Data Visualisation

Statistical Analysis

Tools

Power BI

DAX

Excel

SQL

Python

Power Query

M

Job description

Salary: £53,000 - 93,000 per year

Requirements:

• Advanced experience translating stakeholder requirements into intuitive, accessible dashboards and reports that enable self-service data exploration.
• Strong experience with Microsoft Power BI, DAX and Excel to develop data models and create efficient, optimised and scalable reports and visualisations.
• Ability to design dashboards that clearly communicate complex data and insights to a range of stakeholders.
• Strong experience integrating multiple data sources into a conformed data model for analysis.
• Proficiency in SQL, Python, Power Query and M.
• Experience in data cleansing, transformation and preparation for reporting and analysis.
• Proven experience applying a broad range of statistical techniques to support data-driven decision-making.
• Strong understanding of averages, standard deviation, correlation, regression and statistical significance testing.
• Ability to interpret statistical results and communicate findings clearly to both technical and non-technical stakeholders.
• Experience monitoring emerging technologies and assessing their potential application to dashboard and data visualisation products.
• Ability to provide recommendations on tools and technologies that can improve reporting and data visualisation capabilities.
• Key skills: Power BI, DAX, Excel, SQL, Python, Power Query, M, Data Modelling, Data Visualisation, Statistical Analysis.

Responsibilities:

• Analyse data and develop insightful dashboards.
• Provide data-driven insights to support informed decision-making.
• Translate stakeholder requirements into intuitive, accessible dashboards and reports.
• Develop data models and create efficient, optimised and scalable reports and visualisations.
• Design dashboards that communicate complex data and insights to a range of stakeholders.
• Integrate multiple data sources into a conformed data model for analysis.
• Carry out data cleansing, transformation and preparation for reporting and analysis.
• Apply statistical techniques to support data-driven decision-making.
• Interpret statistical results and communicate findings clearly to technical and non-technical stakeholders.
• Monitor emerging technologies and assess their potential application to dashboard and data visualisation products.
• Provide recommendations on tools and technologies that can improve reporting and data visualisation capabilities.

Technologies:

• DAX
• Excel
• Support
• Power BI
• Power Query
• Python
• SQL

More:

We are Scrumconnect Consulting, a multi-award-winning digital consultancy recognised for delivering impactful and innovative technology solutions across UK government departments. Our work has positively influenced the lives of over 40 million UK citizens. We are passionate about user-centred design, agile delivery, and building digital services that make a real difference. Our teams work at the forefront of innovation, helping organisations transform and deliver high-quality, scalable solutions that truly matter. We are committed to diversity and inclusion, 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. As a Disability Confident Level 1 employer, we are committed to providing reasonable adjustments throughout the recruitment process and during employment to ensure equal opportunities for all.

last updated 36 week of 2026