Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Create impactful dashboards and write advanced SQL to drive data-driven decisions.
- Company: Dynamic e-commerce client in London with a hybrid work model.
- Benefits: Competitive salary up to £48k, flexible working, and collaborative culture.
- Why this job: Bring data to life and make a real impact across various teams.
- Qualifications: 2+ years in an analytical role, strong dashboarding skills, and advanced SQL knowledge.
- Other info: Opportunity to work in a fast-paced environment with growth potential.
The predicted salary is between 36000 - 48000 £ per year.
Overview
This range is provided by Ruby Magpie. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.
Base pay range
BI Analyst – London (Hybrid)
3 days/week in-office for the first 5–6 months, then typically 1–2 days/week
Our ecommerce clients is looking for a BI Analyst who can bring data to life and build trusted relationships across the business. You’ll design clear, impactful dashboards, write advanced SQL to power them, and work directly with teams in marketing, e-commerce, operations and supply to make data central to decision-making.
What you’ll do
- Create and maintain dashboards and data visualisations that drive action (Looker Studio preferred; Power BI/Tableau experience also valued).
- Partner with stakeholders across functions — understanding their processes, shaping requirements, and iterating dashboards that really get used.
- Run deep-dive analysis projects and support ad-hoc data needs while helping reduce them through better self-serve tools.
- Contribute to a culture of consistent KPI definitions, strong governance and clear documentation.
What you’ll bring
- 2+ years’ experience in an analytical or BI role.
- Strong portfolio of dashboarding/data visualisation work.
- Advanced SQL capability (beyond simple selects).
- Confidence working directly with non-technical teams and building trust.
- Bonus: travel/e-commerce sector background
Salary: up to £48k.
Seniority level
- Mid-Senior level
Employment type
- Full-time
Job function
- Analyst, Research, and Distribution
- Industries: Travel Arrangements, Retail Luxury Goods and Jewelry, and Retail
Referrals increase your chances of interviewing at Ruby Magpie by 2x
#J-18808-Ljbffr
Business Intelligence Analyst employer: Ruby Magpie
Contact Detail:
Ruby Magpie Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Intelligence Analyst
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. Building relationships can open doors that a CV just can't.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your dashboarding and data visualisation projects. This is your chance to demonstrate how you bring data to life and make it central to decision-making.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL skills. Be ready to discuss complex queries and how you've used them in past roles. We want to see your analytical thinking in action!
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who take the initiative to engage directly with us.
We think you need these skills to ace Business Intelligence Analyst
Some tips for your application 🫡
Show Off Your Dashboard Skills: Make sure to highlight your experience with dashboarding and data visualisation in your application. We want to see how you've created impactful dashboards that drive action, so include examples from your portfolio!
SQL is Key: Since advanced SQL is a must-have for this role, don’t shy away from showcasing your SQL prowess. Include specific examples of complex queries you've written and how they contributed to robust reporting.
Connect with Stakeholders: We value collaboration, so mention any experiences where you’ve partnered with non-technical teams. Show us how you’ve built trust and shaped requirements to create dashboards that really get used.
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!
How to prepare for a job interview at Ruby Magpie
✨Know Your Dashboards
Before the interview, make sure you’re familiar with the types of dashboards and data visualisations that are relevant to the role. Bring examples from your portfolio that showcase your ability to create impactful dashboards, especially using Looker Studio, Power BI, or Tableau.
✨SQL Skills on Display
Brush up on your SQL skills! Be prepared to discuss complex queries you've written in the past. You might even be asked to solve a problem on the spot, so practice writing joins, subqueries, and nested logic to demonstrate your advanced capabilities.
✨Understand Stakeholder Needs
Research the company’s different functions and think about how you can partner with them. Be ready to share examples of how you’ve previously shaped requirements and iterated on dashboards based on stakeholder feedback. This shows you can build trust and understand their processes.
✨Culture Fit and Governance
Familiarise yourself with the importance of KPI definitions and data governance. Be prepared to discuss how you’ve contributed to a culture of clear documentation and consistent metrics in your previous roles. This will highlight your commitment to quality and collaboration.
