Amplify is looking to transform, model, and aggregate data to empower customers to make sense of and tell stories with their data, by providing clean, accurate, reliable models and metrics for their products.
Requirements
- Expertise in SQL and its use in code-based ETL frameworks, preferably dbt, focusing on reuse and efficiency.
- Expertise in ETL/ELT pipelines, analytical data modeling, aggregations, and metrics
- Expertise in dbt and git preferably with automation skills.
- Expertise in analytical modeling architectures, including the Kimball design
- 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
Responsibilities
- Building analytical models to fuel reporting we offer to administrators
- Architecting data warehouse schemas and SQL transforms with just the right CTEs, window functions, and pivots
- Creating data solutions using tools like Snowflake, Airflow, DBT, SQL, Python, Cube.dev.
- Build well-tested and documented ELT data pipelines for full and incremental dbt models to funnel into Cube Sematic Layer models.
- Engineer novel datasets that express a student's progress and performance through an adaptive learning experience that allows for flexible comparison across students and deep analysis of individual students.
- 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.
- Improving our pipeline deployments and tests
Other
- Respecting privacy and ensuring security while offering valuable insights
- Making inquisitive choices in tech stack, database design, masking policies, and encryption
- Immersing yourself in agile rituals and leveraging our infrastructure
- Leading collaboration, pull request-ing, CI/CD processes, and mentoring on a cross-functional team
- Strong communication skills in writing and conversation, including writing engineering training documentation.
