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

6+ years of experience in analytics engineering, data engineering, or a related data role.
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).

Benefits

Competitive salaries
Ample paid time off as needed – Your well-being is a priority
8 pre-scheduled Wellness Days in 2026 occurring on a Monday or a Friday for a 3-day weekend boost
Remote-first culture - that caters to your time zone, with open flexibility as needed, at times
Generous parental leave
An exceptional team that trusts you and gives you the freedom to do your best
The chance to put your talents towards a deeply meaningful mission and the opportunity to work on high-impact products that are already defining the future of education
Opportunities to connect through affinity, ally, and social groups
And we offer all those other typical benefits as well: 401(k) + 4% matching & comprehensive insurance, including medical, dental, vision, and life

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdbtLookMLdata modelingSCD2star schemasbridge tablesdata martsAirflowCI/CD

Soft Skills

cross-functional communicationmentoringinfluencingcollaborationfeedbackproblem-solvinggovernance practicesdocumentationtestingbest practices