Not too different from analysts writing SQL queries all day long.
I don't see this in this prompt engineering. In my limited experience (I played a few hours with Stable Diffusion and more hours with the OAI davinci-003 model), you can get good at it within a few days.
I'd imagine that being a "prompt engineer" entails finding out and mapping the structures that gives you the desired result. Think of it as a novice user of search engines VS expert user of search engines.