Data Analyst​/Reporting Analyst - SC Cleared. LilyLifestyle

Data / Reporting Analyst – Active SC Required – Edinburgh – (Apply online only) p/d

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.