The City of Kent Police Department is seeking a Data Analyst to manage and report on internal operations, identify systems for data, and support those systems. The role aims to improve law enforcement effectiveness by analyzing data, identifying patterns and trends, and developing recommendations.
Requirements
- Geographic Information Systems, specifically ArcGIS 10.X, ArcPro or above
- Data analysis and business intelligence (BI), including report writing using Excel, Crystal Reports, Yellowfin, ESRI Insight, and/or SSRS
- Relational database models and issues related to database design, performance, and security of SQL Server databases
- Programming concepts and the SDLC model
- Demonstrate competency with the use of programming tools (such as Python, VB Script and SQL code or batch files) and BI Tools (such as Power BI, Yellowfin, ESRI Insight) to mine and visualize data from City of Kent business systems.
- Deliver public safety web and mobile GIS solutions in partnership with GIS application developers using Esri (ArcGIS Online), ArcGIS Enterprise, and existing software being utilized by the City of Kent.
- Implementing, maintaining, and working within GIS SDE SQL Server data management systems.
Responsibilities
- collect, manage, and report data about the internal operations and processes of the Police Department, as well as identify systems where data exists and support those systems.
- police-related data collection and database design, end-user support, application development, user interface development, and integration between Geographic Information System (GIS) and other police related software
- performing statistical and analytical research for the Police Department; and preparing functional descriptions of new and revised system changes including application specifications, user interfaces, data source documentation, database design, data flow diagrams, project costs, schedules, planning, and reporting resource requirements.
- Analyze raw data and develop recommendations to improve law enforcement effectiveness based on interpretation of patterns and trends in police responses.
- Troubleshoot areas of poor performance and identify effective solutions to resolve issues in immediate future and for longer term, enhance support, and reduce recurring issues.
- Perform advanced geoprocessing, complex geospatial analysis, map compilation, programming, and project management for the purpose of contextualizing Police operations data.
- Design and maintain publicly available open data that provides transparency of Police data, analyses, and findings in collaboration with the Crime Analyst and other City subject matter experts.
Other
- This is highly technical work involving police-related Geographic Information System (GIS) database design, end-user support, application development, user interface development, and integration between GIS and other software.
- Are you an experienced analyst who can troubleshoot areas of poor performance and identify effective solutions to resolve issues in both the immediate future and over time, while also enhancing support and reducing recurring issues?
- The Police Data Analyst position requires someone who is passionate about analyzing raw data and developing recommendations to improve law enforcement effectiveness based on the interpretation of patterns and trends in police responses.
- Please note that you must attach your cover letter and resume to your application in order for your application to be considered* complete.
- This is a regular, full-time position that is benefited and represented by AFSCME.
