What is it like to live in Albany as a single working professional?

I am single 40m, and I potentially have an offer with the location being Albany, I work in consulting.

I want to find out what life is like in Albany.