BI Consultant - Data and Reporting in Edinburgh

BI Consultant - Data and Reporting in Edinburgh

Edinburgh Full-Time 35000 - 45000 £ / year (est.) No working from home possible
Vallum Associates

At a Glance

  • Tasks: Transform data into insights and create stunning Power BI dashboards for decision-making.
  • Company: Join a leading consultancy in the defence maritime sector with a focus on innovation.
  • Benefits: Competitive salary, professional development, and opportunities to work on impactful projects.
  • Other info: Fast-paced environment with opportunities for career growth and learning.
  • Why this job: Be at the forefront of data analytics and support vital maritime build programmes.
  • Qualifications: Strong Excel skills and experience with Power BI; familiarity with project scheduling is a plus.

The predicted salary is between 35000 - 45000 £ per year.

Responsibility: Sits at the heart of the team's data and analytics function, providing the technical backbone for reporting, modelling and insight delivery. Takes ownership of data wrangling and routine analytical work — cleaning, managing and manipulating data using Excel and Power Query to answer operational questions and refresh existing models. Responsible for building and maintaining Power BI dashboards relied upon by both the internal team and client for day-to-day decision making. Extracts data directly from source systems, applies appropriate statistical techniques and produces clear visualisations tailored to the target audience. Owns repeatable data tasks end-to-end, freeing senior consultants to focus on higher-value work. Documents processes and builds sustainability into outputs, ensuring refreshes are not dependent on a single individual. Operates within a programme supporting the acceleration of defence maritime build programmes — expected to get up to speed quickly with ship build strategies, terminology and scheduling environments.

Skills Required

  • Familiarity and working capability with Primavera P6 and project scheduling
  • Strong Excel skills, including the ability to produce, continue developing and QA metrics in support of the wider team
  • Experience building and maintaining dashboards and visualisations in Power BI or similar tools
  • Ability to extract and manipulate data from source systems and apply appropriate analytical techniques
  • SC clearance is required

Desirable:

  • Change management capability, with experience embedding dashboards or analytical tools within client teams
  • Prior experience in capital build or defence maritime environments; ship build experience is strongly preferred

BI Consultant - Data and Reporting in Edinburgh employer: Vallum Associates

As a BI Consultant in our dynamic team, you will thrive in a collaborative work culture that prioritises innovation and professional growth. Our commitment to employee development is reflected in tailored training opportunities and a supportive environment that encourages knowledge sharing. Located at the forefront of the defence maritime sector, we offer unique insights and experiences that empower you to make a meaningful impact while enjoying a balanced work-life integration.

Vallum Associates

Contact Details:

Vallum Associates Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land BI Consultant - Data and Reporting in Edinburgh

Tip Number 1

Network like a pro! Reach out to people in the industry, especially those who work in BI or defence maritime. A friendly chat can lead to insider info about job openings and even referrals.

Tip Number 2

Show off your skills! Create a portfolio showcasing your Power BI dashboards and Excel projects. 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 your technical knowledge. Be ready to discuss how you've tackled data wrangling and reporting challenges in the past. Confidence in your abilities will shine through!

Tip Number 4

Don't forget to apply through our website! We love seeing applications directly from candidates who are eager to join us. Plus, it shows you're genuinely interested in being part of the StudySmarter team.

We think you need these skills to ace BI Consultant - Data and Reporting in Edinburgh

Data Wrangling
Excel
Power Query
Power BI
Data Extraction
Statistical Techniques
Data Visualisation

Some tips for your application 🫡

Tailor Your CV:Make sure your CV speaks directly to the BI Consultant role. Highlight your experience with Excel, Power BI, and any relevant data wrangling skills. We want to see how you can bring value to our team!

Showcase Your Projects:Include specific examples of dashboards or reports you've built in the past. If you've worked with data in a maritime or defence context, let us know! This will help us see your practical experience.

Be Clear and Concise:When writing your cover letter, get straight to the point. Explain why you're interested in the role and how your skills align with our needs. We appreciate clarity and directness!

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 Vallum Associates

Know Your Tools Inside Out

Make sure you’re well-versed in Excel, Power Query, and Power BI. Brush up on your skills and be ready to discuss specific examples of how you've used these tools to clean, manage, and visualise data. Being able to demonstrate your technical prowess will impress the interviewers.

Understand the Industry

Familiarise yourself with defence maritime build programmes and the terminology associated with them. Research recent developments in the industry so you can speak confidently about how your skills can contribute to their projects. This shows you're not just a tech whiz but also understand the context of your work.

Prepare for Scenario Questions

Expect questions that ask you to solve hypothetical problems or describe past experiences. Think of scenarios where you’ve had to wrangle data or create dashboards under tight deadlines. Use the STAR method (Situation, Task, Action, Result) to structure your answers clearly and effectively.

Showcase Your Documentation Skills

Since the role involves building sustainability into outputs, be prepared to discuss how you document processes. Share examples of how you’ve ensured that your work is easily understandable and repeatable by others. This will highlight your attention to detail and commitment to team success.