I’ve been a marketer in-house for several companies and a marketer for several marketing agencies, and I’ll tell you, the skills needed for either position are exactly the same.
However, it’s more difficult for a business to find a competent marketing specialist who will make a good fit in-house, compared to finding a competent marketing agency that can reach the goals that you have in mind.