# A 200-engineer growth-stage company has accumulated 53 transforms and 100 dashboards with no shared Canonical URL: Domain: Pipeline Design ยท Difficulty: medium ## Problem A 200-engineer growth-stage company has accumulated 53 transforms and 100 dashboards with no shared layers; three teams compute weekly active users with different numbers. The new head of data engineering wants the smallest set of changes that makes the system operable. Apply every intermediate-tier framing the section taught: shared layered architecture, the right ETL or ELT choice per transform, one orchestrator owning the DAG, freshness cadence visible per source, and the ML branch split downstream of the curated layer. ## Related - [All practice problems](https://datadriven.io/problems) - [Mock interview mode](https://datadriven.io/interview/a-200-engineer-growth-stage-company-has-accumulated-53-trans-9a14d892) - [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.