Hi there - and welcome to the forum. Boston is my old stomping ground back in the US, so I hope your relocation goes well.

As to the visa situation, I guess anything is possible with those big international companies. Normally, for a company to sponsor you means that they are giving you a job - and getting you a working visa (normally an H1-B, which is a non-immigrant visa). The trailing spouse comes over on a dependent visa, and generally doesn't have working privileges.

A green card is an immigrant (i.e. permanent) visa - harder to get, but with working privileges right from the get-go. If that's what's on offer, it's a great deal - but do check first to make sure what sort of visas they are arranging.