And what you're doing is the best practice - always utilize your data experts and they will be happy you circled them in.
If the data is large, micro process each QUERY of the 4. Then Union them all together in another job.
4 jobs total, each step is a view/table. Then 1 more job to put them together. That will make your entire solution much faster because stacking one long query takes longer than 4 small ones running. Cheers mate, have a good week.