Pros: tuition benefits (for yourself and your children)
Cons: salary closer to a non-profit than a corporation
Each Dept/Group/School/Division/Etc. operates, seemingly almost, autonomously. There are plenty of great entities within the University to be employed by. If you discover you have chosen incorrectly, at least you'll be an internal candidate when looking for other opportunities, within the relatively massive Columbia University system.