Although I am not really certain about the current prospects, the GSPIA website has a fairly extensive list of alumni careers here: http://www.gspia.pitt.edu/Alumni/CareerList/tabid/125/Default.aspx
I don't know what kinds of jobs that most grads get, but a Security and Intelligence studies major could probably get a job with a some sort of government agency or intelligence contractor as an analyst. A wide variety of corporate opportunities exist as well.