Just for discussion sake since you asked for stories about other environments, our data is primarily on-premise and we use plain-old Teradata for our warehouse

Just for discussion sake since you asked for stories about other environments, our data is primarily on-premise and we use plain-old Teradata for our warehouse as well as write our own ETL scripts in SAS. We're looking into Alteryx to see if we can merge our data together but I don't think any of the above would be as useful to your environment. We are happy with our plain-old relational database simply because our analysts can navigate it easily. I've worked other tools like Informatica but it's been a pain to get them to work with our data, which is why we wrote our own scripts.