Amplify is looking for a Senior Data Analyst to use data to inform business strategy and product development, impacting millions of students. The role will involve providing clean, accurate, and reliable metrics and reports for products and internal business partners, driving strategic decisions across every department.
Requirements
- Expertise in advanced Structured Query Language (SQL), including complex joins, subqueries, and window functions.
- 5+ years of experience in the development and enhancement of dbt data models, including designing, building, and maintaining transformation models, writing modular SQL queries, and documenting data lineage.
- Demonstrated ability to build and maintain data models, semantic models, and enterprise Business Intelligence (BI) reports and dashboards using tools like Looker or Omni.
- 5+ years of experience using python for data analysis tasks.
- 5+ years of experience using Git and Github for version control.
- Experience working with a cloud-based data warehousing and analytics stack (Fivetran, Snowflake, dbt).
- Familiarity with ETL/ELT pipelines and related tooling; understanding of relational data models, dimensional data models, and metric creation.
Responsibilities
- building reporting frameworks and narratives that drive strategic decisions across every department at Amplify
- working with data scientists and engineers to provide clean, accurate, reliable metrics and reports for our products and internal business partners
- discovering trends in usage of our reporting applications
- providing the visibility our supply chain teams need to make sure educational materials arrive in full and on time
- forecasting customer support demand to ensure that no administrator has to wait on hold when they need help
- building cohesive and action-oriented Looker or Tableau dashboards which turn impressions into opportunities, opportunities into new customers, and new customers into long term relationships
- analyzing cross-selling patterns to distill lessons from those regions and product mixes where we are seeing success to formulate new strategies
Other
- 5+ years of experience in a data analyst or related role.
- Excellent communication skills in writing and conversation, especially with non-technical partners.
- A drive to understand data and key performance metrics and their relevance to our business and product decisions.
- Experience working in agile teams and a willingness to participate in team rituals like Storytime, Story Splitting, Story Estimation, and Retrospectives.
- Demonstrated ability owning meaningful metrics and KPIs by translating business problems and processes into measurable outcomes, aligning them with broader business strategy and team-level objectives.
