Analytics Engineer, Amplify

• 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

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 analytics engineering team ingests, transforms, models, and aggregates 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 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
• Example Projects You Might Work On
• 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