I'd like to suggest a more specific career. If you like working with people, consider becoming an hourly financial planner.
About 2004, I was asked to help with my in-laws affairs. This included managing their investments. There was a legal requirement to have a CFP or the equivalent do a one-time review of my plans for their money. I found a guy in Seattle who had just started a business as an hourly fee planner. He had the CFP and for a reasonable amount of money he looked over my plan and gave it his blessing.
Since then, I have kept in touch with this man. His business has been a landslide success. For him it was a second career and now ten years later, he is mostly retiring while leaving behind a firm with 5 planners and a big backlog of people looking for help.
As a fee-planner, he does not manage money. He has no conflicts, and loves his job. I think the firm is charging more than $250 an hour.
So, you could go back to school somewhere that offers the CFP courses. Then, take the tests, and either start on your own, or join another fee-planner.
While most of the folks on this site, and those on the Boglehead site are comfortable doing their own money management, there are millions more who want a little help.
Retired -- 2001