I'm trying to pivot out of data which IMO is a scam industry and thought I'd consider automating white-collar work. After all, there's a huge amount of excel-monkey work that can be trivially automated with scripts and I've done stuff like that before. But then I realise there's not even a job title for this sort of work, nor are there any firms in my country doing stuff like this. There's simply no demand whatsoever for process automation (I'm expressly not talking about automation engineers in manufacturing etc.)
It's not hard to see why. No-one's going to automate themselves out of a job, nor are managers going to automate all the people they manage out of a job because then they're also redundant. Often labour-saving innovations are brought-in by upstarts but business dynamism is low so there's not a lot of that happening. I can almost guarantee that a bank circa 2050 will look a lot like a bank now, short of some runaway superintelligence completely reconfiguring society.