MagicSchool AI

Senior Data Analyst

MagicSchool AI

full-time

Posted on:

Origin:  • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Salary

💰 $140,000 - $160,000 per year

Job Level

Senior

Tech Stack

AirflowAmazon RedshiftBigQueryCloudSQL

About the role

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

Requirements

  • 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.
  • If hired, can you present proof that you are authorized to work in the United States or Canada for any employer? Due to contractual obligations, this role is open only to U.S and Canada.-based candidates authorized to work without visa sponsorship.