Reporting Analyst - Defence

Turner Townsend; Litchurch; On-site; GBP 45,000 - 65,000; Full time

Job summary

Turner & Townsend in Derby seeks an experienced data analytics professional to join our specialist project controls team. You will drive dashboard development, data mapping, and data warehouse initiatives across diverse projects, using Power BI to enable data-driven decisions.

The role requires strong SQL, Excel/VBA, and stakeholder engagement skills, with a track record of delivering reporting solutions in capital projects.

Qualifications

• Track record of leading reporting and analytics in capital projects.
• Experience delivering business reporting solutions with analytics tools.
• Experience with structured and unstructured data sets.
• Ability to extract and link data using SQL.
• Advanced Excel formulas and VBA for reporting automation.
• Advanced knowledge of BI setup, preferably Power BI.
• Strong customer focus, engagement and stakeholder management.
• Experience in schedule, cost, risk and change management processes.

Responsibilities

• Understand client's data and systems.
• Map end-to-end data processes and data flows.
• Develop wireframes, proof-of-concepts or specifications of dashboards.
• Develop dashboards Power BI to support data-driven decision making.
• Evaluate, design, implement and manage database solutions.
• Extract and integrate large datasets from multiple sources.
• Setup and maintain automated reporting processes.
• Provide technical expertise in delivering business requirements.

Skills

Reporting leadership

SQL

Power BI

Excel

VBA

Stakeholder management

Data mapping

Tools

SQL Server

Excel VBA

Power BI

Data warehouse

Job description

Date: 2026-09-18

Location: Derby, Derbyshire, GB, DE1 3

Application Deadline: 2026-12-20

Last Updated: 2026-12-20T11:03:33.583

Company Description

The world is changing, and we have a responsibility to support that change, helping drive it and be part of it. Through the commitment, capability and care our team brings, we build trust between clients, suppliers, governments, and society. Delivering better outcomes that have a positive impact on the world around us. We work smarter to face the challenges of the future; bringing the clarity that helps teams realise their full potential across the real estate, infrastructure, and natural resources sectors. It's how we've made the difference for 75 years. Transforming performance for a green, inclusive and productive world.

Job Description

Due to a growing demand for our consultancy services, we are seeking to recruit an experienced individual with experience of dashboard development, business analysis, process & data mapping, data analysis, Power BI and data warehouse skillsets to join our specialist project controls function. The role involves supporting a wide range of projects of all sizes and dimensions, and we are seeking an individual with a strong track record of delivery data and analytics projects.

Key Responsibilities

• Understand client's data and systems
• Map out end-to-end data processes and data flows
• Develop wireframes, proof-of-concepts or specifications of dashboards
• Develop dashboards Power BI to support data-driven decision making
• Evaluate, design, implement and manage database solutions
• Extract and integrate large datasets from multiple sources
• Setup and maintain automated reporting processes
• Provide technical expertise in delivering business requirements

Qualifications

• A track record of leading reporting and analytics functions in capital projects and programmes
• Experience of managing, designing and delivering business reporting solutions using different analytical tools to provide actionable insight for the business
• Experience of working with structured and unstructured data sets
• Ability to extract and link data using SQL (Structured Query Language)
• Advanced use of excel formulas and reporting automation using VBA (Visual Basic for Applications)
• Advanced knowledge of BI Tool set-up (analytics), preferably Power BI
• Exceptional customer focus, engagement, and stakeholder management skills
• Excellent communication and presentation skills
• Demonstrable experience in leading service, process and system improvements
• Intermediate knowledge of schedule, cost, risk and change management processes

Security Clearance Requirements

Owing to the sensitive nature of the works involved in these specialist defence projects, candidates will be required to hold, or be able to hold, valid security clearance (SC). To do so, candidates must:

• Be British Nationals
• Hold a UK Passport

Additional Information

Our inspired people share our vision and mission. We provide a great place to work, where each person has the opportunity and voice to affect change. We want our people to succeed both in work and life. To support this, we promote a healthy, productive and flexible working environment that respects work-life balance.

Turner & Townsend is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees and actively encourage applications from all sectors of the community.

Job Details

• Type: Full-time
• Function: Engineering
• Experience level: Mid-Senior Level
• Industry: Construction