Job Description 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.

POSITION DESCRIPTION

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. [HA2.1] 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. Required Education and Experience Education Possession of a bachelor's degree in any major. Experience 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. Alternate Education and Experience 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. Additional Requirements and Information 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. Please attach a cover letter/memo addressed to Ms. Cherish Nunez , resume, and official college transcripts (if applicable) to your application. Unofficial transcripts will not be accepted.

Please note:

Applicants will be screened out for failure to attach the required resume, cover letter/memo , and (if applicable) official transcripts to their application. The State of Michigan has been recognized as a leading U.S. employer by new graduates from 2021-2023 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://www.michigan.gov/mdcs/-/media/Project/Websites/mdcs/JOBSPECS/D/DepartmentalAnalyst.pdf Accommodations If you require a reasonable accommodation to participate in the application or selection processes, please contact the ADA coordinator for the agency that posted this position vacancy.