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.
- Other info: Opportunity to work in a fast-paced environment with growth potential.
- 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.
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
Business Intelligence Analyst employer: Ruby Magpie
Join a dynamic and rapidly growing B2B SaaS scale-up in London, where you will have the opportunity to take genuine ownership of demand generation within a collaborative marketing team. With a strong focus on account-based marketing and integrated campaigns, this role offers a unique chance for professional growth and the ability to influence the company's evolving strategy. Enjoy a supportive work culture that values fresh ideas and autonomy, all while being part of an exciting phase of growth in a thriving industry.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Analyst
✨Get to Grips with Data Visualisation Tools
If you're aiming for a full-time role in business intelligence, brush up on your skills with popular data visualisation tools like Tableau or Power BI. Showcasing projects where you've transformed raw data into clear visual insights can give you a real edge.
✨Join Local Business Intelligence Meetups
Look for local business intelligence meetups or analytics conferences in your area. These events are not just great for learning but also for networking with industry professionals who could lead you to opportunities at companies like Ruby Magpie!
✨Engage with Online BI Communities
Join online forums or communities focused on business intelligence—think LinkedIn groups, Reddit threads, or even dedicated Slack channels. Engage actively by sharing your insights and asking questions; this can help you build visibility and connect with potential employers.
✨Leverage Your University’s Career Support
If you're a recent graduate, definitely tap into your university's career services. Many have connections with companies in need of full-time BI specialists, and they can guide you on how to pitch yourself effectively—don't miss out on that!
We think you need these skills to ace Business Intelligence Analyst
Some tips for your application 🫡
Highlight Your Analytical Skills:In the business intelligence field, showcasing your analytical skills is a must. Make sure your CV includes relevant experience with data analysis tools, programming languages like SQL or Python, and any projects where you've interpreted complex data sets to drive business decisions.
Showcase Your Business Acumen:Don't just focus on data; show us how you can apply your insights to real-world business problems. Highlight projects where you made a tangible impact on company performance, and be prepared to explain your thought process in your cover letter.
Tailor Your Documents for Us:When applying for a full-time role at Ruby Magpie, tailor your CV and cover letter to reflect our organisational goals and strategies. Mention specific tools and methodologies that align with what we do—this shows you’ve done your homework and are genuinely interested in our mission!
Include Relevant Certifications:Certifications like Google Data Analytics or similar qualifications can really make you stand out in business intelligence. Include these in your application, as they demonstrate your commitment to the field and your willingness to stay current with industry standards.
How to prepare for a job interview at Ruby Magpie
✨Show off your analytical skills
In a business intelligence role, you're going to need to demonstrate your analytical prowess. Be prepared to discuss specific tools you've used, like SQL, Tableau, or Power BI. Have real-world examples ready where you’ve turned data into actionable insights – this is what makes us shine in interviews!
✨Practice your technical know-how
Expect some technical questions during the interview that dive deep into your understanding of data modelling and analytics frameworks. Brush up on your knowledge of data warehousing concepts and be ready to tackle any real case scenarios they might present. They’ll want to see how you approach problems using your BI toolkit.
✨Portfolio of Projects
Since it's a full-time role, having a strong portfolio is key! Compile case studies demonstrating your previous projects, preferably showing how your insights led to business improvements. This can help us display how you think through complex datasets and your problem-solving process, which is what employers are keen on seeing.
✨Know their business model
Get familiar with Ruby Magpie’s business model and recent data-driven decisions. Be prepared to discuss how your skills can specifically support their objectives or challenges. Understanding their landscape shows that you’re not just a data buff, but you’re also genuinely interested in how BI can impact their bottom line.
