• Develop and maintain high-quality dbt models, tests, documentation, and workflows to create reliable transformation pipelines. • Build and optimize dimensional and semantic data models that power business-critical reporting and analysis. • Partner with data consumers and stakeholders to translate business questions into well-defined datasets and semantic definitions. • Design, build, and maintain the semantic layer for visualization tools such as Omni Analytics, Looker, or Sigma. • Ensure data quality and trust by implementing automated testing, monitoring, and observability best practices. • Collaborate with Engineering to scale pipelines, improve performance, and reduce latency in the analytics stack. • Own the data modeling strategy and governance standards, including conventions, documentation, and onboarding practices. • Mentor and guide other analytics engineers and data team members on best practices.

• Own the data models that scale our portfolio and turn messy questions into high-stakes decisions. • Help define how we measure the business. • Work closely with product, monetisation, UA, and finance leads. • Ensure mobile KPIs are accurate, explainable, and trusted. • Split between building elite data infrastructure and data analysis. • Design and maintain the dbt project on BigQuery. • Build and iterate on dashboards that give non-technical teams confidence to make decisions. • Dig into the data, investigate anomalies, and surface insights.

• Du erstellst datenbasierte Entscheidungsgrundlagen für das E-Commerce, sowohl im Tagesgeschäft als auch im Rahmen unserer OKRs • Du identifizierst eigenständig Wachstumsfelder im E-Commerce • Du legst dabei einen besonderen Fokus auf Fragestellungen zum Verhalten unserer Kundinnen im Onlineshop • Du entwickelst auf Basis einer etablierten zentralen Data Plattform spezielle Datenmodelle für die E-Commerce-Domäne und stellst sie für ad-hoc-Analysen oder Standard-Reportings bereit • Deine interaktiven Dashboards machen strategische und operative Zusammenhänge auf einen Blick sichtbar und schaffen Transparenz auf allen Ebenen • Du verantwortest die Qualität deiner Datenpipelines und entwickelst eigenständig Tests zur Sicherstellung von Aktualität und Korrektheit • Im Data-Team bist du die zentrale Ansprechperson für das E-Commerce-Team

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description 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. - 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. 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. - 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. Requirements - 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. Benefits - 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 $115,000 - $129,000. - This role is eligible to earn an annual discretionary bonus that rewards individual and company performance.