Police Crime Analyst - Variable Hour

JOB LOCATION 15001 E Alameda Pkwy Aurora, Colorado 80012-1554 Cit y  of Aurora ,  Colorado It is an exciting time to work for the City of Aurora, we're growing and looking for dedicated and collaborative individuals to join our team of talented and valued employees. Excellent organizations have a set of principles, or core values, that are used to implement their mission and vision. Those values represent the touchstone for the organization, guiding the decisions of the individuals and the organization. At the City of Aurora, we demonstrate our excellence by modeling the CORE 4 Values of:   Integrity ,   Respect, Professionalism , and   Customer Service , and we welcome all who share these values to apply. Why Work for Aurora? Make a difference in the lives of real people every day Diverse community Competitive total compensation package Well-Funded General Employees Retirement Plan Light rail station minutes away On-site fitness center and overall employee well-being programs Internal educational programs to assist with career advancement Access to innovation workspaces PRIMARY DUTIES & RESPONSIBILITIES Hiring Range for this position is $34.45 - 43.06/Hourly. This is classified as VHBE (Variable Hour Benefit Eligible), where the selected candidate will work an average of 40 hours per week.  The selected candidate will be eligible to elect Medical Benefits as well as accrue paid time off and receive 11 paid holidays. The deadline to submit applications is September 30th, 2026. Please note, the City of Aurora will conduct ongoing screenings of applications on a first-come, first-serve basis; as soon as we determine a qualified pool of applicants exists, this position may be closed without notice. The Crime Analyst identifies crime patterns and trends, identifies, collects, and evaluates case information and intelligence in order to conduct research that assists police with the apprehension of offenders, clearance of cases, and suppression or prevention of further criminal activity. PRIMARY DUTIES & RESPONSIBILITES:   Use a variety of computer applications, electronic spreadsheets, mapping software, word processing, and statistical applications to conduct analysis.    Use EXCEL macros or other similar editing techniques on crime data to analyze, format, simplify, and present findings.   Identify and collect data factors using a variety of police reports to track patterns, forecast trends, and report actionable findings that inform resource deployment   Query public safety databases (RMS, NCIC/CCIC, Accurint, Lumen, Linx, etc.) to collect, analyze, interpret, evaluate and disseminate crime, arrest, intelligence, operational, and procedural data using modern data and program analysis techniques.    Conduct analysis relating to modus operandi, spatial, temporal, and statistical factors.    Correlate new information with existing information to identify emerging, evolving or existing patterns, series and hotspot activity.    Attend team meetings to receive and provide relevant information.   Work to identify new solutions to connect data to strategic decision-making and resource deployment.   Prepare real time analysis, monthly summaries; publish and disseminate said materials as requested.    Clearly present information about analysis and findings to internal and external partners who do not have a background in analysis .   Compile, create, and present materials used for problem-solving meetings to inform police executives, consent decree monitors, and other entities as needed.   Prepare PowerPoint presentations, maps, graphs, charts, tables and other illustrative devices that organize and simplify information to support investigations, police administration, and quarterly annual reports.   Utilize ArcMAP/ArcPRO to prepare a variety of map products as well as to conduct geospatial analysis on public safety data.   Connect with data analysts and crime analysts internal and external to the city to facilitate a cooperative relationship that enhances support of public safety and facilitates and furthers investigative leads for law enforcement.    Participate in the maintenance of data integrity, validate results, identify potential issues and use appropriate strategies to resolve discrepancies or report issues.   Write queries to extract, clean, and validate data for reports, charts, and graphs.   Respond to ad hoc requests for information.    Conduct research and analysis on subjects’ histories, associates, group affiliations, addresses, vehicles, etc.   Monitor and collect data and intelligence    Assume additional duties as assigned.   MINIMUM QUALIFICATIONS & WORKING CONDITIONS Education:    Bachelor's Degree in Computer Science, Data Science, Criminal Justice, Statistics, Mathematics, Information Systems, Statistics, Actuarial Science, Business Administration, or other related field with course work in crime analysis, research methods, and statistics.     Experience:     Two (2) years of experience as a crime and or intelligence analyst at a municipal police department, sheriff’s office, or federal law enforcement agency.    Technical skills and experience related to the use of data, relational databases, software and technical troubleshooting.     Preferred Experience:   Experience conducting administrative, tactical, and or investigative analysis and compiling statistics.   Experience using ACCESS, SQL or SSRS to design and build relational database queries.   Familiarity with commonly used law enforcement or public safety software, applications and databases.   Experience with open-source intelligence gathering and creating and maintaining covert profiles.   Creating individual and or organization link charts to connect incidents, people and social networks.   Aptitude of technical skills and technical analysis to troubleshoot technological equipment.   Licenses and Certifications: