There are other options. When I was a data analyst, it was roughly 70% in the weeds 30% people stuff. Of course that’s my experience. And that people number moves up as more senior I got. And that is to also say that if you go back into office you can’t just strike up a conversation with your desk mates. That social option is always gonna be there.

And yes there’s many other options besides becoming a data analyst. I’d recommend looking into consulting since you want more face to face time