"Death is very common in dreams. Like the tarot card, it is often a sign of a major change in one's life. Moving from one career to another could have triggered this sort of dream. Especially if it was about your previous career.
Does your new position as a drug crime related detective require you to get inside someone's head, as you say? Or not nearly so much as a homicide detective."