Analytics Engineer II
About The Position
We’re looking for an Analytics Engineer II to join Khan Academy’s Analytics Engineering (AE) team. You’ll help transform raw product, learning, and operational data into clean, reliable, and well-modeled datasets that power insights across the organization. You’ll collaborate closely with Data Infrastructure (DI), Data Analysts, and Product/Program teams to ensure that our data warehouse (BigQuery) and BI layer (Looker) serve as trusted sources for decision-making. This role is ideal for someone who’s comfortable working across both dbt and Looker, has an eye for data model design, and enjoys making complex data systems intuitive and performant.
Requirements
- 3+ years of deep, warehouse-centric analytics engineering experience..
- Strong SQL and dbt proficiency (including macros, Jinja, and incremental model strategies).
- Hands-on experience building and maintaining Looker models (LookML, Explores, derived tables).
- Familiarity with modern data stacks (e.g., BigQuery, Git, and basic CI/CD practices for testing and deploying data models).
- Understanding of data modeling concepts (SCDs, star schemas, bridge tables).
- Strong communication skills and comfort collaborating across technical and non-technical teams.
- Exposure to orchestration tools like Airflow.
- Familiarity with version control and collaborative development (Git, code review).
Nice To Haves
- Experience with BigQuery
- familiarity with education-technology contexts.
Responsibilities
- Design, build, and maintain dbt models that transform raw event- and entity-level data into curated, analytics-ready datasets.
- Develop, document, and test semantic and reporting layers in Looker (LookML).
- Partner with Analysts and cross-functional stakeholders to ensure consistent metric definitions and accurate data pipelines.
- Contribute to data modeling best practices, including naming conventions, incremental strategies, and schema evolution.
- Implement data quality tests and validation checks to ensure reliability of production datasets.
- Monitor and troubleshoot data issues, coordinating fixes with Data Infrastructure and Engineering.
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
- 401(k) + 4% matching & comprehensive insurance, including medical, dental, vision, and life
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
