I love this feeling as well. Reading this I actually realized that is a big part of what I like in my role as a data scientist. You are given a ton of messy data and during months you get a very intimate knowledge about how your data reflects the business processes, you understand every edge case, and end up building a nice data model that allows to answer many question that had previously no answer with a simple SELECT FROM WHERE statement. Very satisfying.