Not exactly the kind of feedback you're looking for, but within my agency we have a database specialist. She knows the ins and outs of CMA tech and how to integrate it with business tech (Salesforce, Hubspot, Marketo, etc.). It's essential for most of our clients to have this kind of expertise at hand.
In terms of if it makes sense for your in-house roles, I think it depends on the volume of data and tech, as well as what you are trying to achieve. For example, if you have a huge content production operation and no one to reliably add that content to your CMA database, sales enablement tools, etc. I could see that being a massive gap in your team's efficiency and effectiveness. Or if your team regularly runs into issues pulling the correct kind of customer data out of your CRMs and manipulating it in a way to update your team's reporting, having someone to own the entire effort can be invaluable.