I second everything that's been said. Definitely look into your salary:housing cost ratio. It's super, super expensive AND there's a housing shortage. And don't bring your airplane until you have a commitment for a tie-down space. If you're going to be working right in San Francisco, and you can't afford to live there (or can't find housing), you're either going to be taking BART (Bay Area Rapid Transit) from the Peninsula (to the south) or from the East Bay (driving into the city and parking can be a nightmare). If you can find a place to live on the Peninsula, try to get space at San Carlos (KSQL), "try" being the operative word. If the East Bay, your best bet might be Hayward Exec (KHWD), or Concord (KCCR) or Livermore (KLVK). I don't know anything about KHWD or KCCR; I have flown into KLVK and it doesn't seem nearly as crowded as KSQL. KPAO is farther south, but is a nightmare--I doubt you'd find a space there. Hayward and Concord are both on the BART line, San Carlos is not (BART stops well north of San Carlos, but it's not a long drive from there to KSQL). There are other GA airports farther out; if you don't mind driving long distances to fly, you might find places there. I wouldn't recommend Half Moon Bay (KHAF) because of the fog, unless you're IFR capable. The fog is often local, so if you can get in and out, that might be OK (it also is sometimes only a problem for part of the day). Getting to/from KHAF can be a pain, though. Only two ways in and both have a ton of traffic on the weekends.
I've ignored the GA airports in the North Bay (O69, 0Q3, 0Q9, 2O3, KSTS, KAPC) because unless you have no choice, you probably do not want to be commuting across the Golden Gate Bridge. There are buses, but not a lot, and from Santa Rosa, it takes 2 hours.
In summary, good luck finding housing and a tie-down. Seriously, if the commitment is really only a year, I'd recommend leaving your airplane at home and renting for the time being. Actually, unless the opportunity will launch your career into the stratosphere, I'd avoid it entirely. If they provide housing and parking in the city, that's a whole other ballgame, and then all you have to decide is how far you're willing to drive to your airplane.
Full disclosure: I grew up in the Bay Area and, until recently, spent a lot of time there (family). Wild horses could not drag me back there. It's crowded and crazy, but I have to point out that I've been living in rural areas since 1996, and I'm allergic to cities (I also lived in Chicago for awhile). If you are a city person (despite living in the suburbs), none of this will strike you as horrific as it does me.