Police Crime Analyst - Variable Hour

City of Aurora; United States; On-site; USD 98,879,000 - 123,196,000; Full time

Benefits offered by this job

Generous paid leave

Public sector pension plan

On-site fitness center

Education and training programs

Job summary

The City of Aurora is seeking a Crime Analyst to identify crime patterns and support law enforcement with data-driven decisions. You will analyze data, prepare maps and dashboards, and present actionable findings to police leadership and partners.

Responsibilities include querying multiple databases, building reports, and delivering real-time insights. A background in statistics or data science plus two years in crime analysis is preferred. Colorado location; competitive benefits.

Qualifications

• Bachelor's degree in a related field with coursework in crime analysis, research methods, and statistics.
• Two years of experience as a crime or intelligence analyst at a municipal police department, sheriff’s office, or federal agency.
• Technical skills with data, relational databases, software and troubleshooting.

Responsibilities

• Identify crime patterns and trends to assist police with apprehension and prevention.
• Use Excel macros or similar tools to analyze, format, and present crime data.
• Query RMS/NCIC/CCIC, Accurint, Lumen, Linx and other databases to collect data for reports.
• Prepare real-time analyses and monthly summaries; create maps, graphs and charts.
• Prepare PowerPoint presentations and other visuals for investigations and reports.
• Maintain data integrity and resolve discrepancies.

Skills

Data analysis

Statistics

Critical thinking

Presentation skills

Education

Bachelor's Degree in Computer Science

Bachelor's Degree in Data Science

Bachelor's Degree in Criminal Justice

Bachelor's Degree in Statistics

Bachelor's Degree in Mathematics

Bachelor's Degree in Information Systems

Bachelor's Degree in Actuarial Science

Bachelor's Degree in Business Administration

Tools

ArcMAP/ArcPRO

ACCESS

SQL

SSRS

Job description

JOB LOCATION 15001 E Alameda Pkwy Aurora, Colorado 80012-1554 City 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?

• 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. The Crime Analyst uses a variety of computer applications, electronic spreadsheets, mapping software, word processing, and statistical applications to conduct analysis. The analyst uses EXCEL macros or other similar editing techniques on crime data to analyze, format, simplify, and present findings. The analyst identifies and collects data factors using a variety of police reports to track patterns, forecast trends, and report actionable findings that inform resource deployment. The analyst queries 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. The analyst conducts analysis relating to modus operandi, spatial, temporal, and statistical factors. The analyst correlates new information with existing information to identify emerging, evolving or existing patterns, series and hotspot activity. The analyst attends team meetings to receive and provide relevant information. The analyst works to identify new solutions to connect data to strategic decision-making and resource deployment. The analyst prepares real time analysis, monthly summaries; publishes and disseminates said materials as requested. The analyst clearly presents information about analysis and findings to internal and external partners who do not have a background in analysis. The analyst compiles, creates, and presents materials used for problem-solving meetings to inform police executives, consent decree monitors, and other entities as needed. The analyst prepares PowerPoint presentations, maps, graphs, charts, tables and other illustrative devices that organize and simplify information to support investigations, police administration, and quarterly annual reports. The analyst utilizes ArcMAP/ArcPRO to prepare a variety of map products as well as to conduct geospatial analysis on public safety data. The analyst connects 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. The analyst participates in the maintenance of data integrity, validates results, identifies potential issues and uses appropriate strategies to resolve discrepancies or report issues. The analyst writes queries to extract, clean, and validate data for reports, charts, and graphs. The analyst responds to ad hoc requests for information. The analyst conducts research and analysis on subjects’ histories, associates, group affiliations, addresses, vehicles, etc. The analyst monitors and collects data and intelligence. The analyst assumes additional duties as assigned.

MINIMUM QUALIFICATIONS & WORKING CONDITIONS

• Bachelor's Degree in Computer Science
• Bachelor's Degree in Data Science
• Bachelor's Degree in Criminal Justice
• Bachelor's Degree in Statistics
• Bachelor's Degree in Mathematics
• Bachelor's Degree in Information Systems
• Bachelor's Degree in Statistics
• Bachelor's Degree in Actuarial Science
• Bachelor's Degree in Business Administration
• or other related field with coursework 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, 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

