After a short exploratory meeting with Alation, was pointed towards Data Cookbook which looks promising (and apparently is used by many other universities). Will look into further and may update this answer.
http://www.datacookbook.com/videos-2/ (as a DE, I'd recommend watching the videos in order: 1, 2, 5, 4, 3)