Absolutely agree. It reminds me of an article that I read, had the statistics of Data scientists spend 80% of their time cleaning data rather than creating insights.
Curious to know, did you in any ways accomplish to standardise the way data was collected/ stored?