At work (generally, inclusive of but not only my company) you’ll find power users in Solutions Engineering implementing and automating nuts and bolts integrations and performing data wrangling on BI teams. There’s a lot of work to be done by people who don’t really code, and if they do it’s light scripting. They take a huge load off of the Engineering staff. I’ve also seen power users make their way into UI Automation.

It seems like once they get a few years under their belt they move into Product or Project Management or gain sufficient scripting experience that they move into an entry level Software role.