Analytics Engineer

Amplify; United States; Remote; USD 113,000 - 125,000; Full time

Job summary

Amplify is seeking a Data Engineer to join their innovative team in K-12 education technology. You will work closely with data scientists and analysts to develop analytical models and data pipelines that improve educational products and services. This role offers the chance to impact education positively while working in a collaborative and agile environment. Competitive salary and benefits package included.

Benefits

401(k) plan

Competitive health insurance

Paid time off

Parental leave

Access to development programs

Qualifications

• 3+ years of professional data engineering experience.
• Strong fluency in SQL and experience with ELT/ETL frameworks.
• Understanding of data modeling architectures.

Responsibilities

• Build analytical models that drive app design and performance.
• Architect data warehouse schemas and SQL transformations.
• Develop and maintain ETL data pipelines.

Skills

Data Engineering Fundamentals

SQL

Analytical Modeling

Python

Education

BS in Computer Science

Tools

Snowflake

AWS

Tableau

dbt

Fivetran

Job description

A pioneer in K–12 education since 2000, Amplify is leading the way in next-generation curriculum and assessment. Our core and supplemental programs in ELA, math, and science engage all students in rigorous learning and inspire them to think deeply, creatively, and for themselves. Our formative assessment products help teachers identify the targeted instruction students need to build a strong foundation in early reading and math. All of our programs provide educators with powerful tools that help them understand and respond to the needs of every student. Today, Amplify serves more than 15 million students in all 50 states. For more information, visitamplify.com.

Amplify is a leader in creating immersive, rigorous digital learning experiences that look great, play great, and help students expect great things of themselves. Amplify has been described as the best tech company in education, and the best education company in tech.

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.

Essential Responsibilities:

What You’ll Do

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

Required Qualifications:

• 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

• Ability to clearly communicate and present technical concepts to a broad audience both verbally and in written form

Preferred Qualifications:

• 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, Matillion, Fivetran

  • BI: Looker, Tableau

• 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 in education or ed-tech

What we offer:

Salary is only one component of the Amplify Total Rewards package, which includes a 401(k) plan, competitive health insurance and mental health options, basic life insurance, paid time off, parental leave, and access to best-in-class development programs. The gross salary range for this role is $113,000 - $125,000. This role is eligible to earn an annual discretionary bonus that rewards individual and company performance.

Amplify is an Equal Opportunity Employer. Amplify makes employment decisions based on qualifications and merit, and does not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability status, veteran status, or any other legally protected characteristic or status.

Amplify is committed to providing reasonable accommodations for qualified individuals with disabilities, including disabled veterans. If you have a disability and need an accommodation in connection with the application or hiring process, please email [e-mail].

.

If you are selected for employment, a background check will be required. As required by state and local laws and district policies, you may be required to provide additional documentation, such as proof of vaccination, or submit to enhanced background screening, such as fingerprinting.

Amplify is an E-Verify participant.