What are the working conditions like for a CSI?

Typically, a crime scene investigator will work standard hours – Monday through Friday from 8:00 a.m. – 5:00 p.m. Most police departments will require a CSI to also work standby hours. This means that during those hours, they are available at all times to respond to calls. A crime scene investigator must be ready to respond to emergency calls whenever necessary.

In addition to processing crime scenes, a CSI will have to appear in court as an expert witness and be able to explain their findings to a jury.

How can I find out about the specific job description and salary of a CSI in my area?
I want to go to college and major in Criminal Justice. What are the best schools to attend?