Magic School logo

Magic School

Senior Data Analyst

🇺🇸 Remote - US

🕑 Full-Time

💰 TBD

💻 Data Science

🗓️ September 14th, 2025

SQL Amplitude BigQuery

Edtech.com's Summary

MagicSchool is hiring a Senior Data Analyst. The role involves analyzing user behavior and product engagement to drive growth and retention by using funnels, cohorts, and A/B testing. The analyst will create actionable dashboards, support customer-facing reporting, and manage ad-hoc requests to inform product decisions.

Highlights
  • Analyze user journeys and identify behaviors linked to long-term engagement using funnels, cohorts, and retention analyses.
  • Quantify and forecast product change impacts on activation, engagement, and retention.
  • Design and analyze A/B tests with product and engineering teams, defining key metrics and communicating results.
  • Develop decision-ready dashboards and maintain consistent metric definitions across teams.
  • Support usage metrics for school/district admins with reliability checks and clear definitions.
  • Manage intake and prioritization of ad-hoc data requests with clear acceptance criteria.
  • Expertise in product analytics platforms such as Amplitude, Mixpanel, or Heap.
  • Strong SQL skills in modern cloud warehouses like BigQuery, Redshift, or Snowflake; experience with BI tools including Metabase, Looker, Mode, or Hex.
  • Familiarity with dbt, Airflow, Prefect, or similar tools for data modeling and pipeline management.
  • 5+ years of analytics experience impacting product decisions, strong collaboration, and communication skills.

Senior Data Analyst Full Description

WHO WE ARE: MagicSchool is the premier generative AI platform for teachers. We're just over 2 years old, and more than 6 million teachers from all over the world have joined our platform. Join a top team at a fast growing company that is working towards real social impact. Make an account and try us out at our website and connect with our passionate community on our Wall of Love.

Responsibilities

  • Understand user behavior
    Map key journeys (onboarding → activation → habitual use). Quantify drop-offs and identify behaviors linked to long-term engagement using funnels, cohorts, and retention analyses.

  • Drive product growth
    Quantify and forecast the impact of product changes on activation, engagement, and retention using funnels/cohorts; provide evidence and confidence ranges to inform prioritization.

  • Measure impact of changes
    Help design and analyze A/B tests with product and engineering; define primary and guardrail metrics; share results and next steps in plain language.

  • Make analytics usable across teams
    Publish decision-ready dashboards and short write-ups that answer: what changed, why, what to do next. Keep metric definitions consistent and documented; contribute to model development so trusted data is easy to reuse.

  • Support customer-facing reporting
    Help define and maintain usage metrics for school/district admins (embedded or in-product), with reliability checks and clear definitions.

  • Run clean intake for ad-hoc requests
    Triage by impact/effort/urgency/data-readiness; set acceptance criteria and timelines; ship the smallest useful artifact first; templatize common asks.

Qualifications & Experience

  • 5+ years in analytics with examples where your work impacted product decisions.

  • Product analytics tools & methods: Experience with event-based analysis (funnels, cohorts, retention) and a product analytics platform (Amplitude/Mixpanel/Heap).

  • Data & BI: Strong SQL in a modern cloud warehouse (e.g., BigQuery/Redshift/Snowflake); comfortable building clear, decision-oriented dashboards (Metabase/Looker/Mode/Hex).

  • Model contributions: Familiar with dbt, Airflow/Prefect, or similar tools; able to navigate projects, run/debug jobs, and contribute small/medium changes (models, tests, docs)

  • Experimentation: Practical A/B testing—defining success and guardrails, interpreting results responsibly.

  • Collaboration & communication: Able to scope ambiguous asks, align on definitions, and communicate trade-offs and recommendations.

Why Join Us?

  • Work on cutting-edge AI technology that directly impacts educators and students.

  • Join a mission-driven team passionate about making education more efficient and equitable.

  • Flexibility of working from home, while fostering a unique culture built on relationships, trust, communication, and collaboration with our team - no matter where they live.

  • Unlimited time off to empower our employees to manage their work-life balance. We work hard for our teachers and users, and encourage our employees to rest and take the time they need.

  • Choice of employer-paid health insurance plans so that you can take care of yourself and your family. Dental and vision are also offered at very low premiums.

  • Every employee is offered generous stock options, vested over 4 years.

  • Plus a 401k match & monthly wellness stipend

Our Values:

  • Educators are Magic:  Educators are the most important ingredient in the educational process - they are the magic, not the AI. Trust them, empower them, and put them at the center of leading change in service of students and families.

  • Joy and Magic: Bring joy and magic into every learning experience - push the boundaries of what’s possible with AI.

  • Community:  Foster community that supports one another during a time of rapid technological change. Listen to them and serve their needs.

  • Innovation:  The education system is outdated and in need of innovation and change - AI is an opportunity to bring equity, access, and serve the individual needs of students better than we ever have before.

  • Responsibility: Put responsibility and safety at the forefront of the technological change that AI is bringing to education.

  • Diversity: Diversity of thought, perspectives, and backgrounds helps us serve the wide audience of educators and students around the world.

  • Excellence:  Educators and students deserve the best - and we strive for the highest quality in everything we do.