Promotional; LMPD ; Police Data Analyst

MUST BE A CURRENT, REGULAR EMPLOYEE OF LMPD.

The purpose of this position is to collect, manage, analyze, and interpret law enforcement data to identify patterns, trends, and actionable insights. This position supports operational and strategic decision-making by developing reports, dashboards, and analytical products, and by maintaining data systems and applications.

This class works under general supervision, independently developing work methods and analytical approaches.

• Discusses data requirements, reporting needs, and system functionality with users; recommends changes to improve efficiency, accuracy, and usability of reports and systems.
• Review'spurpose and content of reports to improve format, functionality, and accessibility.
• Collects, extracts, and integrates data from multiple sources including law enforcement systems (e.g., RMS, CAD), databases, and external sources.
• Creates andmaintainsdata structures, datasets, and data extraction processes for internal and external stakeholders.
• Develops, writes, andmaintainsSQL queries to extract, transform, and analyze large datasets.
• Performs statistical and analytical analysis toidentifypatterns, trends, and anomalies in crime and operational data.
• Prepares statistical reports and program evaluations related to department operations, grants, and initiatives.
• Generates and distributes reports, dashboards, and system status summaries for management and operational use.
• Designs and develops visualizations including charts, graphs, and dashboards to communicate analytical findings.
• Develops and maintains
  
  Power Bi dashboards and automated reports.
• Searches for computer records and databases to respond to information requests from management, internal personnel, and external stakeholders.
• Supports, creates, ormodifiescomputer applications, reporting tools, and data processes.
• Coordinates with Metro Technology Services staff and vendors to resolve system issues and improve data systems.
• Assistsin evaluating program effectiveness, crime trends, and operational initiatives to support strategic planning and resource allocation.
• Prepares written reports, briefings, and presentations to communicate findings to both technical and non-technical audiences.
• Maintains confidentiality, integrity, and security of sensitive law enforcement data.
• Performs related work as assigned.

MUST BE A CURRENT, REGULAR EMPLOYEE OF LMPD.

• Bachelor’s Degree in Computer Science, Data Analytics, Statistics, Criminal Justice, or related discipline.
• One (1) year of experience in data analysis, database management, programming, or data systems operations.

• An equivalent combination of education, training and experience may be substituted.

• Must be a U.S. citizen.
• Must demonstrate good moral character and conduct consistent with the responsibilities of the position. Individuals convicted of a felony, or those with any pending criminal charges are not eligible for employment.
• Applicants may be disqualified for multiple misdemeanors, an otherwise unacceptable criminal record, or multiple traffic violations.
• Must submit to a pre-employment drug screening.
• Must submit to a pre-employment polygraph test.
• Must submit to fingerprinting for criminal history check.
• Applicants who have illegally bought or used marijuana, including medicinal cannabis, within six months of application will be disqualified.
• Applicants who have illegally sold marijuana, including medicinal cannabis, within one year of application will be disqualified.
• Applicants who have illegally bought, sold, or used any controlled substance or narcotic drug, other than marijuana, without a prescription within six years of application will be disqualified.
• Must be willing to work…