Public Safety Building

Full time

JR6206

Position Title:

Data Analyst II

Job Description:

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.

If this position requires operation of a city-owned motor vehicle, a candidate may be subject to a motor vehicle record check at the time of hire or as part of the hiring process.

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:

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.

POSITION TYPE

Full-Time

POSITION SALARY RANGE

$60,941 - $105,281

DEPARTMENT

Police

Full Time/Part Time:

Full time

Scheduled Hours:
40
Salt Lake City is a place where your skills and dedication directly contribute to the community. With a team serving over 200,000 residents, we take pride in delivering meaningful work-from maintaining infrastructure to shaping public programs-with integrity and professionalism.

We value experience, accountability, and results. Our organization recognizes talent and rewards contribution, offering employees opportunities to grow, lead, and make a lasting difference.

If you're driven by public service and want to help shape the future of our city, we'd love to work with you.

Salt Lake City offers a competitive and well-rounded benefits package designed to support your health, financial future, and professional growth. To learn more, visit our Benefits & Wellness (https://www.slc.gov/hr/benefits-and-wellness/) site.

Health & Wellness

Medical insurance

Dental, vision, life insurance

HSA (with $1,000-$2,000 City contribution)

Wellness clinic for employees & families

Robust Employee Assistance Program (EAP)

Financial Perks

Tuition reimbursement (up to $4,000/year)

Retirement contributions (pension and/or 401(k))

Discounted pet insurance, legal services, and more

Thinking about applying or weighing another offer

Use our Total Compensation Calculator (https://tools.slc.gov/totalcompensation/) to see the true value of your job offer-including salary, benefits, retirement, and more.

We know time away from work is essential for rest, personal needs, and family life. Salt Lake City offers generous paid leave to help you recharge and stay balanced. To learn more, visit our Benefits & Wellness (https://www.slc.gov/hr/benefits-and-wellness/paid-leave/) site.

12 vacation days to start

12 paid holidays + 1 personal holiday

Up to 80 hours personal leave annually

6 - 12 weeks of paid parental leave

Bonus leave credit for eligible rehires & public sector transfers

Our Recruitment Team is ready to assist you throughout the entire hiring process-from questions about job openings to application support. Reach the Recruitment Team at 801-535-6699

Or email: careers@slc.gov

The City is committed to the full inclusion of all qualified individuals. As part of this commitment, Salt Lake City will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact Human Resources at 801-535-7900.

Salt Lake City is proud to be a partner of the Utah Patriot Program, providing employment opportunities for Veterans, Military and spouses. We are also a proud National Service Partner.

Salt Lake City Corporation

New Jobs

Data Analyst II