Senior Data & Power BI Analyst in London

Senior Data & Power BI Analyst in London

London Full-Time 55000 - 65000 € / year (est.) Home office (partial)
Arriva Rail London Ltd

At a Glance

  • Tasks: Design and build impactful reporting solutions using Power BI and data modelling.
  • Company: Join Arriva, a leading European transport provider with a focus on innovation.
  • Benefits: Enjoy hybrid working, competitive salary, and opportunities for professional growth.
  • Other info: Be part of a dynamic team driving continuous improvement and automation.
  • Why this job: Make a real difference by transforming data into actionable insights for decision-making.
  • Qualifications: Experience in Power BI, Excel, and data transformation is essential.

The predicted salary is between 55000 - 65000 € per year.

Arriva is a leading provider of passenger transport across Europe, employing around 34,400 people and delivering approximately 1.6 billion passenger journeys each year. Through buses, trains, coaches, trams, waterbuses, bike-sharing systems, on-demand transport solutions and a rolling stock leasing business, we proudly connect people and communities safely, reliably and sustainably across 11 countries. Our purpose is simple: to deliver these services in a better way, every day.

We are seeking a Senior Data & Power BI Analyst to join our Corporate Reporting team within Group Finance, playing a key role in how data is structured, transformed and delivered to support business performance across the organisation. This is a high-impact role focused on designing and building robust, scalable reporting solutions, with a strong emphasis on Power BI, data modelling and automation. You’ll work closely with the Business Performance team and senior stakeholders to translate data into meaningful insights that support decision-making across the Group.

This role will be on a hybrid working basis, a minimum of 3 days per week from either our London (Lacon) or Sunderland (Doxford) office, with flexibility to work from where you can best deliver for your customers while maintaining a healthy work-life balance.

Key responsibilities

  • You will take ownership of developing and improving reporting solutions across the Corporate Reporting function, including:
    • Designing and building end-to-end reporting solutions, from raw data through to published outputs
    • Developing robust and scalable data models to support enterprise-level reporting
    • Creating and maintaining high-quality Power BI dashboards, ensuring usability, performance and reliability
    • Transforming and structuring data using Excel and Power Query to support consistent reporting outputs
    • Identifying opportunities to automate and streamline processes, reducing manual intervention and operational risk
    • Supporting continuous improvement of reporting processes, embedding best practice across the function
    • Translating business needs into structured data solutions, particularly where requirements may be evolving or not fully defined
    • Working closely with stakeholders across Group Finance and the wider business to ensure reporting outputs add real value

What we are looking for

We are looking for a technically strong and curious analyst with experience building reporting solutions in a complex organisation. You will bring:

  • Advanced Excel capability, including working with complex and large data sets
  • Strong experience with Power BI, including DAX and dashboard development
  • Hands-on experience with Power Query (M) and data transformation
  • Proven ability to build end-to-end reporting solutions from data ingestion through to output
  • Strong data modelling experience, including building scalable and efficient models
  • A logical, problem-solving mindset with the ability to work effectively in ambiguous environments
  • Strong communication skills, with the ability to translate technical outputs into clear business insights
  • A proactive and adaptable approach within a fast-paced, evolving organisation

Desirable experience:

  • Experience with Power Automate, Office Scripts or similar automation tools
  • Exposure to Python or other programming languages for data or process automation
  • Experience working with financial or performance reporting (beneficial but not essential)

You’ll be someone who enjoys getting under the hood of data and systems, with a natural curiosity for how things work and how they can be improved. With a hands-on, “builder” mindset, you’ll take ownership of problems and create solutions from first principles, even where requirements are not always fully defined. You’ll thrive in a fast-paced, evolving environment, working collaboratively across teams to turn complex data into meaningful, actionable insight. With a genuine interest in continuous improvement, you’ll be motivated to shape how reporting is delivered, exploring opportunities to enhance capability through automation and emerging technologies, including AI.

This role offers the opportunity to play a key part in how data and reporting are developed across a major European organisation. You’ll work on business-critical outputs used by senior stakeholders, while influencing how data is structured, automated and evolved across the Group. If you enjoy building scalable solutions, solving complex data challenges, and making a tangible impact through insight and innovation, this is an exciting opportunity to develop your career within Arriva.

The closing date for applications is Wednesday 3 June 2026. Arriva Group reserves the right to close this vacancy early.

Senior Data & Power BI Analyst in London employer: Arriva Rail London Ltd

Arriva is an exceptional employer, offering a dynamic work environment that fosters innovation and collaboration. With a strong commitment to employee growth, we provide opportunities for continuous learning and development, particularly in the fast-evolving field of data analytics. Our hybrid working model promotes a healthy work-life balance, allowing you to thrive while contributing to meaningful projects that impact communities across Europe.

Arriva Rail London Ltd

Contact Detail:

Arriva Rail London Ltd Recruiting Team

StudySmarter Expert Advice🤫

We think this is how you could land Senior Data & Power BI Analyst in London

Tip Number 1

Network like a pro! Reach out to current employees at Arriva on LinkedIn or other platforms. Ask them about their experiences and any tips they might have for landing the Senior Data & Power BI Analyst role. Personal connections can give you insights that job descriptions just can't.

Tip Number 2

Prepare for the interview by brushing up on your Power BI skills. Create a few sample dashboards or reports that showcase your abilities. When you get the chance to chat with the hiring team, having tangible examples of your work can really set you apart from the crowd.

Tip Number 3

Don’t just focus on your technical skills; show off your problem-solving mindset too! Be ready to discuss how you've tackled complex data challenges in the past. Employers love candidates who can think on their feet and adapt to evolving requirements.

Tip Number 4

Finally, apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you're genuinely interested in joining Arriva. Don’t forget to follow up after applying; a little nudge can go a long way!

We think you need these skills to ace Senior Data & Power BI Analyst in London

Power BI
DAX
Data Modelling
Excel
Power Query
Data Transformation
Reporting Solutions Development

Some tips for your application 🫡

Tailor Your CV:Make sure your CV speaks directly to the role of Senior Data & Power BI Analyst. Highlight your experience with Power BI, data modelling, and any relevant projects that showcase your skills in building reporting solutions.

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 transformed data into actionable insights and how you’ve improved reporting processes in your previous roles.

Showcase Your Technical Skills:Don’t hold back on your technical prowess! Make sure to mention your advanced Excel capabilities, experience with DAX, and any automation tools you've used. We want to see how you can bring value to our team!

Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It’s the best way for us to receive your application and ensure it gets the attention it deserves!

How to prepare for a job interview at Arriva Rail London Ltd

Know Your Power BI Inside Out

Make sure you’re well-versed in Power BI, especially DAX and dashboard development. Prepare to discuss specific projects where you've built reporting solutions, showcasing your ability to create high-quality dashboards that are both user-friendly and reliable.

Showcase Your Data Modelling Skills

Be ready to explain your experience with data modelling and how you've built scalable models in previous roles. Bring examples of how your data structures have improved reporting processes or decision-making within an organisation.

Communicate Clearly and Effectively

Practice translating complex technical concepts into clear business insights. During the interview, focus on how you can communicate effectively with stakeholders, ensuring they understand the value of your data-driven insights.

Demonstrate Your Problem-Solving Mindset

Prepare to discuss scenarios where you've tackled ambiguous requirements or complex data challenges. Highlight your logical approach to problem-solving and how you’ve taken ownership of projects to deliver impactful results.