Data Analyst / Reporting Analyst - SC Cleared, EdinburghEdinburgh

We are seeking a Data / Reporting Analyst with experience in Planning & Scheduling to support a major defence maritime build programme. This role sits at the centre of the programme's data and analytics capability, providing the reporting, modelling and insight required to support operational decision-making.

The successful candidate will take ownership of repeatable analytical tasks, data wrangling, dashboard development and reporting outputs. You will work with source-system data, manipulate and clean datasets, maintain existing models and develop Power BI dashboards that are relied upon by both programme teams and client stakeholders.

This is a delivery-focused role requiring someone who can get up to speed quickly with complex build environments, including ship build strategies, scheduling terminology and operational reporting requirements.

• Provide technical support across the programme's data, reporting and analytics function.
• Clean, manage and manipulate data using Excel, Power Query and related tools.
• Take ownership of routine analytical tasks, reporting cycles and model refreshes.
• Build, maintain and improve Power BI dashboards for internal and client stakeholders.
• Extract data directly from source systems and prepare it for analysis and reporting.
• Apply appropriate analytical and statistical techniques to answer operational questions.
• Produce clear, audience-appropriate visualisations to support decision-making.
• QA metrics, dashboards and reporting outputs to ensure accuracy and consistency.
• Document repeatable processes so outputs can be refreshed sustainably.
• Support senior consultants by taking ownership of repeatable data tasks end-to-end.
• Develop an understanding of ship build schedules, terminology and programme planning environments.

• Strong Excel capability, including data cleaning, modelling, metrics development and QA.
• Hands-on experience with Power Query.
• Experience building, maintaining and improving dashboards in Power BI or similar tools.
• Ability to extract, manipulate and analyse data from source systems.
• Familiarity with project scheduling environments and reporting requirements.
• Working knowledge of Primavera P6 and project scheduling.
• Strong attention to detail and ability to produce reliable, repeatable reporting outputs.
• Ability to turn complex datasets into clear insights and visualisations.
• Comfortable working independently in a fast-paced programme environment.
• Strong written documentation skills, particularly around process capture and sustainability.