Apply on Employer Site

City of Aurora · 19 hours ago

Police Crime and Data Analyst

Aurora, CO

Full-time

Onsite

Entry, Mid Level

$66K/yr - $83K/yr

2+ years exp

The City of Aurora is seeking a dedicated Police Crime and Data Analyst to join their team. This role involves performing crime analysis and developing products to support the Aurora Police Department's Crime and Data Analysis efforts, working closely with various sections to optimize reporting and implement automation.

GovernmentLaw EnforcementPublic Safety

No H1B

U.S. Citizen Only

Responsibilities

Use a variety of computer applications, electronic spreadsheets, mapping software, word processing, and statistical applications to conduct crime and data analysis

Identify and collect data factors using a variety of police reports to track patterns, forecast trends, and report actionable findings that inform resource deployment

Extract, transform, and load (ETL) data from a variety of sources that can be used for tactical and strategic crime analysis

Create, maintain, and develop high quality dashboards that provide easy to understand analysis on a variety of crime related topics

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

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 Executive and District Command, Business Intelligence, 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

Respond to ad hoc requests for information

Performs other related duties as assigned

Qualification

Data analysisSQLMapping softwareETL processesMicrosoft OfficeMultitaskingCritical thinkingCommunication skillsAttention to detailTeam collaboration

Required

Bachelor's Degree in Computer Science, Data Science, Information Systems, Statistics, Business Administration, or other related field

Two (2) years of experience as a data analyst

Experience related to the use of data, relational databases, software and technical troubleshooting

Demonstrated knowledge of working with SQL

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

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

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 security clearance due to handling of sensitive information

NCIC/CCIC certification preferred

Preferred

Two (2) years of experience as a crime researcher or crime analyst working with data related to public safety (law enforcement, court or corrections) or comparable

Experience conducting administrative analysis and compiling statistics

Familiarity with commonly used law enforcement or public safety software, applications and databases

Ability to write queries against data sources that allow forward-looking strategic insights for our District and Department to use in decision making