A friend basically had exactly this for a while. He was an analyst at a big company who primary needed to run manual analysis on excel spreadsheets.
He learned a bit of programming and found a way to automate it almost it entirely.
He enjoyed the extra free time for a few months before feeling guilty telling management. They ended giving him a small promotion and cutting the team by 1/2.
Maybe you should try to find a non-tech analyst role somewhere. So long as you keep the automation to yourself, maybe it will work out.
> ...before feeling guilty telling management. They ended giving him a small promotion...
Ah, a sane/responsible work environment that appropriately values people.
I'd be much the same in terms of not being able to hide the automation I'd done. I truly wonder how to filter for environments that would respond similarly to this story...
He learned a bit of programming and found a way to automate it almost it entirely.
He enjoyed the extra free time for a few months before feeling guilty telling management. They ended giving him a small promotion and cutting the team by 1/2.
Maybe you should try to find a non-tech analyst role somewhere. So long as you keep the automation to yourself, maybe it will work out.