← All questions
HardCodingData
The public task uses local dbt/DuckDB subscription models and a capped retained-revenue cohort report. Follow the source for its complete task and rules; we do not reproduce its datasets or submission instructions.
Asked at
Tracksuit
Tracksuit1Give yourself 5 minutes
2Answer out loud, not in your head
3Then compare with the answer below
0
Reference answer
Then expect these follow-ups
How do late refunds restate a cohort?
Which uniqueness and relationship tests protect the model?
Hiring now
Data engineer roles are open right now
landed applies to roles like these for you, on each company’s own site, with answers written for the role.
Get 5x interviews10 free auto-applies. No card.
Data Engineer
EQS Group · Barcelona
Senior Data Engineer, Telemetry & Analytics Tooling
Interactive Brokers · Greenwich, CT, USA
Director, Data Engineering
Strive Health · Denver, CO
Next question
- The employer publishes a reproducible data-ingestion and analysis exercise using public city datasets, with an emphasis on code, documentation and results. Consult the opened source for current scope rather than stale search snippets.
- Teleport publishes a Go service exercise that reads and changes Kubernetes Deployment replica counts, with design, delivery and testing requirements. This is a public sample, not evidence that our exact prompt was asked in a past interview.