Staff Analytics Engineer

Recruiting from Scratch; El Centro (CA); Remote; USD 175,000 - 185,000; Full time

Benefits offered by this job

Annual discretionary bonus

Comprehensive medical, dental, and vis

401(k) retirement plan

Mental health and wellness support

Professional development and learning

Job summary

Recruiting from Scratch LLC is seeking a Staff Analytics Engineer to design scalable ELT pipelines and semantic data layers for education analytics. You will own data modeling, warehouse schemas, and performance-focused transformations across Snowflake and cloud tooling.

You will mentor engineers, collaborate with data scientists and business stakeholders, and help shape the analytics strategy for a fully remote team serving education customers in the United States.

Qualifications

• 8+ years in software/data/analytics engineering
• 5+ years in analytics engineering or modern ELT
• Deep SQL and dbt expertise
• Experience with Kimball dimensional modeling
• ETL/ELT workflows and semantic data layers
• Knowledge of Snowflake and cloud storage
• Airflow, Fivetran, Matillion experience
• BI tools like Looker/Tableau/Cube.dev familiarity
• Git, CI/CD, and engineering practices
• Strong communication and mentoring abilities

Responsibilities

• Design and maintain scalable ELT/ETL pipelines using dbt, Airflow, SQL, and cloud tooling
• Build clean analytical data models and semantic layers for reporting and product analytics
• Architect warehouse schemas and metrics systems for performance and maintainability
• Create datasets supporting student performance analysis and educational insights
• Develop slowly changing dimensional models for school-year transitions
• Improve deployment workflows, testing infrastructure, and CI/CD practices
• Collaborate with data scientists, software engineers, analysts, and stakeholders
• Mentor engineers and contribute to engineering standards and knowledge sharing
• Shape long-term analytics strategy and technical direction across the organization

Skills

SQL proficiency

Data modeling

ETL/ELT design

Mentorship

Communication

CI/CD

Engineering workflows

Analytical thinking

Tools

dbt

Airflow

Snowflake

Fivetran

Matillion

Looker

Tableau

Cube.dev

Job description

Staff Analytics Engineer

Location: Remote - United States

Company Stage: Established EdTech / Growth-Stage Education Technology

Office Type: Remote

Salary: $175K - $185K Base + Bonus

Company Description

This education technology company is building modern curriculum, analytics, and assessment products used by millions of students and educators nationwide. Their data organization powers large-scale reporting, analytics, and decision-making systems that help schools better understand student learning outcomes and operational performance. The team operates at the intersection of analytics engineering, data infrastructure, and business intelligence, building scalable platforms and semantic data layers that support educators and administrators at scale.

What You Will Do

• Design and maintain scalable ELT/ETL pipelines using dbt, Airflow, SQL, and modern cloud data tooling
• Build clean, reusable analytical data models and semantic layers powering reporting and product analytics
• Architect warehouse schemas, transformations, and metrics systems optimized for performance and maintainability
• Create datasets that support student performance analysis, adaptive learning systems, and educational insights
• Build and improve slowly changing dimensional models handling school-year transitions and student movement across systems
• Improve deployment workflows, testing infrastructure, CI/CD processes, and data reliability practices
• Collaborate cross-functionally with data scientists, software engineers, analysts, and business stakeholders
• Mentor engineers and contribute to engineering standards, documentation, and knowledge sharing initiatives
• Help shape long-term analytics engineering strategy and technical direction across the organization

Ideal Background

• 8+ years of experience in software engineering, data engineering, or analytics engineering
• 5+ years specifically focused on analytics engineering, data modeling, or modern ELT systems
• Deep expertise in SQL and dbt for production-grade transformation pipelines
• Strong experience with analytical data modeling and Kimball dimensional modeling principles
• Experience designing scalable ETL/ELT workflows and semantic data layers
• Strong understanding of warehouse technologies such as Snowflake and cloud storage systems
• Experience with orchestration and ingestion tools such as Airflow, Fivetran, and Matillion
• Familiarity with BI and semantic tooling including Looker, Tableau, or Cube.dev
• Strong Git, automation, CI/CD, and engineering workflow experience
• Excellent communication and mentorship abilities with experience leading technical initiatives

Preferred

• Fluency in Python or another programming language
• Familiarity with metadata management platforms such as Atlan
• Experience building business intelligence dashboards and reporting frameworks
• Experience within education technology or highly regulated data environments
• Passion for mentorship, teaching, and improving engineering culture
• Open-source contributions, side projects, or demonstrated technical curiosity

Compensation and Benefits

• Base salary: $175K - $185K
• Annual discretionary bonus eligibility
• Comprehensive medical, dental, and vision coverage
• 401(k) retirement plan
• Mental health and wellness support
• Paid time off and parental leave
• Professional development and learning programs
• Fully remote work environment within the United States