Staff Analytics Engineer

Amplify Education

Remote
$175,000 - $185,000; bonus eligible; competitive h...
Sql and code-based etl
Etl/elt pipelines, analytical data modeling
Analytical modeling architectures
Transform, model, and aggregate data to empower customers to make sense of and tell stories with their data, working with cross-functional teams to provide clean, accurate, reliable models and metrics

Job Summary

  • Transform, model, and aggregate data to empower customers to make sense of and tell stories with their data, working with cross-functional teams to provide clean, accurate, reliable models and metrics.
  • Architect data warehouse schemas and SQL transforms, and create data solutions using tools like Snowflake, Airflow, DBT, SQL, Python, and Cube.dev.
  • Immerse yourself in agile rituals, leverage infrastructure, lead collaboration, participate in CI/CD processes, and mentor on a cross-functional team.

Matching Summary

Transform, model, and aggregate data to empower customers to make sense of and tell stories with their data, working with cross-functional teams to provide clean, accurate, reliable models and metrics.

Salary

$175,000 - $185,000; Bonus eligible; Competitive health insurance, 401(k) plan, paid time off, parental leave

Skills & Requirements

Must-have

  • SQL and code-based ETL
  • ETL/ELT pipelines, analytical data modeling
  • analytical modeling architectures
  • data warehouse schemas
  • data solutions using Snowflake, Airflow, DBT, SQL, Python

Nice-to-have

  • passion for teaching engineers
  • passion for building and learning
  • technical leadership in project delivery
  • familiarity with metadata management tools
  • experience in education or ed-tech

Key Requirements

  • BS in Computer Science, Data Science, or equivalent experience
  • 8+ years of professional software development or data engineering experience
  • 5+ years experience in computer, data, and analytics engineering
  • Expertise in SQL and its use in code-based ETL frameworks, preferably dbt
  • Expertise in ETL/ELT pipelines, analytical data modeling, aggregations, and metrics
  • Expertise in dbt and git
  • Expertise in analytical modeling architectures, including the Kimball design
  • Strong communication skills in writing and conversation

Work Rights

Not specified

Tailored Resume

Cover Letter