Data Analyst II

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