# A daily orders pipeline at a Series B startup has every beginner-tier gap: green orchestrator runs a

Canonical URL: <https://datadriven.io/problems/a-daily-orders-pipeline-at-a-series-b-startup-has-every-begi-bef4b5ae>

Domain: Pipeline Design · Difficulty: medium

## Problem

A daily orders pipeline at a Series B startup has every beginner-tier gap: green orchestrator runs are the only signal, no quality checks anywhere, no layer-boundary gates, no warn-vs-block authority on the few asserts that exist, no paging when something fires. Assemble the first quality suite. Add the four cheap checks (row count, null rate, uniqueness, freshness) at the layer boundary between source and mart, each with an explicit authority (block or warn) in its name. Block-class checks route to a paging destination so on-call hears about real failures. The dashboard continues reading from the existing Snowflake mart.

## Related

- [All practice problems](https://datadriven.io/problems)
- [Mock interview mode](https://datadriven.io/interview/a-daily-orders-pipeline-at-a-series-b-startup-has-every-begi-bef4b5ae)
- [System Design Interview Questions](https://datadriven.io/data-engineering-system-design)
- [Data Engineering Interview Prep Guide](https://datadriven.io/data-engineer-interview-prep)
- [Daily Challenge](https://datadriven.io/daily)

---

Source: DataDriven (https://datadriven.io). 100% free data engineering interview prep. Live code execution against Postgres 16, Python 3.11, and Spark sandboxes. No paywall, no premium tier, no signup gate.