Pros
Stanford is a great place to work. Its a beautiful campus to come to every day. Depending on the area you work in the work-life balance is really good. If you have a family there are tons of additional benefits you can take advantage of.
Cons
Even though Stanford benefits are great, salary compensation (non academic) is not very good due to accelerating cost of living in the bay area. Stanford does not give performance bases raises. Everyone gets a cost of living adjustment regardless of performance. The last few years the average increase was around 3% which is drastically below cost of living increases across the bay area. Make sure you negotiate a good salary because salary advancement is virtually impossible without jumping around to different positions within the university. Stanford is very 'academically' driven, meaning things are slow to change because of the consensus driven approach that every project has to take. Stanford has moved a lot of the business offices off campus. So you may end up working in a business park and not on the main campus.