# A 30-engineer company has one daily Python ETL: it runs on a cron, lands rows in Snowflake, and feed Canonical URL: Domain: Pipeline Design ยท Difficulty: medium ## Problem A 30-engineer company has one daily Python ETL: it runs on a cron, lands rows in Snowflake, and feeds a Looker BI dashboard. The transform has no orchestrator owning its schedule, no observability watching its output, hardcoded credentials, no catalog, no CI runner, and no cost attribution. Apply the section's six-undercurrents framing and add each one as named tooling around the four roles already on the canvas. ## Related - [All practice problems](https://datadriven.io/problems) - [Mock interview mode](https://datadriven.io/interview/a-30-engineer-company-has-one-daily-python-etl-it-runs-on-a-7f7314df) - [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.