Crime and Data Analyst

Racine County, WI | Racine, WI

Posted Date 2/16/2025

Description

Job Summary

The Racine County Performance and Data Analytics Department provides data analytics, marketing, and grant writing supports to internal and community stakeholders. The Crime and Data Analyst will be highly skilled in all aspects of data analytics, including mining, analyzing, and visualizing data with a commitment to clear, outcomes-driven reports to advance innovation and growth while maximizing returns on investment for Racine County.

Key Responsibilities

CRIME & DATA ANALYSIS

Identify, collect, clean, analyze, and visualize data across diverse data systems.
Create ad hoc reports, infographics, and visualizations for County staff, divisions, and departments.
Strategically craft and message findings to diverse stakeholders to build consensus and improve County and community outcomes.
Provide technical support and assistance to the Performance and Analytics Department.
Proficient in SQL query writing to extract, manipulate, and analyze data from multiple databases and data sources.
Strong understanding of database structures and relational database management systems (RDBMS).
Ability to write complex SQL queries involving joins, subqueries, aggregations, and advanced functions to retrieve and transform data.
Experience in optimizing SQL queries for performance and efficiency.
Knowledge of database indexing, query optimization techniques, and query tuning.
Familiarity with SSRS (SQL Server Reporting Services) to design and generate interactive reports and visualizations.
Ability to develop and maintain SSRS reports, including report layout, data source configuration, and parameterization.
Proficient in creating and modifying report templates, data visualizations, charts, and graphs using SSRS.

OTHER RELATED DUTIES

Attend staff meetings, trainings, workshops, and outreach events.
Participate in projects and other assignments as directed by the Performance and Analytics Director.
Learn new technologies and analytics tools to improve County programming and initiatives.

CORE VALUES OF PERFORMANCE AND ANALYTICS DEPARTMENT
Customer Service: Provide above-and-beyond service, treating each internal and community stakeholder as a top priority.
Timely, High-Quality Deliverables: Incorporate ongoing feedback and changes to provide a timely, high-quality deliverable to the standards of each end user.
Collaborative: Work closely with Racine County and community partners to deliver high-impact, cost-effective services for Racine County residents.

Supervision Received from the Director of Data and Performance Analytics.

Qualifications

Bachelor’s Degree in Mathematics, Statistics, Computer Science, and/or the Social Sciences with an emphasis on Data Analytics.
Valid driver’s license with reliable transportation and verification of appropriate, current insurance coverage.

Knowledge Skills & Abilities

Proficiency in identifying, cleaning, manipulating, analyzing, and visualizing data
Knowledge of programming language like SQL
Knowledge of mapping and visualization software like Tableau, PowerBI, and ArcGIS
Knowledge of or willingness to learn marketing tools such as Adobe Creative Suite to present data findings in a clear, appealing manner
Awareness of local, state, and federal data sources to address key community questions and needs

EQUIPMENT USED

Personal computer and telephone

PHYSICAL DEMANDS

Continuous (67-100% of workday) talking, hearing, use of far and near vision, sitting and light intensity of typing
Frequent (34-66% of workday) walking
Occasional (1-33% of workday) standing and carrying objects weighing 1-10 pounds

DISCLAIMER
This description has been prepared to assist in properly evaluating various classes of responsibilities, skill, working conditions, etc., present in the classification. It is intended to indicate the kinds of tasks and characteristic levels of work difficulty that will be required of positions that will be given this title. It is not intended as a complete list of specific duties and responsibilities nor is it intended to limit or in any way modify the right of any supervisor to assign, direct and control the work of employees under supervision. The use of a particular expression or illustration describing duties shall not be held to exclude other duties not mentioned that are of similar kind or level of difficulty.

Become a part of the Racine County Team!!

To view a summary of the benefits offered, click on the link below:

Racine County Benefits