What are the responsibilities and job description for the Crime and Data Analyst position at Racine, County of (WI)?
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.CRIME & DATA ANALYSIS
OTHER RELATED DUTIES
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.
EQUIPMENT USED
PHYSICAL DEMANDS
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.
- 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.
- 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.
- 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.
Salary : $61,027 - $85,509
