Data Analyst

Peoplebank
Basingstoke
22 hours ago
Create job alert

We do what we say…
And we're keen to hear from people like you who make it their business to get things done!


The purpose of this role is to enable integrated, automated, and consistent programme reporting through the effective use of Microsoft Power Platform tools and structured data practices. The Digital & Data Analyst is responsible for consolidating and modelling data from multiple sources-including trackers, Microsoft Lists, and existing systems such as Sypro, P6, IFS, ACC and GIS-to support PMO governance and programme performance reporting.


The role focuses on improving data quality, creating automated workflows, and developing Power BI dashboards that reduce manual effort and provide accurate insights. Working closely with PMO functions and delivery teams, the Digital & Data Analyst helps embed digital processes, improve data literacy, and prepare the programme for future system integration and advanced data engineering.


Working alongside team colleagues and other Clancy departments or functions, your role will contribute to the following activities:
Data Collection & Quality

  • Collect, clean, organise, and validate programme data from trackers, Microsoft Lists, and existing systems (Sypro, P6, IFS, ACC, GIS).
  • Apply data quality rules and checks to ensure accuracy, consistency, and completeness.
  • Identify data gaps, duplication, and inconsistencies, working with functional teams to correct and prevent issues.
  • Develop and maintain data models and reporting datasets using Power BI, Power Query, SQL, and structured schema principles.
  • Consolidate information from multiple sources into integrated datasets to support PMO governance, project controls, and decision‑making.
  • Maintain reporting logic, relationships, and definitions aligned with PMO standards.

Automation & Integration Support

  • Build automated data collection processes and workflow solutions using Power Automate and API‑based data extracts.
  • Streamline reporting processes by reducing manual data manipulation and introducing scheduled refreshes and automations.
  • Support early‑stage system integration activities by preparing data structures, understanding backend exports, and aligning reporting needs across Sypro, P6, IFS, ACC, and GIS.
  • Develop and maintain Power BI dashboards aligned with PMO reporting cycles and project controls requirements.
  • Improve clarity, usability, and performance of dashboards based on user feedback.

Tracker & List Management

  • Help standardise PMO trackers, including version control and data input rules.
  • Introduce and maintain Microsoft Lists for structured data capture where appropriate, as well as integrate other data entries from different source systems.
  • Work with PMO, Planning, Project Controls, Commercial, Risk, and Delivery Teams to align data and reporting.
  • Provide technical support for data‑related queries, business logic, and integration considerations.

Governance & Continuous Improvement

  • Ensure reporting outputs follow PMO governance standards and definitions.
  • Contribute to improving data processes, digital tools, and reporting practices across the programme.

We'd love to hear from you, if you can demonstrate...

  • 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, SharePoint, and Power Automate.
  • Experience developing Power BI dashboards and automated reporting solutions.
  • Experience cleaning, structuring, and modelling data from multiple sources.
  • Experience using Power Query, SQL, and basic automation flows (Power Automate).
  • Experience working with structured trackers, Lists, or similar data capture tools.
  • Experience collaborating with cross‑functional teams in a fast‑paced environment.
  • Strong knowledge of Power BI: data modelling, relationships, DAX, Power Query.
  • Ability to work with SQL for data extraction, joins, and transformations.
  • Understanding of data quality, validation, and version‑control principles.
  • Ability to standardise and govern trackers and Lists for consistent data capture.
  • Good understanding of workflow automation using Power Automate.
  • Strong analytical and problem‑solving skills.
  • Clear communication skills, especially with non‑technical stakeholders.

Our Company

Every day we work smarter, greener and use our imaginations.


Our purpose at Clancy is simple - we make life better for everyone’s growing families. We play a vital role in providing fresh drinking water and power and so much more.


We are one of the biggest family owned construction businesses in the UK and we care about our people, our clients and the environment.


What Next

You apply, and we respond within two weeks (we know how annoying it is not to hear anything back)! If you don’t receive feedback within that timescale, please don’t be afraid to chase us - one of our values is to do what we say we will do!


In addition to helping you reach your career goals, a competitive salary, pension, healthcare and holiday allowance starting at 24-26 days per annum, we also offer perks including Clancy Xtras, our employee benefits programme with discounts for numerous well‑known retailers such as Tesco, Sainsbury’s, Currys PC World and Vue Cinemas, cycle to work scheme as well as an Employee Assistance Programme.


Clancy is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all our employees. If you require any reasonable adjustments to be made for you to attend an interview, please do let us know and we will be happy to accommodate.


We are proud signatories of the Armed Forces Covenant and Disability Confident Committed.


#J-18808-Ljbffr

Related Jobs

View all jobs

Data Analyst

Data Analyst

Data Analyst

Data Analyst

Data Analyst

Data Analyst

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

How to Write a Data Science Job Ad That Attracts the Right People

Data science plays a critical role in how organisations across the UK make decisions, build products and gain competitive advantage. From forecasting and personalisation to risk modelling and experimentation, data scientists help translate data into insight and action. Yet many employers struggle to attract the right data science candidates. Job adverts often generate high volumes of applications, but few applicants have the mix of analytical skill, business understanding and communication ability the role actually requires. At the same time, experienced data scientists skip over adverts that feel vague, inflated or misaligned with real data science work. In most cases, the issue is not a lack of talent — it is the quality and clarity of the job advert. Data scientists are analytical, sceptical of hype and highly selective. A poorly written job ad signals unclear expectations and immature data practices. A well-written one signals credibility, focus and serious intent. This guide explains how to write a data science job ad that attracts the right people, improves applicant quality and positions your organisation as a strong data employer.

Maths for Data Science Jobs: The Only Topics You Actually Need (& How to Learn Them)

If you are applying for data science jobs in the UK, the maths can feel like a moving target. Job descriptions say “strong statistical knowledge” or “solid ML fundamentals” but they rarely tell you which topics you will actually use day to day. Here’s the truth: most UK data science roles do not require advanced pure maths. What they do require is confidence with a tight set of practical topics that come up repeatedly in modelling, experimentation, forecasting, evaluation, stakeholder comms & decision-making. This guide focuses on the only maths most data scientists keep using: Statistics for decision making (confidence intervals, hypothesis tests, power, uncertainty) Probability for real-world data (base rates, noise, sampling, Bayesian intuition) Linear algebra essentials (vectors, matrices, projections, PCA intuition) Calculus & gradients (enough to understand optimisation & backprop) Optimisation & model evaluation (loss functions, cross-validation, metrics, thresholds) You’ll also get a 6-week plan, portfolio projects & a resources section you can follow without getting pulled into unnecessary theory.

Neurodiversity in Data Science Careers: Turning Different Thinking into a Superpower

Data science is all about turning messy, real-world information into decisions, products & insights. It sits at the crossroads of maths, coding, business & communication – which means it needs people who see patterns, ask unusual questions & challenge assumptions. That makes data science a natural fit for many neurodivergent people, including those with ADHD, autism & dyslexia. If you’re neurodivergent & thinking about a data science career, you might have heard comments like “you’re too distracted for complex analysis”, “too literal for stakeholder work” or “too disorganised for large projects”. In reality, the same traits that can make traditional environments difficult often line up beautifully with data science work. This guide is written for data science job seekers in the UK. We’ll explore: What neurodiversity means in a data science context How ADHD, autism & dyslexia strengths map to common data science roles Practical workplace adjustments you can request under UK law How to talk about your neurodivergence in applications & interviews By the end, you’ll have a clearer sense of where you might thrive in data science – & how to turn “different thinking” into a real career advantage.