Analytics Engineer

Amplify is a pioneer in K–12 education, leading the way in next-generation curriculum and assessment. As an Analytics Engineer, you will join a talented team to build analytical models and data pipelines that empower educators and improve student learning experiences.

Responsibilities:

• Impress the toughest customers around – students – by building the analytical models which drive the design cycle for fun and compelling apps, helping them understand their students by building modular data models
• Help school administrators build great schools by: respecting privacy and ensuring security while offering useful insights by making inquisitive choices in tech stack, database design, masking policies, and encryption
• Helping school principals understand how teachers are teaching and how students are learning by architecting data warehouse schemas and SQL transforms with just the right CTEs, window functions, and pivots
• Analyzing performance and squashing tricky bugs using tools like Fivetran, Snowflake, Airflow, DBT, SQL, Python, Looker and Tableau
• Make life better for passionate, Marketing and Sales teams by building cohesive, common data marts from ERP and CRM source systems like Salesforce, Netsuite and HubSpot
• Learn every day by: immersing yourself in agile rituals and leveraging our infrastructure
• Collaboration, pull request-ing, CI/CD processes and mentoring on a multi-functional team
• Participating in cross-team share-outs, brownbags, and workshop series
• Becoming an expert in the data models and standards within Amplify and demonstrating the educational industry in order to deliver quality and consistent solutions
• Build well-tested and documented ELT data pipelines for both full and incremental dbt models to funnel into a fact and dimensional data mart
• Work closely with sales on logistics pipeline forecasting and sales pipeline tracking to help focus our sales teams in the right areas for the biggest impact
• Align with finance on making sure we have well audited data inline with established financial best practices
• Engineer novel datasets which express a student's progress and performance through an adaptive learning experience which allows for flexible comparison across students and deep analysis of individual students
• Work with the data science team to measure the impact of design changes on an administrator reporting application
• Contribute to leading industry data standards, such as Caliper Analytics, EdFi, or xAPICraft slowly changing dimensional models that take into account the nuances of K-12 education such as School Year changes and students moving schools or classes

Requirements:

• BS in Computer Science, Data Science, or equivalent experience
• 3+ years of professional software development or data engineering experience
• Strong computer, data, and analytics engineering fundamentals
• Proven fluency in SQL and its use in code-based ETL frameworks preferably dbt
• Understanding of ETL/ELT pipelines, analytical data modeling, aggregations, and metrics
• Strong understanding of analytical modeling architectures, including the Kimball dimensional data model design
• Experience working with Looker for explore and dashboards
• Ability to clearly communicate and present technical concepts to a broad audience both verbally and in written form
• Fluency in a development language such as Python
• Familiarity with metadata management tools such as Atlan
• Experience building dashboards, reports, and models in business intelligence tools such as Tableau or Looker
• Experience with tools we use every day: Storage: Snowflake, AWS Storage Services/DBs (S3, RDS, Glacier, DynamoDB) and Postgres ETL/ELT: Airflow, dbt, Fivetran BI: Looker
• Experience with tools we don't use, but should
• Proven passion and talent for teaching fellow engineers and non-engineers
• Experience in recommending standards and practice to streamline the pipeline processes
• Proven passion for building and learning: open source contributions, stretch goals and projects, and self-education
• Experience using LLMs for dev work like claude or co-pilot
• Experience in education or ed-tech