"I've been thinking that with SQL Server 2019 we will start to access data where it lives, not move it to another place we want it. To me, this is more of what future data orchestration might involve. I ran across an article that takes a slightly different approach, thinking AI and other products will help better move data around, and perhaps that's true, but I do think more and more we want to query data where it lives, and use larger, distributed compute platforms to do this."
Wow, for all of your sakes, I really truely hope you don't have to go back to the days of transactional data and analytical data residing together. I've been advocating for the opposite for years. I see the two as competing for resources and conceptually incompatible.
I agree that there is definitely an art to data orchestration, but see a large part of that exactly why data architects are so vital. I would understand them being mixed in a start-up shop where data quantities and users have not grown so much yet. Especially with the poorly designed transactions and poorly designed queries that I've seen it seems there is a large risk to both.
One of the best days of my IT career was the day I told my boss if the problem was so simple he should go fix it himself.