There is an awkward stage in most product companies where you genuinely need answers from your data, but you cannot justify hiring a data engineer. The mistake at this stage is either to skip the work entirely and fly blind, or to over-build a data platform that nobody is ready to operate.
The lightweight stack that bridges this gap has become standardised, and it is well within the reach of a product engineering team.
The four components
A warehouse. BigQuery, Snowflake, or Postgres-with-discipline. Pick one and never load production data into anything else.
An ingestion layer. Fivetran, Airbyte, or — for the brave — a few scheduled extract jobs. You want one tool that knows how to read every source system you care about.
A transformation layer. dbt, almost universally. Models in version control, tested in CI, documented inline.
A BI tool. Metabase or Lightdash for the lightweight end, Looker for the heavyweight end. Pick what your stakeholders will actually use.
That is the entire stack. Anyone who tries to sell you a "modern data platform" with twelve more components is selling you complexity you do not need yet.
The discipline that separates good from bad
The technical setup is the easy part. The discipline that separates the data platforms that pay back from the ones that gather dust is the same handful of habits every time.
Models are version controlled. Tests run on every change. Definitions of core metrics (revenue, active users, conversion) live in one place that everyone agrees is the source of truth. Dashboards link back to the SQL that produces them. Stakeholders learn to ask "is this number in dbt yet?" before they trust it.
When to graduate
The signals that you have outgrown the lightweight stack are concrete: you have a full-time analyst who is bottlenecked on engineering, you have data products (not just dashboards) that need to be deployed and monitored, or your stakeholder count is in the dozens. At that point hiring a data engineer pays for itself within a quarter.
Until then, the lightweight stack will serve you well. Most companies underestimate how far it goes.