It sounds dysfunctional to me that you need an oncall query writer. It sounds like this encourages business side to not plan ahead and book tech time but just last minute call up and say “er.. I need last quarters sales aggregated by region stat”.
Normally a question like "I need last quarters sales aggregated by region stat" would be trivially answered with a pivot table or OLAP cube built from a general purpose data warehouse. But there are also ad hoc reporting requirements that call for non trivial coding by a data analyst, e.g. "We think there's something fishy going on with the stock in warehouse B. Can you take this list of serial numbers and overlay their dispatch timestamps with the staff shift schedule, then ... etc."
