> we had multiple pipelines that transformed data in the data warehouse

I've done this in the past too. But that isn't simply what ELT is. In the past compute was tied to storage which made these transforms interfere with load on the actual system.