27/08/2026
What does a data engineering project actually look like from the consultant’s side?
In the latest Decoding the Consultant Life: Real Stories from Real Consultants, Data Engineer Juhani Takkunen shares his experience working with Smartvatten.
🔸 The challenge: reporting processes were distributed across different spreadsheets and financial and operational metrics required significant manual effort.
Our team built a common data platform for Smartvatten. Using our internal templates, we quickly spun up a proof of concept. This really helped improve communication early on between all participants.
The vast majority of our time was dedicated to defining, modeling, and implementing KPI calculations. Defining the business rules was complex and required a lot of back-and-forth between multiple key stakeholders.
Cleaning the data and properly defining KPIs allowed the customer to create live analytical reports. Earlier the customer wasn’t able to do this or keep the reports updated daily.
Juhani reflects on what he enjoyed most about the project:
💡 “Personally, I really enjoyed this part of the work: working closely with the customer to understand and define the business problem and experimenting with different solutions to find the one that truly solved the root issue.”
Read Juhani’s insights on the project in the full blog:
https://codento.com/blog/decoding-consultant-life-smartvatten/?utm_source=facebook&utm_medium=social