At a Glance
- Tasks: Transform complex data into clear insights and support decision-making.
- Company: Join a dynamic team in Edinburgh focused on programme delivery.
- Benefits: Competitive day rate, flexible contract, and opportunities for professional growth.
- Other info: Work in an agile setting with potential for career advancement.
- Why this job: Make an impact by driving data-driven decisions in a fast-paced environment.
- Qualifications: Strong Power BI skills and experience in data transformation required.
Location: Edinburgh
Day Rate: £400-500 (Outside IR35)
Contract Length: ASAP - End of August
Clearance Requirements: SC Clearance required (or BPSS with SC in progress). Active clearance preferred due to timelines.
Overview: We are looking for a Programme Data & Analytics Analyst to join the delivery team. This role sits at the core of a programme's data and reporting function, responsible for turning complex operational and scheduling data into clear, reliable insights that support day-to-day decision-making.
Core stack & environment:
- Power BI (dashboard development & maintenance)
- Excel (advanced analysis, modelling, QA)
- Power Query (data transformation)
- Primavera P6 (programme scheduling data)
- Multiple source systems (structured operational data)
- Agile, delivery-focused programme environment
What you'll be doing:
- Building and maintaining Power BI dashboards used by programme teams and stakeholders
- Extracting, cleaning, and transforming data from multiple sources
- Managing repeatable data workflows and reporting cycles
- Supporting operational teams with data-driven insights
- Applying analytical techniques to support programme performance tracking
- Documenting processes to ensure sustainability and scalability
- Contributing to a wider programme focused on accelerating delivery timelines
Essential Criteria:
- Strong experience with Power BI dashboard development
- Advanced Excel skills, including data manipulation and QA of metrics
- Experience extracting and transforming data from source systems
- Ability to translate complex data into clear, actionable insights
- Experience working in delivery-focused or programme environments
- Eligible for UK security clearance (SC)
Desirable Experience:
- Experience with Primavera P6 or project scheduling environments
- Background in defence, infrastructure, or capital delivery programmes
- Familiarity with Power Query or similar ETL tools
- Experience embedding reporting within operational teams
- Exposure to programme controls or PMO environments
Programme Data & Analytics Analyst in Edinburgh employer: Keystream Group Limited
Join a dynamic and innovative team in Edinburgh as a Programme Data & Analytics Analyst, where your expertise will directly influence decision-making and programme success. We pride ourselves on fostering a collaborative work culture that values continuous learning and professional growth, offering competitive day rates and the opportunity to work on impactful projects within a supportive environment. With a focus on data-driven insights and agile methodologies, you'll find a rewarding career path that not only challenges you but also allows you to contribute meaningfully to our mission.
StudySmarter Expert Advice🤫
We think this is how you could land Programme Data & Analytics Analyst in Edinburgh
✨Tip Number 1
Network like a pro! Reach out to folks in your industry on LinkedIn or at local meetups. We all know that sometimes it’s not just what you know, but who you know that can help you land that Programme Data & Analytics Analyst role.
✨Tip Number 2
Prepare for those interviews by practising common questions related to data analytics and Power BI. We suggest doing mock interviews with friends or using online platforms to get comfortable talking about your skills and experiences.
✨Tip Number 3
Showcase your work! If you’ve built any dashboards or done significant data analysis, create a portfolio. We love seeing real examples of your skills in action, and it can really set you apart from other candidates.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we’re always on the lookout for passionate candidates ready to dive into the world of data and analytics.
We think you need these skills to ace Programme Data & Analytics Analyst in Edinburgh
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with Power BI and advanced Excel skills. We want to see how you've turned complex data into actionable insights, so don’t hold back on those examples!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for the Programme Data & Analytics Analyst role. Mention your familiarity with Agile environments and any relevant project scheduling tools like Primavera P6.
Showcase Your Analytical Skills:In your application, emphasise your ability to extract, clean, and transform data from multiple sources. We love candidates who can manage repeatable data workflows and provide data-driven insights, so make sure to highlight these experiences!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for this exciting opportunity. Don’t miss out!
How to prepare for a job interview at Keystream Group Limited
✨Know Your Tools Inside Out
Make sure you’re well-versed in Power BI, Excel, and Power Query. Brush up on your dashboard development skills and be ready to discuss how you've used these tools to turn complex data into actionable insights. Prepare examples that showcase your analytical techniques and how they’ve supported programme performance.
✨Understand the Programme Environment
Familiarise yourself with the delivery-focused programme environment mentioned in the job description. Be prepared to discuss your experience in similar settings and how you’ve contributed to accelerating delivery timelines. This will show that you can hit the ground running.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve real-world problems using data. Think about past experiences where you extracted, cleaned, and transformed data from multiple sources. Practise explaining your thought process clearly, as this will demonstrate your ability to translate complex data into clear insights.
✨Showcase Your Communication Skills
As a Programme Data & Analytics Analyst, you'll need to communicate findings effectively. Prepare to discuss how you've documented processes and shared insights with operational teams. Highlight any experience you have embedding reporting within teams, as this will illustrate your collaborative approach.
