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