Departmental Analyst 9-P11 ​/ ITB ​/ CJIC ​/ Michigan Incident Crime Reporting

This position is responsible for the Michigan Incident Crime Reporting Structure Query Language (SQL) maintenance. This position will design, create, and modify SQL queries and libraries in the appropriate department database. This position will validate and extract data to fulfill Freedom of Information Act requests, Clery Act requests, and other data requests from local law enforcement agencies, internal department members, and other external stakeholders.

Primary responsible for this position includes data interpretation to compose publications and reports to facilitate improvements by equipping requestors with targeted data insight; troubleshoot errors within the respective databases; and create declarations that follow the unit’s data sharing agreements.

The Michigan State Police is committed to fostering a diverse, inclusive workplace that accepts, respects, and values the unique contributions of everyone. We are actively looking for individuals who share our commitment to equity and inclusion, and who reflect the communities we serve. Our members are expected to perform their tasks and duties in a bias-free manner, ensuring all persons are treated with dignity, fairness, and respect.

Join us as we help build a Michigan where everyone feels safe and secure.

The Michigan State Police (MSP) is a full-service policing agency with statewide jurisdiction, providing over 60 different services either directly to Michigan residents or in support of other law enforcement agencies. The MSP personnel most visible to the public are the uniform troopers whose primary responsibilities include traffic enforcement, crime prevention and investigation, and community engagement and service.

Blue and gold MSP benefits info graphic summarizing insurance, paid leave, and other benefits contained in the text below, with representative icons.

• Possession of a bachelor's degree in any major.

• Departmental Analyst 9
• No specific type or amount is required.
• Departmental Analyst 10
• One year of professional experience.
• Departmental Analyst P11
• Two years of professional experience, including one year of experience equivalent to the intermediate (10) level in state service.

• Departmental Analyst 9 - 12
• Educational level typically acquired through completion of high school and the equivalent of at least two years of full-time active-duty experience at or above the E-6 level in the uniformed services may be substituted for the education requirement.

This position requires passing a pre-employment screening, including passing a drug screen, criminal history background check, and a fingerprint check by the Michigan State Police.

The State of Michigan has been recognized as a leading U.S. employer by new graduates from  and a best large U.S. and state employer. Recognized on the international stage for fostering positive employee engagement, the State of Michigan is a past recipient of a North America Government Agency Employees Engagement Award.

View the job specification at: https://(Use the "Apply for this Job" box below)./