Data Analyst Ii (May Underfill)

Position Title:
Data Analyst II (may underfill)
Job Description:
The Salt Lake City Police Department is seeking an Data Analyst to join our team! This position is available to be filled at the I or II level.
Working under limited supervision, incumbent is responsible for providing strategic, tactical, and operational support and analytics to patrol, investigations, special operations and command staff as well as handling time-sensitive requests from city officials, other law enforcement agencies, and the public via GRAMA requests. Responsibilities include identifying emergent crime patterns and series, analyzing criminal activity and contributing to intervention efforts, communicating critical intelligence to officers, completing complex analyses joining datasets from disparate sources, and producing reports/dashboards/maps that meet the needs of internal and external stakeholders. Candidate has advanced knowledge of visualization software such as ArcGIS, Tableau, and Power BI, and/or coding languages such as SQL, Python, or R.
Incumbents at this level possess the skill and demonstrated ability to apply advanced knowledge and effectiveness to facilitate data-driven decision-making within in the organization as well as the city overall.
About the Team
You would be working on a team of four analysts, one supervisor, and the director of data science. In this position, you will work with disparate data sources to build dashboards and maps, complete analytical projects, and utilize intelligence to assist with public safety efforts.
Currently this role allows for a hybrid schedule, requiring some work in the office each week. Analysts can work either four days a week, ten hours per day or five days a week, eight hours per day.
Position Salary Range
Level I: $49,857.60 - $86,132.80; The established market rate for this level is $67,995.20.
Level II: $54,974.40 - $94,972.80; The established market rate for this level is $74,963.20.
This position is eligible for full city benefits, including:

• Health, dental, vision, and life insurance
• 13 paid holidays per year
• Paid vacation and personal leave
• Six weeks of paid parental leave
• Retirement contributions toward a pension plan or 401(k)
• A robust EAP that provides emotional support, work-life solutions, legal guidance, and financial resources, including up to 15 counseling sessions for you and your household family members at no cost
• Tuition reimbursement
• Discounted supplemental benefits like pet insurance, legal services, and shopping

Early application submission is advised. Applications will be accepted until December 10, 2023.
TYPICAL DUTIES:

• Works with data in multiple systems, develops appropriate datasets, applies analytical best practices, ensures accuracy, and creates reports, dashboards, and maps that meet the needs of the end users, which include the department, outside agencies, city officials, and the public.
• Designs the right solutions for partners through a clear understanding of what questions are being asked. Helps various stakeholders understand key takeaways from the results.
• Serves as primary contact and subject matter expert for patrol divisions and investigations. Provides on-demand support based on quickly evolving crime patterns and the emerging needs of city leaders.
• Participates in the investigative process through analytical examination of data, intelligence, and evidence, to identify offenders and link cases in support of successful case resolution.
• Performs comprehensive research of persons, places, and vehicles in criminal cases.
• Conducts open-source research and data analysis of social media for potential criminal activity and/or threats to the community.
• Presents clear and concise findings to stakeholders and provides recommendations. Encourages partners to consider new data-driven approaches.
• Evaluates and anticipates reporting needs of the department.
• Consistently delivers work products on time.
• Demonstrates technical expertise by knowing which data tools are best suited to accomplish certain requests.
• Troubleshoots data challenges and reconciles discrepancies with creative problem solving.
• Collaborates with IT partners and analyst colleagues across the city to develop optimized data solutions.
• Develops trust and partnerships within the department to deliver value-added reporting and intelligence that reflects the strategic objectives of the organization.
• Handles highly sensitive information with integrity and professionalism.
• Performs additional duties as assigned.

MINIMUM QUALIFICATIONS:
Level I

• Graduation from an accredited four-year college or university with a bachelor's degree in the Social Sciences, Data/Computer Science, Statistics/Mathematics, Criminology/Criminal Justice, or closely related field.
• Directly related work experience may be substituted for education on a year-for-year basis.
• Familiarity with visualization software such as ArcGIS, Tableau, and Power BI, and/or coding languages such as SQL, Python, or R.

Level II

• Graduation from an accredited four-year college or university with a bachelor's degree in the Social Sciences, Data/Computer Science, Statistics/Mathematics, Criminology/Criminal Justice, or closely related field and three years of professional experience in analytics. This includes gathering data, interpreting the results, identifying trends and patterns, creating visualizations and narratives that explain the main takeaways.
• Directly related work experience may be substituted for education on a year-for-year basis. A master's degree in a related field may be substituted for up to two years of professional experience.
• Advanced knowledge of visualization software such as ArcGIS, Tableau, and Power BI, and/or coding languages such as SQL, Python, or R.

All Levels:

• Ability to collect and analyze data/trends and make appropriate recommendations to further a department's goals. Possess strong data analysis skills and project management skills.
• Excellent problem-solving skills and ability to think creatively with numbers. When encountering roadblocks, communicates the issue and considers alternate solutions.
• Strong verbal and written communication skills. Effectively communicates with people of diverse backgrounds within and outside an organization.
• Knowledge of the theory, principles, practices, and methods of crime analysis and criminal behavior.
• Manage conflicting priorities with different timelines, multitask, and effectively adapt to change.
• Demonstrates critical thinking skills by asking questions and identifying opportunities for improvement. Always looking to learn and enhance personal and team performance.
• Proficient in Microsoft Office.
• Able to learn new software and analytic techniques and apply it to future projects.

DESIRED QUALIFICIATIONS:

• In depth knowledge of statistics, quantitative analysis, and telling stories with data.
• Professional experience using analytical software, databases, and systems used to gather analytics and intelligence such as ArcGIS, Tableau, Power BI, SQL, Python, or R.
• Master's degree in GIS, Data/Computer Science, Statistics/Mathematics, Criminology/Criminal Justice, or related field.
• Professional certifications including International Association of Crime Analysts (IACA).
• Technical certifications in programming such as SQL, Python, etc.

WORKING CONDITIONS:

• Generally comfortable working conditions requiring light physical effort. Intermittent sitting, standing, and walking, and frequent use of a computer, telephone, and other standard office equipment.
• May work four days a week, ten hours per day or five days a week, eight hours per day.
• May require shift work, including holidays and weekends.
• On occasion may be required to respond outside normal working hours to meet the needs of the department.

The above statements are intended to describe the general nature and level of work being performed by persons assigned to this job. They are not intended to be an exhaustive list of all duties, responsibilities and skills required of personnel so classified.
All requirements are subject to possible modification to reasonably accommodate individuals with disabilities.
Full Time/Part Time:
Full time
Scheduled Hours:
40