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

Requirements

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

Benefits

401(k) plan
competitive health insurance and mental health options
basic life insurance
paid time off
parental leave
access to best-in-class development programs

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLETLELTdata modelinganalytical modelingdata warehouse architecturedata aggregationmetricsPythonanalytics engineering

Soft Skills

communicationpresentationcollaborationmentoringproblem-solvinginquisitiveagile methodologiescross-team collaborationorganizational skillsleadership

Certifications

BS in Computer ScienceBS in Data Science