Data Analyst

INTRODUCTION:
The Racine Police Department serves the City of Racine in Southeastern Wisconsin with a population of 77,816 people. We are a department that has adopted the philosophy of Community Orientated Policing and is a recognized leader in this area. Our Mission is to Protect Life and Property, Promote Community Partnerships, Build Trust and Serve with Honor.

POSITION PURPOSE:
Data Analysts are an integral part of multi-lateral and multi-jurisdictional concepts that focus on investigations and prosecution of criminals. This data analyst will work closely with the Racine Police Department Crime Analyst, and under the supervisor of the Racine Police Department’s Lt. of Investigations Division. Duties include mining and analyzing data to produce intelligence products that crime analysts and detectives can utilize for investigations. Data Analysts are located all throughout Police Departments in the United States and play a vital role in the identification, collection and visualization of information pulled from various record management systems.

Essential Duties

ESSENTIAL DUTIES:

1. Ability to identify, collect, clean, analyze and visualize data across a variety of different record management systems and data systems. 
2. Knowledge base in various computer-coding languages, R, Python, SQL, etc. 
3. Prepare a variety of analytical and data reports that crime analysts and detectives can utilize for investigations. 
4. Participate in NIBIN Quarterly meetings, report out on data trends. 
5. Work with the ATF on the NESS record management system, to pull data from the exports in the Crime Gun ID’s.
6. Attend staff meetings, trainings and other events for the NIBIN Unit. 
7. Be able to work in a fluid, changing environment that is fast paced. 
8. Provide technical support to the Racine Police Department Crime Analyst. 
9. Be able to provide open source data sets that can be uploaded into IBM I2 Analyst notebook to create spatial network charts of gun crime organizations. 
10. Establish and maintain relationships with all jurisdictions within the unit. 
11. Propose recommendations on policy and procedure for the productivity and efficiency of the NIBIN Unit. 
12. Attends meetings to brief upper command staff on criminal activities within the Racine County area. 
13. High level of proficiency with all Microsoft Office products. 
14. Background knowledge in ESRI ARC-GIS products. 
15. Maintain reliable attendance and be flexible to work overtime when necessary. 
16. These job responsibilities are some of the key requirements, but other related duties are required as well. 

 
ENVIRONMENTAL/WORKING CONDITIONS OF THE POSITION:
Normal office working environment. Some exposure to inclement weather.

Qualifications

MINIMUM QUALIFICATOINS:

• Bachelor’s degree in Statistics, Computer Science, Intelligence Analysis, Data Analytics or any other related field of study.
• Certificate in data analytics and or statistics required. 
• Possession of a valid driver’s license and a good driving record.

PREFERRED QUALIFICATIONS:

• Previous experience working within a law enforcement agency. 
• Previous experience working with IBM Analyst Notebook, ArcGIS, Microsoft Office Products, P3 Threat Reporting System and RMS Systems. 

SPECIAL REQUIREMENT:
Work Portfolio, showcasing the dashboards, codes and work performed in school or previous employment

KNOWLEDGE, SKILLS AND ABILITIES:

• Knowledge base in the programming language of SQL. Ability to write complex SQL queries involving joins, subqueries, aggregations and advanced functions to retrieve and transform data. 
• Knowledge base of mapping and visualization software like Tableau, PowerBI and ArcGIS. 
• Willingness to learn new software to present data to various stakeholders.
• Knowledge in spatial and social network analysis.
• Ability to independently prepare, present, and defend analytic findings. 
• Ability to develop and maintain effective working relationships with a wide variety of City and external business contacts.
• Ability to work effectively with multi-cultural populations.
• Ability to communicate effectively both orally and in writing.
• Knowledge of data governance, data quality, data security principles and best practices.
• Knowledge of computer-assisted data analysis techniques.

Supplemental Information

PHYSICAL DEMANDS OF THE POSITION:

• Able to lift/carry/push/pull at least 40 lbs.
• Visual acuity.
• Able to hear normal conversation and communicate orally in a clear manner.
• Good manual dexterity of hands and fingers.

EQUIPMENT USED:

• PC and associated software, copy machine, fax machine, and telephone.

This job description is intended to identify essential duties and also illustrates other types of duties that may be assigned. It should not be interpreted as describing all of the duties that will be required of an employee or be used to limit the nature and extent of assignments that an individual is required to perform. In addition to the responsibilities and duties listed, it is expected that employees maintain a consistent and reliable attendance record. Job descriptions are subject to revision at any time at the discretion of the City of Racine.

The City of Racine is an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, the City will provide reasonable accommodations to qualified individuals with disabilities and encourages both prospective and current employees to discuss potential accommodations with the employer.