Executive Summary
Your junior data team is busy producing reports, but the numbers don't seem to add up and no one is sure what they should be working on.
You're spending over £150k a year on salaries that create more questions than answers. Important decisions are being made with unreliable data, and your best analysts are likely getting frustrated.
The problem usually isn't the people, but the system they're working in. Instead of thinking about headcount, it's time to design the structure they need. The real choice is between building that structure or staying stuck.
A common situation: a busy data team creating confusion
You’ve done what you were told to do. You invested in a modern data stack (Snowflake, dbt, Looker) and hired a team of bright, technically-minded data analysts. Yet, you find yourself in board meetings unable to answer a simple question like, "Is this an active user?" without three different answers emerging.
The team is busy. They are constantly creating new dashboards and closing tickets. But this activity isn't leading to real impact. You have likely moved to the cloud and hired smart engineers, but all you’ve done is migrate your mess faster. Automating a broken process just generates bad data at speed. The question you're wrestling with is a difficult one: do I cut my losses, or do I double down and pay for expensive training?
In my experience, this is the wrong question to ask. It points to the individuals, when the problem is often the system they've been put into.
Why junior teams without senior direction can struggle
I see this quite often with Series B and C companies. They hire technically-gifted analysts who have never had to defend a number to a CFO. They are given access to the tools and told to 'find insights'. This puts them in a very difficult position.
Without senior direction, a junior team tends to become a service desk. They take orders. The Head of Marketing wants a dashboard, so they build it. The Head of Ops wants a different view, so they build that, too. Soon, you have 200 dashboards that all claim to show 'revenue' but use slightly different logic hidden in chaotic SQL scripts. Your team becomes a Data Engineering Bottleneck, servicing ad-hoc requests instead of building things that last.
The problem isn't that your definition of 'Churn' is wrong. It's that it hasn't been agreed across the business and so it's used inconsistently. This isn't a training issue, it's a structural one. You're asking a team of mechanics to design the car.
The solution: build a system for the team to work in
The most effective data teams I've seen operate like an efficient production line, not a bespoke art studio. The answer isn't firing the team or sending them on a generic Python course. It's to provide the clear structure they're missing.
This is about doing the unsexy, foundational work that allows things to grow properly.
By building this framework, you change the team's role. They stop spending all their time tidying up messy data and start owning a reliable source of information. You're not just managing people, you're managing a system. Often, this needs temporary help from someone who has built this kind of system before, perhaps as a fractional Head of Data, to get the structure right.
The trade-off: a short-term slowdown for long-term speed
Let's be direct. Putting this in place requires a short-term slowdown to speed things up in the long run. You have to pause the flow of ad-hoc requests to design the engine properly. It means telling department heads they can't have their custom report this week because you are busy ensuring the core numbers are correct.
This is a challenge of managing expectations, not a technical one. It requires support from leadership to prioritise foundational work over immediate, often trivial, requests. You will move slower for one quarter to move faster for the next three years.
The result: from a source of cost to a source of value
Once this structure is in place, things change quite a bit. Your junior team, now with clear guardrails and a defined purpose, can finally use their technical skills effectively. Ad-hoc requests fall away because people in the business have a smaller set of trusted, well-documented dashboards they can use themselves.
Your team stops getting frustrated with repetitive tasks and starts building useful data sets that last. And you can walk into any meeting with complete confidence in the numbers. The debate shifts from, 'Is this data right?' to, 'What is this data telling us to do?'.