Crime Analyst & Technical Lead, UC Public Safety

Job Overview

Perform professional level technical and analytical support in the daily operations of the University of Cincinnati Police Division. Assist all Division personnel in a timely manner in the collection, collation, analysis, and dissemination of the data collected including, but not limited to, crime, arrests, calls for service, and traffic data.

Essential Functions

• Analyze data from various sources and makes detailed analyses to determine specific crime patterns. Assist the Police Division’s staff in selecting and accessing computerized information through the Regional Computer Center that will aid them in their replies to citizens' questions and complaints. Identify and report statistical data related to officer performance. Work with Command Staff to identify, analyze and assess critical problem-solving projects.
• Design computerized reports for Division use from data generated by the Computer Aided Dispatch (CAD) system in the Communications Section. Provide requested information and assists media personnel through the Public Information Office with the requested information.
• Confer with Division and surrounding law enforcement personnel to gather and exchange information for analysis and presentation. Assist Division members in problem solving using available data. Provide technical level administrative crime analysis assistance to Command Staff. Provide analysis of crime, arrests and calls for service in support of Police Division mission and goals. Collect, compile and analyze information from various sources on a variety of special topics. Compile reports and generate maps.
• Maintain the continual development, creation, maintenance, and enhancement of the Public Safety Portal (PSP) intranet-based application data warehouse with automatic data feed and a front-end for user interaction.
• Maintain the continual development, creation and maintenance of automated administrative processes, including police inspections, police contact cards, police & administrative documents, daily police lineups, and the problem-solving tracking system.
• Maintain the continual development and creation of the risk assessment desktop application for on-campus events that allows users to create a comprehensive list of needs based on event characteristics.
• Maintain the continual development and automation of several processes including emails for dispositioning early warning system documents for department human resources, daily emails detailing the City of Cincinnati Police Department crime reports in the university area and emails to university stakeholders detailing reported incidents related to mental health.
• Prepare written materials to communicate Division activities and programs for internal and external distribution. Act as a resource to persons, including citizens with inquiries about Division statistics, activities and services.
• Compile, calculate, maintain, and review Division monthly executive information summary.
• May provide direct and/or indirect supervision to exempt and non-exempt staff (i.e., hiring/firing, performance evaluations, disciplinary action, approve time off, etc.).
• Perform related duties based on departmental need. This job description can be changed at any time.

Required Education

• Bachelor’s Degree in Criminal Justice, Criminology, Public Administration, Computer Science, Police Science, Mathematics, Statistical Analysis, Information Management, or related field.
• Seven (7) years of relevant work experience and/or other specialized training can be used in lieu of education requirement.

Required Trainings/Certifications

• Must be able to obtain certification to gain access to NCIC, LEADS, and RCIC (national, state, and regional crime systems).
• Must pass background investigation and no criminal record.
• Must have a current valid state operator’s license with acceptable driving record.

Required Experience

• Must have a minimum of 1 year of experience in crime analysis/research and/or intelligence analysis/research
• Experience with software development, database administration and scripting for automation.

Additional Qualifications Considered

• Four (4) years of related experience in law enforcement
• Knowledge of and experience with the following: PHP, HTML, CSS, JavaScript, MS SQL Server, Oracle, PostgreSQL, Node/ElectronJS, Python, R, Bash, Powershell, Windows Server 2012 thru 2021, LINX (ubuntu), MAC OS.

Physical Requirements/Work Environment

• Sitting - Continuously
• Repetitive hand motion (such as typing) - Continuously
• Hearing, listening - Often
• Talking - Often
• Standing - Often
• Walking - Often
• Climbing stairs/ladders - Often
• Bending - Seldom
• Stooping - Seldom
• Kneeling, squatting - Seldom
• Crouching - Seldom
• Reaching overhead - Seldom
• Lifting - up to 20 pounds - Seldom