Data Analyst Intern

**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.

**Life at Lingokids**:
**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.