Role track
Analytics Engineer
dbt models, tests, CI, and a metric someone in finance can trust.
136 questions · SQL · dbt · Modeling · Quality · Behavioral
Suggested sequence
1. SQL and grain
If you cannot say the grain, you are not ready to write the model.
AE coding →2. The flowchart
Staging vs marts, then tests that page someone.
AE roadmap →3. dbt the way CI survives
Slim CI, source contracts, and one revenue.
dbt questions →4. Tests that page someone
Fail on grain. Ticket on a soft anomaly.
Quality questions →
Stacks in this loop
Sample questions
hard · SQL · Stripe
Deduplicate to the latest customer row. Why not filter the window in WHERE?
Practice →medium · SQL · Capital One
A join exploded revenue. How do you find the grain mismatch in five minutes?
Practice →medium · SQL · Meta
Running total of daily revenue. Why is SUM(SUM(amount)) OVER (...) valid?
Practice →hard · SQL · Google
NULL = NULL is unknown. How does that bite a MERGE or an anti-join?
Practice →hard · SQL · LinkedIn
When do you use a covering index / clustering key versus rewriting the query?
Practice →medium · SQL · Snowflake
QUALIFY vs a CTE for window filters — when do you use each?
Practice →