Staff Analytics Engineer

Staff Analytics Engineer

• Location: Kendall Square, MA · remote
• Company Stage: [Omit if unknown]
• Office Type: remote

Company Description

We're representing an innovative organization that is a recognized leader in next-generation curriculum and assessment solutions, dedicated to enhancing K–12 education across the United States. Their commitment to developing engaging and effective learning experiences for students and educators makes them a dynamic player at the intersection of education, technology, and data.

What You Will Do

• Independently design, build, and evolve robust data models that drive reporting, business intelligence, and application-facing data layers.
• Architect and maintain dimensional models using Kimball methodology, focusing on fact and dimension tables, slowly changing dimensions, and schema design.
• Build and manage ELT pipelines utilizing dbt and SQL frameworks, ensuring models are modular, well-tested, and production-ready.
• Optimize query performance and cost efficiency across large-scale data models, proactively identifying and resolving bottlenecks.
• Collaborate with analysts, data scientists, and product engineers to translate complex requirements into effective data solutions.

Ideal Candidate Background

• 8+ years of hands-on experience in analytics engineering or data engineering, with a proven track record of owning complex data systems from design to production.
• Expert-level proficiency in SQL, with a deep understanding of complex transformations, CTEs, window functions, and query performance tuning.
• Strong experience in Kimball dimensional modeling, including designing fact/dimension table structures and handling SCDs.

Preferred

• Hands-on experience with ELT/dbt projects in a production environment.
• Systems-level architectural thinking, with a focus on maintainability and long-term scalability.

Compensation and Benefits

This company offers a competitive salary and comprehensive benefits package, ensuring that you are rewarded for your expertise and contributions. Join a mission-driven team where your work will have a meaningful impact on education!