Data Analyst / Reporting Analyst - SC Cleared. Job in Edinburgh LilyLifestyle Jobs

Data Analyst / Reporting Analyst - SC Cleared. Job in Edinburgh LilyLifestyle Jobs

Full-Time 40000 - 50000 £ / year (est.) No working from home possible
United Cerebral Palsy of Georgia

At a Glance

  • Tasks: Analyse and report data to support a major defence maritime programme.
  • Company: Join a leading defence organisation in Edinburgh with a focus on innovation.
  • Benefits: Competitive pay, flexible working options, and opportunities for professional growth.
  • Other info: Fast-paced environment with a chance to work on exciting maritime projects.
  • Why this job: Make a real impact by providing insights that drive operational decisions.
  • Qualifications: Strong Excel skills, experience with Power BI, and a knack for data analysis.

The predicted salary is between 40000 - 50000 £ per year.

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.

Key Responsibilities
  • 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.
Essential Skills & Experience
  • 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.

Data Analyst / Reporting Analyst - SC Cleared. Job in Edinburgh LilyLifestyle Jobs employer: United Cerebral Palsy of Georgia

As a leading employer in the defence sector, we offer a dynamic work environment in Edinburgh that fosters innovation and collaboration. Our commitment to employee growth is evident through continuous training opportunities and a culture that values initiative and accountability. Join us to be part of a mission-driven team where your analytical skills will directly contribute to impactful maritime projects.

United Cerebral Palsy of Georgia

Contact Details:

United Cerebral Palsy of Georgia Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Data Analyst / Reporting Analyst - SC Cleared. Job in Edinburgh LilyLifestyle Jobs

Tip Number 1

Network like a pro! Reach out to people in the industry, attend meetups, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.

Tip Number 2

Prepare for interviews by practising common questions and showcasing your analytical skills. Use examples from your past experiences to demonstrate how you've tackled data challenges and delivered insights.

Tip Number 3

Don’t just apply anywhere; focus on companies that excite you! Tailor your applications to highlight how your skills in Excel, Power BI, and data manipulation align with their needs. We recommend applying through our website for a smoother process.

Tip Number 4

Follow up after interviews! A quick thank-you email can set you apart and show your enthusiasm for the role. Plus, it keeps you on their radar as they make their decision.

We think you need these skills to ace Data Analyst / Reporting Analyst - SC Cleared. Job in Edinburgh LilyLifestyle Jobs

Data Analysis
Reporting Skills
Excel
Power Query
Power BI
Data Manipulation
Dashboard Development

Some tips for your application 🫡

Tailor Your CV:Make sure your CV speaks directly to the skills and experiences mentioned in the job description. Highlight your Excel and Power BI expertise, as well as any relevant experience with data manipulation and reporting.

Craft a Compelling Cover Letter:Use your cover letter to tell us why you're the perfect fit for this role. Share specific examples of how you've tackled similar challenges in the past, especially in data analysis and reporting.

Showcase Your Technical Skills:Don’t just list your skills; demonstrate them! If you’ve built dashboards or cleaned datasets, mention these projects and the impact they had. We love seeing real-world applications of your abilities.

Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any important updates!

How to prepare for a job interview at United Cerebral Palsy of Georgia

Know Your Tools Inside Out

Make sure you're well-versed in Excel, Power Query, and Power BI. Brush up on your data cleaning and dashboard development skills, as you'll likely be asked to demonstrate your proficiency with these tools during the interview.

Understand the Defence Sector

Familiarise yourself with ship build strategies and project scheduling terminology. This knowledge will not only help you answer questions more confidently but also show that you're genuinely interested in the role and its context.

Prepare for Scenario-Based Questions

Expect to face questions that assess your problem-solving abilities. Think of examples where you've successfully managed data tasks or improved reporting outputs, and be ready to discuss the analytical techniques you used.

Showcase Your Attention to Detail

Since accuracy is crucial in this role, be prepared to discuss how you ensure the quality of your work. Bring examples of how you've documented processes or QA'd metrics in the past to illustrate your commitment to producing reliable outputs.