Crime Data Analyst

The City of Wichita is NOT an E-Verify Employer.

Distinguishing Features of Work

Performs the following types of crime analysis: tactical, strategic, and intelligence. Performs analytical processes to provide timely and pertinent information regarding crime patterns, crime trends, and crime correlations. Collects, analyzes, presents and disseminates information regarding actual and anticipated criminal activity. Assists department staff in the development, implementation, and evaluation of problem-oriented policing projects and current department performance.

• Note: Submittal of a current resume and an analytic work product that demonstrates ability to query, clean, analyze, and/or present data is encouraged but optional.
• Additionally, if selected for an interview the process will include completion of an exam.
  
  

The days and hours for this position: Monday-Friday, 8:00am-5:00pm

Bargaining Unit: Employees Council

• Posting may close at any time **
  
  

Examples of Work Performed

• Extract and analyze data from the records management system relating to criminal activity and overall department performance (utilizing SAP Crystal Reports, Microsoft Access & Excel, and ESRI ArcGIS). Instruct and assist with response to requests from department members in areas related to crime analysis and statistics.
• Analyze data retrieved from computer searches of internal and external databases, police department reports and various open source documents to identify crime, crime patterns, relationships, and trends.
• Utilize data to forecast future crime occurrences and develop target profile analysis
• Provide direct support for the administrative strategic and tactical functions of the police department
• The employee must work the days and hours necessary to perform all assigned responsibilities and tasks
• Provides strategic criminal analysis to mid­level and field commanders for strategic deployment of police resources
• Works in close collaboration with field commanders to develop specific analysis on crime trends and criminal enterprises, often assisting in the development of suspect lists and recommended courses of action.
• Research available databases, such as pawn shop lists, driver's license databases, mug shot databases, etc., for the compilation of research data
• Works directly with investigations and patrol sections to assist with criminal investigations and criminal interdiction efforts
• Develop/revise processes and products to increase efficiency, knowledge, and better direct resource deployment
  
  

Requirements of Work

• Must be able to lift/move items such as boxes of files weighing up to 50 pounds
• Must be able to conceptualize requests for which there are no previously produced solutions or templates to follow.
• Needs sound judgement to evaluate situations and problems objectively, then make informed decisions.
• Needs to be a team player by actively listening to coworkers, respecting ideas, and aiming to improve products or processes at hand.
• Must be able to use a multi-line phone, computer, and other office equipment
• Requires the ability to communicate clearly both verbally and in writing.
• Must possess or be able to obtain a Kansas Driver's License.
• Must not be impaired from testifying credibly in a court of law or swearing to an affidavit
• An employee shall not pose a direct threat to the health or safety of other individuals in the workplace
• May work rotating shifts, (RDOs) regular days off and weekend work may be required On-call work outside of business hours may be necessary.
• Must successfully pass polygraph and police background prior to employment
  
  

Required Experience And Training

Required Experience and Training

• Associate’s degree or current enrollment in a bachelor’s program with at least 60 completed credit hours in Criminal Justice, Criminology, Computer Programming, Social Sciences, Data Science, GIS, Geography, Business Analytics or Mathematics.
• Six months of experience using computer data systems to extract, clean, and analyze datasets for data analysis, reporting, or performance evaluation, including statistical analysis, data dashboards, and mapping software such as ArcGIS to create crime maps, conduct spatial analysis, and identify geographic crime trends.
• A valid Kansas Driver’s License.
• Must be legally authorized to work in the United States without the need for sponsorship.
• Applicants must attach a copy of their transcript to their application to be considered. Transcripts should confirm that the degree meets the specific educational requirements for the position. Applications submitted without an attached transcript will not be processed.
  
  

Preferred Experience And Training

• Bachelor’s degree in criminal justice, Criminology, Computer Programming, Urban Studies, Social Sciences, Data Science, GIS, Geography or Business Analytics.
• One year experience in crime analysis and/or data analysis.
• One year of experience using ArcGIS, Crystal Reports, Access, Excel, SQL, Python, or R to extract, analyze, and visualize data, including creating crime maps, custom reports, and data visualizations to support crime analysis and decision-making.
  
  

Offers of employment are contingent upon passing a pre-employment physical, which includes drug screening, and upon satisfactory evaluation of the results of a criminal record check.

Applicants have rights under Federal Employment Laws. Please find more information under the following links:

https://www.dol.gov/sites/dolgov/files/WHD/legacy/files/fmlaen.pdf

https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf

https://www.dol.gov/sites/dolgov/files/WHD/legacy/files/eppac.pdf

CITY OF WICHITA

Full-time Employee Benefits

