If it's a new job, I would imagine he would eed to get an H-1B (specialty occupation visa), although there may be other catergories that he is eligible for depending on the job and your personal situation.
Have a look at london.usembassy.gov/work.html and read through the general process. Also have a look at the Immigrant visa link, to see if you are eligible for an of the categories there.
There must be quite a few Mumsnetters who have been through the H-1B process, so they are the best people to provide insight. One thing to be aware of is that the process is multi-step, with the first one being certification from the Department of Labor which the employer applies for.
Away from visas, do you know if the employer frequently employs people from overseas and do they have a support system for your move and settling in, or are you basically on your own? What is their relocation package? This kind of information will be important to you in finding housing and determining what to do with your house in the UK.
Normally, if your assignment is temporary (as it is with an H-1B visa), you hang onto your house in the UK, renting it out. If you were to sell now, and buy again in a few years time, you would be seriously out of pocket.
Albany is a fine place to live. It is the NY state capitol so will have lots of infrastructure for that. It is fairly close to NYC and Boston, and just a few miles away from beautiful countryside.