At a Glance
- Tasks: Design and maintain dashboards, optimise data models, and support marketing teams.
- Company: Join IntellectoKids, a leading developer of educational apps for 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 analytics.
- Qualifications: 2+ years as a BI Analyst, strong SQL skills, and dashboard experience.
- 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: careers@intellectokids.com
167 City Road, London, Greater London, United Kingdom, EC1V 1AW
BI Analyst employer: IntellectoKids
Contact Detail:
IntellectoKids Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land BI Analyst
✨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. Use platforms like Tableau or Power BI to demonstrate your expertise. This will give potential employers a taste of what you can do.
✨Tip Number 3
Prepare for interviews by brushing up on SQL and data modelling principles. Be ready to discuss your experience with ETL processes and how you've ensured data quality in past roles. Practice makes perfect!
✨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
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the BI Analyst role. Highlight your SQL skills and experience with dashboards in tools like Tableau. 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 excited about 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
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss complex queries, optimisations, and window functions. Practising some real-world scenarios can help you demonstrate your expertise effectively.
✨Showcase Your Dashboard Skills
Since the role involves building dashboards, be ready to talk about your experience with tools like Tableau or Power BI. Bring examples of dashboards you've created, and explain the thought process behind their design and how they helped in decision-making.
✨Understand Data Models and ETL Processes
Familiarise yourself with data warehouse architecture and data modelling principles. Be prepared to discuss your hands-on experience with ETL processes, as this will show that you can maintain data quality and consistency across reports.
✨Be Ready for Analytical Challenges
Expect to tackle some analytical problems during the interview. Brush up on key product and marketing metrics, and think about how you would approach ad-hoc reporting. This will demonstrate your analytical support capabilities to the marketing and product teams.