The majority of what I've see as of late for postings open to pilots, either off the street or already in company have been LCPs/Seniority list instructors out of MSP (but im sure you could be based elsewhere). Only CPO jobs I've seen are out of NY and the duty pilot work is also entirely out of the OCC in MSP. They do provide good positive space and some solid guarenteed days off for seniority list instructors, and those I've talked to haven't hated the commute / extra pay - some even commuting from ATL.

Aside from that, other "office jobs" are also mostly out of MSP. You might get lucky but I think all of our union jobs (safety, gatekeepers, etc.) are also here in MSP when they work.