Data Analyst Intern
Madrid, Spain
Lingokids
Lingokids is on a mission to help families raise amazing kids through Playlearning™. Want to come with us?
Lingokids are revolutionizing kids learning. We’ve already helped millions of children to become confident, conscious, resilient, lifelong learners but we’re nowhere near done.
We want every single child to reach their full potential—and we’re looking for remarkable people to drive us forward on this journey and help shape a brighter future for families everywhere.
On the next page of our neverending story is a hunt for the best Data Analyst Intern in the business. Up for the challenge?
Join the Playlearning™ revolution
At Lingokids we believe in letting learning and play collide so kids’ curiosity can lead the way. We’re so passionate about this, we even created our own word. Yes, really! Playlearning™.
We create games, animated series, podcasts, songs, videos, courses and more, all handcrafted by our dedicated team of storytellers. All of our Playlearning™ content is designed to boost academic progress, teach modern life skills and bring joy to children aged 2-8. Our free app has 100 million users and our YouTube channel has 2.5 million subscribers, teleporting millions of little learners to the Lingokids universe every single day.
We’re proud of our safe, ad-free environment that prioritizes healthy, peace-of-mind play. No gremlins grabbing personal data here, nuh uh. Best of all? Our Playlearning™ content is backed by education experts from around the world.
But wait! There’s more? We’re expanding our portfolio with licensed digital products and partnerships with brands like Amazon, Ravensburger, UNICEF, Tosta Rica, H&M, Ikea, and McDonald's.
What you’ll do
- Write and optimize SQL queries to ensure efficient data extraction and reporting.
- Assist in designing and maintaining data warehouse architecture for optimal performance.
- Collaborate with the team to support ETL processes, ensuring smooth data flow.
- Contribute to dbt projects for data modeling and pipeline management.
- Create and maintain dashboards using tools like Looker to deliver insights.
- Help model data for various business scenarios, ensuring alignment with business needs.
- Manage existing alerts for monitoring data issues and propose new ones.
- Provide support to both data engineers and data analysts, acting as a bridge between the two teams.
What you’ll bring
- Proficiency in SQL with a solid understanding of database structures and optimization.
- A good grasp of data warehouse principles and ETL processes.
- Familiarity with dbt (a plus, but not mandatory).
- Basic experience with business intelligence tools such as Looker or Tableau.
- Analytical thinking and the ability to translate business requirements into data solutions.
- Eagerness to learn and collaborate within a dynamic team environment.
English is a must. We are a multicultural team, and we are providing a service in English so, we don't care about certificates, but we expect you to be able to communicate fluently.
🏡 Hybrid work
We promote a remote-friendly culture, allowing flexible work arrangements between office and home. There are no mandatory office days, although we will ask you to come in for events or team building activities.
🙌 Feedback culture
Feedback is the breakfast of champions, and we take it seriously! We have a real-time and honest feedback culture, and a formal 360º assessment every 6 months.
Don't be a stranger
Not ticking all the boxes for this particular role? We’d still love to hear from you! We’re on the hunt for someone who’s passionate about our mission, not someone who’s perfect on paper.
Diversity, Equity, and Inclusion
Lingokids is committed to creating an equitable and inclusive environment where people from all backgrounds can thrive. We believe diversity fuels our innovation. Every day, we teach kids about the strength found in differences and this remains a value that is core to our Playlearning™ approach.
We’ll consider all applications for employment without regard to race, color, religion, gender identity or expression, sexual orientation, national origin, disability, age, or veteran status.
Tags: Architecture Business Intelligence Data warehouse dbt ETL Looker SQL Tableau
Perks/benefits: Team events
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.