• VACATION - Most employees with less than five years employment earn 10 days of vacation per year. After five years, accrual rates increase at varying rates to varying maximums, depending on work schedule and/or union representation. Employees can accumulate and carry forward up to 240 hours each year.
• HOLIDAYS - There are eleven paid holidays. Employees also receive one Personal Holiday that is granted after the first six months of employment.
• SICK LEAVE - Sick leave accrual begins at one-half day per month. After five years, sick leave accruals are one work day per month. Employees can accumulate and carry forward all unused sick leave each year. Employees who use 24 hours (3 days) or less of sick leave in a calendar year earn a "Well Day." An additional "Well Day" can be earned following a year of perfect attendance.
• HEALTH INSURANCE – UMR / United Healthcare provides two levels of medical and prescription drug plans. Both medical plan are PPOs and do not require selecting a physician or referrals for specialty care. Both medical plans include Teladoc virtual care (primary care/mental health benefits at no charge), Dario healthy living programs, and VSP Vision benefits. Pre-tax premium deductions are offered. The City contributes 80% of the premium cost towards medical, prescription drug and vision insurance.
• DENTAL INSURANCE - Two Delta Dental plans are offered – Preferred and Traditional. The Delta Preferred plan requires using a dentist from a smaller network for a lower premium. The Delta Traditional plan allows use of any dentist, although benefits are higher using a dentist from the large Delta network. Benefits under both plans are the same (with the exception of some Orthodontic benefits) Pre-tax premium deductions are offered.
• LIFE INSURANCE – Low-cost voluntary term life insurance is available. Employees pay one-third of the cost. The amount of Basic Life coverage is two times annual pay up to a determined maximum amount. Dependent coverage is available at $20,000 spouse / $10,000 child(ren) for an additional $0.14 per pay period. Accidental death and dismemberment coverage is included. The plan is through MetLife.
• SUPPLEMENTAL LIFE – Additional voluntary employee-paid term life insurance is available from MetLife at low group rates. Participation in Basic Life is required. The Life Insurance plans are portable.
• LONG-TERM DISABILITY INSURANCE– The voluntary employee-paid group disability plan from MetLife provides 60% of pre-disability income for injury or health related disabilities. Premiums are determined by income and age.
• VOLUNTARY ACCIDENTAL DEATH & DISMEMBERMENT – Voluntary employee-paid AD&D from MetLife offers coverage for accidental death and dismemberment.
• RETIREMENT - The City offers two retirement plans - Wichita Employees (WER) Plan 3, and Commissioned Police & Fire Plan C-79. The WER plan is a defined contribution plan; Police & Fire is a defined benefit plan. Both are contributory - employees and the City share the cost.
• FLEXIBLE SPENDING ACCOUNTS – Employees may elect to make FSA pre-tax deductions for dependent care and/or unreimbursed medical expenses, reducing the cost of these expenses by eliminating taxes on the amount deducted.
• LONG-TERM CARE INSURANCE – This plan from UNUM offers facility and home care benefits for employees, spouses, and some other family members. Several options for benefit amount and duration, and specific plan features, are available.
• MORE BENEFITS & SERVICES
  
  

Deferred Compensation Investment Program

Employee Discounts and Wichita Employee Association (WEA)

Bereavement Pay

Employee Emergency Assistance Fund

Voluntary Shared Leave Program

Training Programs

Longevity Pay

Credit Union

Employee Assistance Program (EAP)

Injury Leave (on-job injury)

Community Volunteer Events

01

Which of the following best describes your educational background related to Crime Data Analyst?

• I have an Associate's degree or higher in Criminal Justice, Criminology, Computer Programming, Social Sciences, Data Science, GIS, Geography, Business Analytics or Mathematics. I have attached my transcript and understand that failing to do so will make my application incomplete.
• I am currently enrolled in a Bachelor's program and have completed at least 60 credit hours in Criminal Justice, Criminology, Computer Programming, Social Sciences, Data Science, GIS, Geography, Business Analytics or Mathematics. I have attached my transcript and understand that failing to do so will make my application incomplete.
• I have an Associate's degree or equivalent credits, but in a different field not listed.
• I do not have an Associate's degree, nor have I completed 60 credit hours in the listed fields.
  
  

02

I have the following years of experience using computer data systems to extract, clean, and analyze datasets for data analysis, reporting, or performance evaluation, including statistical analysis, data dashboards, and mapping software such as ArcGIS to create crime maps, conduct spatial analysis, and identify geographic crime trends.

• 0 to 5 months of experience
• 6 months - 1 year of experience
• 2 - 3 years of experience
• 4 years of experience
• I do not have any experience using computer data systems to extract, clean, and analyze datasets for data analysis, reporting, or performance evaluation, including statistical analysis, data dashboards, and mapping software such as ArcGIS to create crime maps, conduct spatial analysis, and identify geographic crime trends
  
  

03

I have following years of experience in crime analysis and/or data analysis.

• less than 1 year of experience
• less than 1 year - 1 year of experience
• 2 - 3 years of experience
• 4 years of experience
• I do not have any experience in crime analysis and/or data analysis.
  
  

04

I have following years of experience using ArcGIS, Crystal Reports, Access, Excel, SQL, Python, or R to extract, analyze, and visualize data, including creating crime maps, custom reports, and data visualizations to support crime analysis and decision-making.

• less than 1 year of experience
• less than 1 year - 1 year of experience
• 2 - 3 years of experience
• 4 years of experience
• I do not have any experience using ArcGIS, Crystal Reports, Access, Excel, SQL, Python, or R to extract, analyze, and visualize data, including creating crime maps, custom reports, and data visualizations to support crime analysis and decision-making.
  
  

05

Please describe your knowledge, skills and abilities using ArcGIS. Describe functions of ArcMap, ArcPro, ArcOnline, or ArcCatalog that you are familiar with, and any projects you have completed using this software.

06

Please describe your knowledge, skills and abilities using SQL. Describe work you have done querying information from live, relational databases. If you've used SQL software in the past, such as MS Access, Crystal Reports, Tableau, Power BI, MySQL, etc. please specify which software you work with, your level of ability, and describe any projects you have completed using this software.

07

Please describe your knowledge, skills, and abilities using automation software or creating automated processes for querying, analyzing, and presenting data. This may include macros, MS Task Scheduler, creating live dashboards, or other automation techniques. Please describe which software you work with, your level of ability, and describe any projects you have completed using this software.

08

Describe any coding languages you are familiar with, your level of coding ability, and describe any projects you have completed using a coding language.

09

I Have a Valid Driver's License

• Yes
• No
  
  

10

Even if expunged from your criminal history, have you ever been convicted as an adult or adjudicated as a juvenile in any court of a felony crime?

• Yes
• No
  
  

11

I am legally authorized to work in the United States without sponsorship.

• Yes
• No
• Required Question