Turn Learning Data Into Learning Breakthroughs
At Subject, we're building AI-powered, personalized education at scale. Backed by Owl Ventures, Kleiner Perkins, Latitude Ventures, and more, we serve students across the country with cinematic, video-based learning. But we have a challenge : data is our superpower, and we need more talented, committed, and passionate people helping us build it out further.
We’re looking for an Analytics Engineer to join our growing data and product organization. You’ll sit at the intersection of data, product, and engineering—transforming raw data into accessible, reliable, and actionable insights that guide decision-making across the company.
This role will be foundational in building Subject’s analytics infrastructure, supporting initiatives like :
- Product engagement and learning outcomes measurement
- Operational analytics for school implementations
- Generative AI products (e.g. Subject Spark Homework Helper and SparkTA)
- Data integration across systems like postgres, dbt, Pendo, Looker, and more
You’ll help define what “good data” means at Subject and ensure that stakeholders—from executives to course designers—can make confident, data-informed decisions.
What You'll Build :
Scalable Data Transformation Infrastructure
Design and optimize dbt models that handle 100M+ daily events withBuild modular, tested transformation pipelines that reduce compute costs by 70%+Create data quality frameworks and governance standards that make our warehouse reliableArchitect incremental models that process only what's changedHigh-Performance Analytics Dashboards
Build Looker dashboards that load inDesign Hex notebooks turning hours-long reports into one-click updatesCreate self-service analytics empowering teams to answer their own questionsDevelop real-time monitoring alerting teams to critical student engagement changesIntelligent Data Models for AI-Powered Learning
Design dimensional models enabling rapid exploration of learning patternsBuild feature stores feeding AI systems with clean, timely learning signalsCreate cohort analysis frameworks revealing which interventions work for which studentsArchitect data products bridging raw events and business intelligenceData Infrastructure That Scales
Write SQL optimized for millisecond response timesBuild Python automation eliminating manual work and catching errors earlyDesign orchestration workflows that run reliably and recover gracefullyOptimize cloud costs while improving performanceThe Technical Stack :
dbt - Transformation layer (50% of your time)SQL (PostgreSQL) - Complex analytical queries, performance tuningPython - pandas, numpy, matplotlib for analysis and automationHex - Interactive notebooks for reportingLooker - Business intelligence and dashboardsCloud Data Warehouse - BigQueryYou'll work with billions of learning events, student performance data, video engagement metrics, assessment results, and feedback loops.
What We're Looking For :
Required Experience
3-5+ years in analytics engineering or data analytics building production systemsAdvanced SQL mastery - Elegant, performant queries. Understanding query plans and optimizationdbt expertise - Built and maintained dbt projects with 100+ modelsPython proficiency - pandas, numpy, automation, and data pipelinesBI tool experience - Production dashboards in Looker, Tableau, or similarData modeling skills - Dimensional models, normalization tradeoffs, schemas that scalehe Mindset We Need
Performance obsession - Can't stand slow dashboards or inefficient queriesUser empathy - Build for people who need insights, not just technical eleganceSystems thinking - Optimize the entire data pipeline from source to dashboardOwnership mentality - Maintain what you build, not just ship and move onEducational curiosity - Genuine interest in learning science and student successCollaborative spirit - Explain concepts clearly and elevate team data literacyBonus Points
Education data or student analytics experienceData science or ML workflow exposureCloud platform experience (GCP, AWS, Azure)Reverse ETL or operational analyticsAnalytics engineering open source contributionsWhy This Role Matters :
Your dashboards inform decisions affecting 5 million studentsYour optimizations save hundreds of engineering hours monthlyYour data models power AI personalization for each studentYour work helps teachers understand and improve outcomesCompensation & Benefits Base Salary : $140K - $180K based on experience Equity : Meaningful ownership that grows with your impact Performance Bonus : Tied to infrastructure improvements and outcomes Health & Wellness : Comprehensive coverage, gym membership, daily meals Location : Los Angeles, CA (in-office preferred)
Ready to Build Education's Data Foundation? This isn't just another analytics role. Define how a category leader uses data, build infrastructure that becomes industry-standard, and improve educational outcomes for millions. Apply now and transform education through data.