Being a poh poh I can tell you a few things.
1. In a general police environment there's not really a place for social workers. Most cops have to portray that role in the course of daily duties so having a background in it would be helpful, but you'd still need to be a cop.
2. Corrections. SW's abound in prisons for therapies and readjustment to life outside of the gray bar hotel. A SW background would be helpful for parole and probation officers. I don't know what the typical LCSW salary is, but I've seen our prisons advertise around 45k / yr for them which is a good living in AR particularly in the areas where the majority of the prisons are located - i.e. B.F.E.
3. I don't see a social work background as being adequate to be a criminal profiler or do anything with forensics.
4. Juvenile facilities are full of social workers and related individuals so there's an avenue for you also.
In summary, to practice as a social workers the corrections system is your best bet.
I don't see how the CIA or any other federal agency outside of the BOP could put you to work. The DOD would be a good place for you. Apply to a branch of the military for either civilian work, OR become a military officer.
I don't see how you couldn't find a position within the FBI as even something fancy. As far as the CIA is concerned, unless you have extensive military experience with some sort of specialized skill, i.e. speaking Arabic, or you have a PhD in a professional field, you will not get in. As far as the FBI is concerned, I don't see why not. I am pursuing my MSW right now and will be immediately applying to the FBI. If you are someone who has their MSW you obviously know that you can Diagnose out of the DSM, this is a crucial piece to criminal profiling. With that being said you can't be a "criminal profiler" in the FBI without paying your dues. You have to apply to be a Special Agent, do 3 years, and then apply.
ArkansasRanger, I hate to see the Social Work degree downplayed so much. We have a lot of required coursework which of course vary from college to college, but are not limited to, Abnormal Psychology, Victims of Violence and Crime. If you go onto the fbijobs.gov website, there are Victim Specialist positions right now. What matters in the Federal Sector as far as criminal experience is not just 5 years experience as a beatcop and a criminal justice degree. They want diversified people. I have extensive experience in the active duty military with counter-terrorism, Bachelors in Social Work with Criminal Psychology, Minor, and finishing up my Masters of Social Work.
Acidicspecies, Just remember, don't walk in their thinking of what the college you went to told you that you are qualified for. As a social worker, you are an expert "talker", it is what we do for a living. Think about what you have talked about with your clients and integrate that into your resume.