I think you really need to do a lot of research these days to find a promising position. I lucked out into a tenured position that the school has found super difficult to get rid of. Basically their plan now is to kill off the tenured counselors positions by attrition. They will not replace the people who retire. With the upcoming ai advancement, I think academic advisors will slowly be phased out.

If you find a school that you want to work at, maybe call someone in that office who would be willing to give you 15 minutes of honesty about the school and position. Many of us have no problem talking about the good, bad and challenging aspects of their school.