Reporting Analyst - Defence

Turner & Townsend; East Midlands; On-site; GBP 65,000 - 95,000; Full time

Job summary

Turner & Townsend is seeking an experienced data analytics and BI specialist to join our specialist project controls function in the UK. You will drive dashboard development, data mapping and analytics across capital projects, supporting data-driven decision making with Power BI and advanced data integration skills.

You will work on diverse projects, extract insights from large datasets, and shape database solutions while collaborating with cross-functional teams in a fast-paced environment.

Qualifications

• Experience leading reporting and analytics in capital projects or programmes.
• Experience delivering business reporting solutions using analytics tools.
• Experience with structured and unstructured data sets.
• Ability to extract and link data using SQL.
• Advanced Excel formulas with VBA for reporting automation.
• Power BI setup and analytics expertise.
• Excellent communication and presentation skills.
• Experience leading service, process and system improvements.
• Knowledge of 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, proofs-of-concept or dashboard specifications.
• Develop dashboards in Power BI to support data-driven decisions.
• 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

Analytics leadership

Reporting solutions

Structured/unstructured data

SQL data extraction

Excel VBA automation

Communication & presentation

Process & system improvement

Schedule/cost/risk/change management

Tools

Power BI

SQL

Excel/VBA

Job 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.

Due to a growing demand for our consultancy services we are seeking to recruit an experienced individualwith 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 witha 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;
• Excellent communication and presentation skills;
• Demonstrable experience in leading service, process and system improvements;
• Intermediate knowledge of schedule, cost, risk and change management processes.

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)and in order to do so will need to be:

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.

SOX control responsibilities may be part of this role, which are to be adhered to where applicable.

Join our social media conversations for more information about Turner & Townsend and our exciting future projects: