Staff Analytics Engineer

Salary

CA, WA, NY, NJ, CT states: $190,000 - $250,000; All other states in the US: $161,500 - $212,500

Location

Remote or San Francisco, CA

We are seeking a Staff Analytics Engineer to join our Data Science and Analytics team. The ideal candidate will possess a passion for education and a strong foundation in all aspects of analytics engineering. In this pivotal role, you will be instrumental in making data accessible and actionable, facilitating informed decision-making throughout the company. You will partner and lead across multiple product team functions and domains and drive impact through your data vision and architecture.

You will be a match if:

7+ years experience with data / analytics engineering

Collaboration and Communication:

You have owned large-scale data projects that drove significant impact across the company
You are an effective partner with engineering, data analysts, data scientists, and other business stakeholders.
You dive deep into understanding the product itself, team roadmaps, technical architecture, and data flow from logging to warehouse. You ask questions and unblock yourself in truly owning your project scope.
You enjoy mentoring other data-savvy stakeholders (Data Science, PM, Eng) on data best practices

Data Modeling:

You live and breathe schema design (whether it's Snowflake, Star, or Data Vault 2.0) and sharing your ideas in thoughtful design reviews
You have a deep love of creating clean fact, dimension, aggregate, cube tables and get excited about tracking their downstream usage and feedback
You have led the design, implementation, and monitoring of large scale data warehouses and data marts that enable clear product-focused insights

SQL and Query Performance:

You are an expert at SQL and are very comfortable writing window functions, STRUCT/ARRAY manipulation, and query optimization
You adhere to and promote performance best practices for your tables depending on the database engine (partitions, sort keys, dist keys, clustering, incremental modeling)

Data Governance:

You have a passion for data cataloging and metadata management tools to document data assets and ensure data lineage
You live by data governance principles, including data classification, data ownership, and data stewardship

Data Transformation and ETL:

You design systems with a test-driven approach in mind to trap bad quality data or highlight alerts as part of your data flow
Familiarity with ETL (Extract, Transform, Load) processes and tools to prepare and clean data for analysis
Skill in using tools like dbt to build data transformation pipelines

You might be a good fit if:

You love working with SQL frameworks like dbt to cleanly abstract model code from implementation
You are an Airflow expert and digging into DAG failures and optimizing task run times excites you
You are passionate about data governance and how we can apply principles like least-privilege access, retention policies, and data minimization at scale
You are a continuous learner. Staying current in the latest trends and technologies in data analytics and educational technology is no easy feat. You will have the opportunity to lead initiatives to experiment with new data sources, data warehouses, analytics methodologies, and technologies to enhance our analytics capabilities and drive innovation within the company.

‌