At a Glance
- Tasks: Analyse data, create dashboards, and support decision-making in a major defence programme.
- Company: Join a leading defence organisation with a focus on innovation and teamwork.
- Benefits: Competitive pay, flexible working options, and opportunities for professional growth.
- Other info: Fast-paced environment with opportunities to learn about ship building and project management.
- Why this job: Make an impact in the defence sector while developing your analytical skills.
- Qualifications: Strong Excel and Power BI skills, with experience in data manipulation and reporting.
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.
- 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 in Edinburgh employer: SR2
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 teamwork and excellence. Join us to be part of a mission-driven team where your analytical skills will directly contribute to impactful maritime projects.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst / Reporting Analyst - SC Cleared in Edinburgh
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those already working in data analytics. A friendly chat can lead to insider info about job openings or even a referral.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI dashboards and any data projects you've worked on. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common data analysis questions and scenarios. Be ready to discuss how you've tackled complex datasets and produced clear insights in past roles.
✨Tip Number 4
Don't forget to apply through our website! We love seeing candidates who are genuinely interested in joining us. Plus, it makes tracking your application easier for both you and us.
We think you need these skills to ace Data Analyst / Reporting Analyst - SC Cleared in Edinburgh
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the role of Data Analyst. Highlight your experience with Excel, Power BI, and any relevant project scheduling tools. We want to see how your skills match what we're looking for!
Showcase Your Projects:Include specific examples of past projects where you've cleaned data, built dashboards, or provided insights. This helps us understand your hands-on experience and how you can contribute to our team.
Be Clear and Concise:When writing your cover letter, get straight to the point. Explain why you're a great fit for the role and how your background aligns with our needs. We appreciate clarity and brevity!
Apply Through Our Website:Don't forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. We can't wait to hear from you!
How to prepare for a job interview at SR2
✨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 modelling skills, as well as how to create impactful dashboards. Being able to demonstrate your technical prowess will show that you can hit the ground running.
✨Understand the Context
Familiarise yourself with ship build strategies and project scheduling terminology. This role is all about supporting operational decision-making, so showing that you understand the industry context will set you apart from other candidates.
✨Prepare for Practical Questions
Expect questions that test your analytical thinking and problem-solving skills. Be ready to discuss how you would approach data wrangling or how you’ve handled complex datasets in the past. Use specific examples to illustrate your experience.
✨Showcase Your Attention to Detail
Since accuracy is key in this role, be prepared to talk about how you ensure quality in your reporting outputs. Discuss any processes you’ve documented for sustainability and how you’ve maintained consistency in your work.
