Analytics engineer loop
A screen and introduction, dbt tests, a warehouse fanout task, a star schema and a cohort query, then a metric definition call, fit, a SQL review, a panel and the offer.
- Rounds
- 11
- In all
- 5 h 22 min
Screen2 rounds · 37 min
- Round 1 · Phone screenAnalytics engineer screen: your toolsStart 25 min
- Round 2 · IntroductionAnalytics engineer introduction: work you are proud of12 min
Technical4 rounds · 2 h 5 min
- Round 3 · PipelinesSlate Service: Accepted-value tests30 min
- Round 4 · SQLFanout in a finished report30 min
- Round 5 · Data modelingOrders, returns and a star schema30 min
- Round 6 · SQLMature customer retention cohorts35 min
Fit2 rounds · 1 h
- Round 7 · Situational judgmentData modeling: two meanings of one status25 min
- Round 8 · BehavioralAnalytics engineer: a mistake and its repair35 min
Final rounds3 rounds · 1 h 40 min
- Round 9 · Take-home reviewA SQL take-home review35 min
- Round 10 · PanelAnalytics engineer panel: quality against speed50 min
- Round 11 · OfferAnalytics engineer offer: what you will own15 min