Staff Analytics Engineer

ClassDojo's goal is to give every child on Earth an education they love. We started by building a powerful network for communication. ClassDojo’s flagship app is the #1 communication app connecting K-12 teachers, children, and families globally. Teachers use it to share what’s happening throughout the day through photos, videos, and messages that make parents feel like they’re there. It’s actively used in over 95% of US schools, reaching over 45 million children in 180 countries, with a team of just around 200 people [1]. We are now beginning to use this network to give kids the best learning experiences in the world, far beyond those a standard school can provide. We hire for talent density. Our team comprises the most talented, entrepreneurial, and innovative teammates from around the world, with experience in education and large scale consumer internet companies, including Instagram, Lyft, Dropbox, Stripe, Airbnb, Y Combinator, and more. We’re building a company where the most talented people want to work. We believe you’ll do the best work of your life here—and you’ll pioneer the future of education, too. What you’ll do: 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. [1] Some more context: (If you are on LinkedIn, you will not be able to access the hyperlinks below. Once you click apply, you will be directed to our career website (if you are not on there already) and will be able to access the hyperlinks) How ClassDojo Connects Parents, Students, and Teachers  “Whats New on ClassDojo 2023” TechCrunch Article: Second Act comes with First Profits Click here if you're interested in learning more about what we've been up to. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. In accordance with the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. We are happy to accommodate any disabilities or special needs. We are a distributed company, so we hire regardless of location, as long as you are willing to have significant hours overlap with one of the Americas time zones. ClassDojo takes a number of factors into consideration when determining compensation, including geographic location, experience, and skillset. Salary ranges (United States): CA, WA, NY, NJ, CT states: $190,000 - $250,000 (USD) All other states in the US: $161,500 - $212,500 (USD) #LI-Remote Apply on employer's website This employer gathers applications via their own applicant tracking system. You will be redirected to an external application form.