• BS in Computer Science, Data Science, or equivalent
• 2+ years of professional software development or data engineering experience
• Strong CS and data engineering fundamentals
• Proven fluency in SQL and its use in code-based ETL frameworks such as dbt
• Understanding of ETL/ELT pipelines, analytical data modeling, aggregations, and metrics
• Knowledge of Data Warehousing design, tooling, and support
• Strong communication skills in writing and conversation

Desirable

• As an engineer at Amplify, you will join a talented team tackling the toughest problems in education with the best ideas in technology – including user experience, APIs and services, data analysis, and deployment pipelines.
• You’ll play an active role in imagining and improving product design and the classroom experience
• Our data analytics teams ingest, transform, model, and aggregate the data that empowers teams across Amplify and our customers to make sense of and tell stories with their data.
• You’ll be working with data scientists, data analysts, and data engineers to provide clean, accurate, reliable models and metrics for our products and internal business partners
• Impress the toughest customers around – students – by building the data models which drive the design cycle for fun and compelling apps, helping them understand their students by building modular data models
• 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 Snowflake, Airflow, DBT, SQL, Python, Looker, and Datadog
• Make life better for passionate, Marketing and Sales teams by building cohesive, common data marts from sources like Salesforce and HubSpot
• Immersing oneself in agile rituals and leveraging our infrastructure
• Leading collaboration, pull request-ing, 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 the educational industry in order to deliver quality and consistent solutions
• Building well-tested and documented ELT data pipelines for both full and delta extraction
• Engineer novel dataset which expresses a students progress and performance through an adaptive learning experience which allows for flexible comparison across students and deep analysis of individual students
• Work with data science to measure the impact of design changes to an administrator reporting application
• Improve the build and query efficiency of data models constructed from a large volume of event stream data
• Contributing to leading industry data standards, such as Caliper Analytics or xAPI
• Crafting 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