Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and maintain dashboards, optimise data models, and support marketing teams with analytics.
- Company: Join IntellectoKids, a leading developer of educational apps for young children.
- Benefits: Remote work, paid sick leave, vacation, and a chance to impact EdTech.
- Why this job: Be part of a top team and shape the future of educational technology.
- Qualifications: 2+ years as a BI Analyst, strong SQL skills, and experience with BI tools.
- Other info: Dynamic role with opportunities for growth in a thriving industry.
The predicted salary is between 36000 - 60000 £ per year.
IntellectoKids is one of the world's largest developers of educational apps for children from 3 to 7 years old. The company's apps are in the Top 15 in the Kids 5 & Under category in the App Store in 40 countries, including the United States.
We are seeking a Middle+ Product Analyst.
Responsibilities:
- Design, build, and maintain dashboards and reports for iOS, Android, and Web platforms
- Develop and optimize data models for data visualization
- Create and maintain ETL processes
- Establish unified methodology for key metrics calculation
- Ensure data quality and consistency across reports
- Provide analytical support to marketing and product teams: ad-hoc reports and regular reporting
Requirements:
- 2+ years of experience as a BI Analyst or in a similar role
- Strong SQL skills (complex queries, optimization, window functions)
- Hands-on experience building dashboards in Tableau or similar BI tools (Power BI, Looker, Metabase)
- Understanding of data warehouse architecture and data modeling principles
- Experience with ETL processes
- Solid understanding of key product and marketing metrics
Nice to have:
- Experience with Redshift (PostgreSQL), Tableau, Airflow stack
- Python proficiency for automation and data processing
- Experience with Adjust/AppsFlyer or similar MMPs
- Understanding of event-based analytics and cohort analysis
What we offer:
- Wide range of tasks in business intelligence and data visualization
- Opportunity to join a top team in the mobile EdTech segment
- Impact on the company's analytical infrastructure development
- Remote work, paid sick leave, and vacation
Contacts: 167 City Road, London, Greater London, United Kingdom, EC1V 1AW
BI Analyst in London employer: IntellectoKids
Contact Detail:
IntellectoKids Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land BI Analyst in London
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with fellow BI Analysts. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your dashboards and reports. This is your chance to demonstrate your SQL prowess and data visualisation skills, making you stand out from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common BI Analyst questions. Be ready to discuss your experience with ETL processes and data modelling principles. Practice makes perfect, so get a friend to do mock interviews with you!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace BI Analyst in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the BI Analyst role. Highlight your SQL skills and any experience with dashboards in Tableau or similar tools. We want to see how your background fits with what we're looking for!
Showcase Your Projects: Include specific projects where you've designed dashboards or optimised data models. This gives us a clear picture of your hands-on experience and how you can contribute to our team.
Be Clear and Concise: When writing your cover letter, keep it clear and to the point. Explain why you're interested in the role and how your skills align with our needs. We appreciate straightforward communication!
Apply Through Our Website: Don't forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. We can't wait to hear from you!
How to prepare for a job interview at IntellectoKids
✨Know Your SQL Inside Out
Since strong SQL skills are a must for this BI Analyst role, make sure you brush up on complex queries, optimisation techniques, and window functions. Practise writing queries that could be relevant to the company's data needs, as this will show your technical prowess during the interview.
✨Showcase Your Dashboard Skills
Be prepared to discuss your hands-on experience with BI tools like Tableau or Power BI. Bring examples of dashboards you've built in the past, and if possible, demonstrate how you approached data visualisation challenges. This will highlight your practical experience and creativity.
✨Understand the Business Context
Familiarise yourself with IntellectoKids and their educational apps. Understand their target audience and key metrics that matter in the EdTech space. This knowledge will help you tailor your answers and show that you're genuinely interested in contributing to their mission.
✨Prepare for Analytical Scenarios
Expect to tackle some analytical scenarios or case studies during the interview. Practise explaining your thought process when it comes to data quality, ETL processes, and metric calculations. This will demonstrate your analytical thinking and problem-solving skills, which are crucial for the role.
