Crime Data Analyst

Columbia, MO
Columbia Police Department

Responsible for collecting and analyzing various data to provide accurate, actionable, and timely information for patrol, investigations, and police administration to help achieve a safer community.


$45,901 annual ($22.068 per hour) – $58,469 annual ($28.110 per hour) minimum to midpoint,

Plus shift differential of $0.65 per hour paid for all hours worked between 6 pm and 6 am.




•Utilize various databases and software to analyze and interpret crime data related to crime series, patterns, and suspect profiles.

•Utilize Geographic Information Systems (GIS) to produce computer-generated maps displaying crime activity. Assist in conversion of GIS data to proprietary software format, perform testing of data, and troubleshoot within ESRI or proprietary map software.

•Develop and maintain programs which will collect, collate, analyze, disseminate, and evaluate crime data to discover developing patterns, trends, and changes in criminal activity, including frequency, geographic factors, victims, targets, suspect descriptors, chronological information, suspect vehicle descriptions, modus operandi factors, potential and actual police hazards, and physical evidence information.

•Provide statistical analysis and write complex sequel queries.

•Perform data analysis using crime reports, calls for service, demographic information, and housing data for deployment purposes.

•Create reports on criminal activity, changing crime trends, and patterns. Present analysis to command staff and detectives in order to deploy officers to specific areas of the city experiencing crime series or elevated crime levels.

•Generate ad-hoc queries on CAD and RMS to pull data for annual and impromptu requests.

•Provide guidance to college interns/volunteers who assist in maintaining crime logs.


Educational requirements:

•Bachelor’s degree in Criminal Justice, Computer Science, Math, or related field.

•Minimum of two years relevant experience.

•An equivalent combination of education and experience necessary to perform the essential job functions is acceptable.

•Must maintain a valid driver’s license.

•Must obtain and maintain CPR certification.



•Extensive knowledge of Geographic Information Systems and ESRI ArcGIS/Arc Map and ability to utilize various databases and software to analyze crime data.

•Basic understanding of statistical methods and current policing strategies.

•Ability to analyze data, develop and deliver oral presentations, write reports, research, and work independently.

•Good interpersonal skills and demonstrated sound and accurate judgment.

•Ability to work well within a team environment.

•Excellent verbal and written communication skills.

•Ability to provide crime data in an easily accessible format to employees of the police department and the public.