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.

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

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 modelingincremental strategiesdata quality testsvalidation checksdata pipelinesmacrosJinja

Soft Skills

communicationcollaboration