Khan Academy is a nonprofit with the mission to deliver a free, world-class education to anyone, anywhere. They are seeking a Senior Analytics Engineer to design and build datasets, pipelines, and semantic models that provide insights across the organization.
Responsibilities:
- Design, implement, and optimize dbt models that transform raw event- and entity-level data into analytics-ready datasets
- Own and evolve data domains that support reporting across Khan Academy
- Develop, document, and test semantic and reporting layers in Looker (LookML)
- Partner with Analysts to establish consistent metric definitions, reusable data patterns, and shared governance practices
- Drive data modeling standards and champion best practices in naming, testing, and schema design
- Diagnose and resolve complex data issues, coordinating across Data Infrastructure and Engineering when needed
- Mentor Analytics Engineers and Analysts, providing feedback through code reviews and technical guidance
- Collaborate with cross-functional teams to identify opportunities to improve data accessibility and reliability
Requirements:
- 5+ years of deep, warehouse-centric analytics engineering experience
- Expert-level SQL and dbt skills (macros, Jinja, incremental model strategies, schema testing)
- Deep experience building and maintaining Looker models (LookML, Explores, derived tables, and performance tuning)
- Proven ability to design scalable, maintainable data models (SCD2, star schemas, bridge tables, data marts)
- Familiarity with modern data stacks (e.g., BigQuery, Git, and CI/CD practices for testing and deploying data models)
- Experience orchestrating workflows using tools like Airflow
- Strong cross-functional communication skills and ability to influence data decisions across teams
- Familiarity with version control and collaborative development (Git, pull requests, and code review)
- Experience with BigQuery specifically
- Background in education technology or mission-driven organizations
- Demonstrated contributions to data governance, metrics standardization, or semantic modeling initiatives