Data & Power BI Analyst: Automated PMO Dashboards

The Clancy Group; Basingstoke; On-site; GBP 40,000 - 55,000; Full time

Job summary

A leading construction firm in Basingstoke seeks a Digital & Data Analyst to enhance automated reporting and data integration using Microsoft Power Platform tools. Responsibilities include data collection, cleaning, and reporting, while improving workflows and developing Power BI dashboards. Candidates should possess strong data analytics skills, particularly in Power BI and SQL, along with the ability to collaborate effectively across teams. This role provides a competitive salary, benefits, and opportunities for professional growth.

Benefits

Competitive salary

Healthcare benefits

Employee discounts

Cycle to work scheme

Qualifications

• Training or experience in data analytics, business intelligence, or digital reporting.
• Strong proficiency with Microsoft Power BI (data modelling, DAX, Power Query).
• Familiarity with Microsoft 365 tools including Excel and SharePoint.
• Experience cleaning, structuring, and modelling data from multiple sources.

Responsibilities

• Collect, clean, organise, and validate programme data.
• Build automated data collection processes using Power Automate.
• Develop and maintain Power BI dashboards.
• Support early‑stage system integration activities.

Skills

Data analytics

Microsoft Power BI

Microsoft Power Automate

SQL

Data cleaning

Analytical skills

Communication

Tools

Excel

SharePoint

Power Query

Microsoft Lists

Job description

A leading construction firm in Basingstoke seeks a Digital & Data Analyst to enhance automated reporting and data integration using Microsoft Power Platform tools. Responsibilities include data collection, cleaning, and reporting, while improving workflows and developing Power BI dashboards. Candidates should possess strong data analytics skills, particularly in Power BI and SQL, along with the ability to collaborate effectively across teams. This role provides a competitive salary, benefits, and opportunities for professional growth.