Redwood City: Crime Analyst #26A-03 (20705916) 1. Please describe your direct experience in crime analysis or related functional areas such as law enforcement data analysis, calls for service analysis, crime trend and pattern identification, intelligence or investigative support, crime mapping (GIS), or performance measurement. Please provide a specific example of an analytical product you developed, such as a crime trend report, hot spot map, bulletin, dashboard, or briefing, and describe how it was used. 2. Please share an example of a time you analyzed crime or calls-for-service data to identify a pattern, series, or emerging issue. Describe the methods and tools you used, the conclusions you reached, and how your analysis supported an operational response, investigative direction, or resource deployment decision. 3. Please describe your experience collecting, validating, and managing data from multiple sources (for example, RMS/CAD systems, spreadsheets, databases, or external data sets). Include your approach to ensuring data accuracy and integrity, and describe a time you corrected or resolved a data quality issue. 4. Please check the box applicable to your level and experience with Excel and/or other related software. Advanced Plus (in addition to Advanced Excel; experience with Tableau, Qlik, Oracle Analytics, R, or other advanced analytics or business intelligence tools). Advanced (combine formulas, use VBA/write macros, create advanced charting, set up advanced conditional formatting). Intermediate (sort, filter, use simple conditional formatting, export/import list or files, create graphs, create pivot tables, create and link formulas, VLOOKUP and HLOOKUP). Beginner (enter text and numbers, add/copy cells, format cells, move/delete rows, create simple formulas). No Experience.
