Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Transform data into insights using Microsoft Power Platform and improve programme reporting.
- Company: Join Clancy, a leading family-owned construction business in the UK.
- Benefits: Competitive salary, healthcare, 24-26 days holiday, and employee discounts.
- Why this job: Make a real impact by enhancing data quality and automating workflows.
- Qualifications: Experience in data analytics, Power BI, and collaboration with teams.
- Other info: Fast-paced environment with opportunities for career growth and development.
The predicted salary is between 30000 - 50000 £ per year.
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.
- Data Modelling & Reporting
- 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.
- Dashboard Development
- 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.
- Collaboration & Support
- 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 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 to millions of homes and businesses 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!
Benefits
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.
Data Analyst in Basingstoke employer: Clancy
Contact Detail:
Clancy Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst in Basingstoke
✨Tip Number 1
Get your networking game on! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data analysis projects, especially those using Power BI and SQL. This will give you an edge and demonstrate your hands-on experience to potential employers.
✨Tip Number 3
Prepare for interviews by brushing up on common data-related questions and scenarios. Practice explaining your past projects and how you tackled challenges, especially around data quality and automation. Confidence is key!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love hearing from proactive candidates who take the initiative to reach out directly.
We think you need these skills to ace Data Analyst in Basingstoke
Some tips for your application 🫡
Show Off Your Skills: Make sure to highlight your experience with Microsoft Power BI, SQL, and data modelling in your application. We want to see how you've used these tools to create automated reporting solutions or dashboards that make a difference!
Be Clear and Concise: When writing your application, keep it straightforward. Use clear language to explain your past experiences and how they relate to the role. We appreciate a well-structured application that gets straight to the point!
Tailor Your Application: Don’t just send a generic application! Tailor your CV and cover letter to reflect the specific skills and experiences mentioned in the job description. Show us why you’re the perfect fit for this Data Analyst role at Clancy.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way to ensure your application gets to us quickly and efficiently. Plus, we love seeing applications come through our own channels!
How to prepare for a job interview at Clancy
✨Know Your Tools Inside Out
Make sure you’re well-versed in Microsoft Power BI, Power Query, and Power Automate. Brush up on your DAX skills and be ready to discuss how you've used these tools in past projects. Being able to demonstrate your technical expertise will show that you're the right fit for the role.
✨Showcase Your Data Skills
Prepare examples of how you've collected, cleaned, and modelled data from various sources. Be ready to talk about specific challenges you faced and how you overcame them. This will highlight your problem-solving abilities and your understanding of data quality principles.
✨Collaboration is Key
Since this role involves working with cross-functional teams, think of instances where you’ve successfully collaborated with others. Share stories that illustrate your communication skills, especially when dealing with non-technical stakeholders. This will demonstrate your ability to bridge the gap between technical and non-technical team members.
✨Prepare for Scenario Questions
Expect questions that ask how you would handle specific situations related to data governance or reporting processes. Practice articulating your thought process and decision-making strategies. This will help you convey your analytical mindset and readiness to contribute to continuous improvement.