• NCIC/CCIC certification preferred

This position may require the incumbent to occasionally use personal equipment (e.g. vehicle, cell phone, tools, etc.) in the course of their employment.

Knowledge

Knowledge of analytical skills and techniques used for data analysis. Knowledge of Microsoft Office programs and relational databases. Knowledge of mapping software, intelligence applications and open source sites used to identify pertinent information and conduct analysis.

Abilities

• Able to establish and maintain working relationships with others in law enforcement and intelligence communities, City of Aurora employees and its citizens.
• Willing and able to proactively and independently learn new software, databases, and analytical techniques.
• Able to maintain confidentiality.
• Able to communicate effectively both orally and in writing; accurately analyze data; and make clear, concise and actionable presentations or graphics.
• Able to uphold inter and intradepartmental practices, standards and policies.
• Ability to pass a thorough background investigation and obtain a Secret security clearance due to handling of sensitive information.

Skills

• Skilled using strategies of organization, multitasking and prioritization to quickly assess, analyze and contend with a variety of situations.
• Skilled in conducting analysis, compiling statistics and presenting findings.
• Skilled in the use of personal computers, databases, software programs and applications.
• Applies critical thinking skills, maintains attention to detail and is adaptive when new information is presented.

Physical Demands

Sedentary physical work requiring ability to lift a maximum of 10 pounds Occasional lifting, carrying, walking and standing Vision to analyze data and read and interpret reports, documents and other written information Hand/eye coordination for operation of computer keyboard Speech communication, hearing and listening to maintain communication with employees and citizens

Work Environment

Works in a clean, comfortable environment.

Equipment Used

Personal computer and office equipment.

The city of Aurora will implement furlough days (unpaid days off) for most employees in 2026. The scheduled furlough dates are January 16, April 10, July 2, and December 24.

For Veterans preference: Please show all of your employment history, including military service and related documentation (DD214) on the application.

The City of Aurora is an equal opportunity employer.

We are required by state and federal agencies to keep certain statistical records on applicants. It will not be used in any way to discriminate against you because of your sex, race, age, sexual orientation, creed, national origin, disability or military status, gender identity, unless related to a bona fide occupational qualification as defined by the Colorado Civil Rights Commission and the Equal Opportunity Commission.

Despite the changes in Colorado law, the City of Aurora maintains a drug-free workplace. A positive test of marijuana is grounds for disqualification and ineligibility for employment with the city for one year or termination once hired.

Drug Testing, Thorough Criminal Background Check, and Employment References: As a condition of employment, all applicants selected for employment with the City of Aurora must undergo a thorough criminal background check. Applicants selected for safety-sensitive positions are required to complete and pass a drug screening as a condition of employment. Safety sensitive positions include Civil Service positions within Police and Fire Departments and positions where their job responsibilities have direct and substantial responsibility that would impact the health and safety of others. Employment references will be conducted on finalists for City of Aurora vacancies.

Additional Benefits

• Rewarding public sector work impacting a large and diverse community
• Growing city and employee population
• Competitive total compensation package
• Rich benefits package with low employee costs
• Generous paid leave program 100% funded
• Employee and Family Care Leave Program
• Retirement pension plan and 457b plans available
• Subsidized recreation center pass, on-site fitness centers and wellness programs
• Continued education and career advancement opportunities
• Learn more about city of Aurora benefits

Know your rights! The city of Aurora is an equal opportunity employer. No applicant for employment or employee shall be discriminated against because of age, race, color, sex, gender identity, sexual orientation, religion, creed, national origin, ancestry, disability or military status. The city shall develop and maintain a plan for diversity. Through its staff, the city shall periodically analyze its employment related practices and its plan for diversity to ensure compliance with this policy.

If you need assistance or reasonable accommodation for completing this application, please feel free to contact our office at: 303.739.7225 or visit us at 15151 E. Alameda Pkwy., Suite 3500, Aurora, CO 80012.