> Markdown version of [/jobs/ext/4642378-data-analyst](https://www.wearedevelopers.com/jobs/ext/4642378-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Analyst

- **Company:** Balfour Beatty VINCI
- **Location:** Birmingham, United Kingdom
- **Contract:** Permanent contract
- **Skills:** Microsoft Access, Microsoft Excel, Business Systems, Data Validation, Data Transformation, Data Security, Excel Formulas, Information Management, Pivot Tables, Power BI, Powerquery
- **Published:** November 9, 2026
- **Apply:** https://www.naturalhr.net/hr/recruitment/application/bffb630b4dfdddff135277c72b73ad27/55705

## About the Role

* Proven experience developing and maintaining Power BI reports and interactive dashboards for operational, project or programme reporting.

 * Strong working knowledge of Power Query (M) and DAX, including data transformation, measures, KPIs, variance and time-based analysis.

 * Experience designing dependable star-schema data models, relationships, date tables and reusable semantic models.

 * Experience implementing data validation, reconciliation and quality-control checks, and investigating anomalies and root causes.

 * Experience translating stakeholder requirements into clear reporting specifications and actionable insights.

 * Strong Microsoft Excel skills, including pivot tables, complex formulas and reconciliation, with an understanding of data security and row-level security.

 * Strong communication, organisation and problem-solving skills, with the ability to work independently and collaboratively.

Applicants must have the right to work in the UK to be considered.

## Description

Based at Fort Dunlop - this location sits on the eastern edge of Birmingham, adjacent to the M6 motorway, providing excellent transport links into the city and across the region. Fort Dunlop serves as a key hub within IPT Area North, supporting operations that span multiple sublots and regional activities. Its strategic position makes it an important point for coordination and access, with proximity to major infrastructure routes ensuring connectivity to both the Central Region and wider project areas.

Role description:

 * Develop, maintain and improve Power BI dashboards and reports to support project and programme performance management.

 * Connect, combine, clean and transform data from relevant project and business systems using Power Query and other appropriate tools.

 * Build and maintain dependable data models, measures and reporting logic, ensuring calculations and definitions are consistent.

 * Produce scheduled and ad hoc analysis for project teams, governance forums and senior managers.

 * Analyse schedule, cost, progress, risk, change, quality and other performance information to identify trends, variances, anomalies and potential root causes.

 * Reconcile reported information with source systems, investigate discrepancies and work with data owners to resolve data-quality issues.

 * Translate stakeholder requirements into clear reporting specifications, dashboards and actionable insights.

 * Explain findings and recommendations clearly to technical and non-technical audiences.

 * Maintain documentation for data sources, metric definitions, reporting processes and assumptions.

 * Follow organisational requirements for data security, access, information management and applicable legislation.

 * Identify opportunities to improve reporting processes, data quality and the effective use of data across the programme., We're open to discussing flexible working arrangements to suit your needs, aligned with project requirements.