Will taking a temporary staff position between post-docs end my academic (tenure track aspirations) career
I would think it's not advisable to take this position unless you already have a research position lined up for a local university in the near future (under a year at least). At least in my field, getting tenure anywhere at all is hard. Unless you are particularly in demand (which seems unlikely from your described position so far), if you want tenure you have to put that above location (even to some extent country, not just city), and then apply at every opportunity to move to something where you want, in the hope that one day you will get it. It's not a good situation, but there are too many people for the number of jobs available.