What are the responsibilities and job description for the Police Technical Data Analyst position at Metropolitan Council?
- WHO WE ARE
The Metro Transit Police Department is one of the fastest growing law enforcement agencies in the state due to the expansion of light rail and Rapid Transit Bus systems. We are a licensed police force committed to the safety of our customers and employees, serving eight counties and approximately 85 cities in the region. There is an authorized strength of 171 full-time officers, 80 part-time officers, 70 community service officers and 34 administrative staff dedicated to one thing: public safety on and near our transit system. Our mission statement is: Safeguarding the transit community with integrity and professionalism while building trust through community partnerships. We strive to provide excellent police service each and every day.
We are committed to maintaining and cultivating a diverse department, reflective of the communities we serve. Nearly half of our force is made up of women and people of color.
To find out more about the Metro Transit Police Department, please click .
How your work would contribute to our organization and the Twin Cities region:
The Police Technical Data Analyst utilizes technical skills and critical thinking to construct queries and scripts for the extraction of data in response to crime analysis, data requests, and building dashboards for ongoing reporting. Utilizes multiple programs including Microsoft SQL Server Management Studio and Microsoft Report Builder to create reports that are accurate and understandable. This position works in coordination with the Police Data Analyst creating reports, charts, maps, statistics, presentations, and intelligence bulletins to communicate real time crime trends, hotspots, modes of operation and patterns, as well as communicate information for wanted persons and officer safety.
This posting will establish a six (6) month eligibility list for current and future positions.
Anticipated hiring salary range: $78,582 - $89,190
We offer a competitive salary, excellent benefits and a good work/life balance.- What you would do in this job
- Utilize SQL Programming to build complex scripts and join tables in relational databases.
- Compile and configure data and statistics to develop real time crime trends and patterns utilizing various law enforcement databases.
- Utilize crime analytics programs to further extract and organize data.
- Create and maintain dashboards for reports and queries.
- Assist in preparation of weekly analysis of crime statistics (aka CompStat) for the Police Chief and Command Staff.
- Prepare quarterly reports for the General Manager that include crime statistics and trends.
- Communicate regularly with MTPD Staff to understand the needs of each division and respond by researching and presenting crucial data.
- Utilize statistics, investigative alerts, law enforcement databases and photos to prepare intelligence bulletins to enhance data sharing and officer safety.
- Gather data from other law enforcement agencies to study and analyze past and existing crime series, patterns, and trends directly impacting MTPD.
- Respond to requests for crime data to assist others with information; assist with data requests from Met Council and the Public.
- Performs other duties as assigned.
- What education and experience are required for this job (minimum qualifications)
- Education / Experience Requirements:
- Associate degree in Criminal Justice, Information Technology, Mathematics/Statistics, Public Administration or closely related, AND six (6) years of experience to include a combination of information technology, technical skills in data extraction, analysis of law enforcement and/or criminal data or systems and customer service.
OR
- Bachelor's degree in Criminal Justice, Information Technology, Mathematics/Statistics, Public Administration or closely related, AND four (4) years of experience to include a combination of information technology, technical skills in data extraction, analysis of law enforcement and/or criminal data or systems, and customer service.
OR
- Master's degree in Criminal Justice, Information Technology, Mathematics/Statistics, Public Administration or closely related, AND two (2) years of experience to include a combination of information technology, technical skills in data extraction, analysis of law enforcement and/or criminal data or systems and customer service.
What additional skills and experience would be helpful in this job (desired qualifications):- Experience utilizing crime analytics programs and Excel to extract, analyze and organize data.
- Proficiency in SQL Programming, development and skilled in running test queries.
- Experience compiling and configuring data/statistics into Reports that demonstrate real time crime trends and patterns utilizing various law enforcement databases.
- Experience preparing weekly intelligence bulletin that identify trends, highlight critical cases and high-level offenders, officer safety and bring awareness to relevant information from other agencies.
- Experience presenting CompStat and Intel findings in meetings to communicate trends and hot spots to support the deployment and utilization of staffing resources.
- Experience and knowledge of MN Government Data Practices Act.
- Experience compiling and responding to data requests.
- Demonstrated ability to promote and support an equitable, positive, and respectful work environment that values cultural diversity among all employees.
What knowledge, skills, and abilities you should have within the first six months on the job:- Knowledge of Informational needs and objectives of police and other users of statistical crime data.
- Proficiency in SQL Programming, development and skilled in running test queries.
- Knowledge of the organizational concepts of law enforcement and the criminal justice system.
- Knowledge of law enforcement systems and software used to compile and analyze data and prepare reports.
- Knowledge of administrative research, analysis, and statistical methods.
- Knowledge of report writing, basic grammar, spelling, vocabulary, punctuation and sentence construction.
- Skill in recalling information in emergency situations including names, locations, and other detailed information.
- Skill in understanding and following oral and written directions.
- Skill in working under periods of stress and dealing with multiple activities simultaneously.
- Skill in using computers, internet, word processing, spreadsheets, and various programs.
- Skill in interpreting, researching, analyzing, and distributing information from charts, graphs, maps, tables, etc. in an effective manner.
- Ability to lead meetings to present analytics data to Police Command and Metropolitan Council Staff.
- Ability to prioritize workload.
- Ability to organize large amounts of data into useable and understandable formats.
- Ability to plan for future projects.
- Ability to work collaboratively with internal and external partners.
- Additional information
Union/Grade: Non-Represented Classified (NRC) / Grade H
What steps the recruitment process involves:
FLSA Status: Exempt
Safety Sensitive: No
Work Environment: Work is performed in a standard office setting. May require travel between primary work site and other locations.- We review your minimum qualifications.
- We rate your education and experience.
- We conduct a structured panel interview.
- We conduct a selection interview.
Once you have successfully completed the steps above, then:
If you are new to the Metropolitan Council, you must pass a drug test (safety sensitive positions only), and a thorough background check conducted by the MTPD which verifies education, employment, and criminal history. All applicants' background checks and fingerprints must be cleared by the Criminal Bureau of Apprehension in order to be a user of their CJIS system. Failure to be cleared by BCA will automatically nullify any job offer extended. A driving record check and/or physical may be conducted if applicable to the job. If you have a criminal conviction, you do not automatically fail. The Metropolitan Council considers felony, gross misdemeanor and misdemeanor convictions on a case-by-case basis, based on whether they are related to the job and whether the candidate has demonstrated adequate rehabilitation.
If you are already an employee of the Metropolitan Council, you must pass a drug test (if moving from a non-safety sensitive position to a safety sensitive position) and criminal back ground check if the job you're applying for is safety sensitive, is a supervisory or management job, is in the Finance, Information Services, Audit, or Human Resources departments, or has access to financial records, files/databases, cash, vouchers or transit fare cards. All applicants' background checks and fingerprints must be cleared by the Criminal Bureau of Apprehension in order to be a user of their CJIS system. Failure to be cleared by BCA will automatically nullify any job offer extended. A driving record check and/or physical may be conducted if applicable to the position.
Please note:
Making a false statement or withholding information (misrepresentation) may cause an applicant to be barred from consideration for the positions.
Candidates will be notified of their application status through e-mail only.
Note: In order to be considered for the position, you must complete the application in its entirety.
The Metropolitan Council is an Equal Opportunity, Affirmative Action, and veteran-friendly employer. The Council is committed to a workforce that reflects the diversity of the region and strongly encourages persons of color, members of the LGBTQ community, individuals with disabilities, women, and veterans to apply. If you have a disability that requires accommodation during the selection process, please email .
Salary : $78,582 - $89,190
