At a Glance
- Tasks: Create impactful dashboards and visualisations that drive business decisions.
- Company: Join Ruby Magpie, a dynamic e-commerce company with a collaborative culture.
- Benefits: Competitive salary up to £48k, hybrid work model, and opportunities for professional growth.
- Other info: Exciting opportunity in the travel and e-commerce sectors with excellent career prospects.
- Why this job: Bring data to life and make a real impact across various teams.
- Qualifications: 2+ years in an analytical role with strong SQL and dashboarding skills.
The predicted salary is between 28800 - 48000 £ per year.
Overview
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 client 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
Business Intelligence Analyst in England employer: Ruby Magpie
At Ruby Magpie, we pride ourselves on fostering a collaborative and innovative work culture that empowers our employees to thrive. As a Business Intelligence Analyst in London, you'll enjoy the flexibility of a hybrid working model, competitive salary, and opportunities for professional growth while contributing to impactful projects that drive data-driven decision-making across our e-commerce clients. Join us to be part of a dynamic team where your insights will shape the future of our business and enhance your career in a vibrant city.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Analyst in England
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those already working as BI Analysts. Use platforms like LinkedIn to connect and engage with them; you never know who might have a lead on your dream job!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best dashboards and data visualisations. When you get the chance to chat with potential employers, share your work and explain how it drove action in previous roles.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL skills. Be ready to discuss specific projects where you used advanced SQL to solve problems or improve processes. This will show you're not just a number cruncher but a strategic thinker!
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that might be perfect for you. Plus, applying directly can sometimes give you an edge over other candidates.
We think you need these skills to ace Business Intelligence Analyst in England
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience in BI and data visualisation. Use keywords from the job description to show we’re on the same page and that you’ve got what it takes!
Showcase Your Projects:Include a portfolio of your dashboarding work. We want to see how you bring data to life, so share examples that demonstrate your skills in SQL and visualisation tools like Looker Studio or Power BI.
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Tell us why you’re passionate about BI and how you can contribute to our team. Make it personal and connect your experience with our needs.
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 don’t miss out on any important updates from us!
How to prepare for a job interview at Ruby Magpie
✨Know Your Dashboards
Before the interview, brush up on your dashboarding skills. Be ready to discuss your previous work with Looker Studio, Power BI, or Tableau. Prepare examples of how your dashboards have driven action in past roles.
✨Master SQL Queries
Since advanced SQL is a must-have for this role, practice writing complex queries. Be prepared to explain your thought process and how you've used SQL to solve real business problems in your previous positions.
✨Understand Stakeholder Needs
Think about how you’ve partnered with non-technical teams in the past. Be ready to share specific examples of how you’ve shaped requirements and iterated on dashboards based on feedback. This shows your ability to build trust and communicate effectively.
✨Showcase Your Analytical Projects
Prepare to discuss any deep-dive analysis projects you've led. Highlight how these projects contributed to better decision-making and reduced ad-hoc data needs through self-serve tools. This will demonstrate your analytical prowess and strategic thinking.
