Analytics Engineer

Readable role content extracted into sections for faster review.

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 encryptionhelping 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 pivotsanalyzing performance and squashing tricky bugs using tools like Fivetran, Snowflake, Airflow, DBT, SQL, Python, Looker and Tableau.
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.

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 infrastructurecollaboration, pull request-ing, CI/CD processes and mentoring on a multi-functional teamparticipating in cross-team share-outs, brownbags, and workshop seriesbecoming an expert in the data models and standards within Amplify and demonstrating the educational industry in order to deliver quality and consistent solutions
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

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 xAPI
Craft 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.

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 PostgresETL/ELT: Airflow, dbt, Fivetran BI: Looker
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