Posting number: 5501-26150-EU
Department: State Police
Job classification: Departmental Analyst 9-P11
Posting type: Open
Categories: Law Enforcement
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.
[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.
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.
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.
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.
Are you interested in other Employee Jobs?
MSP on Facebook MSP on Twitter MSP on YouTube MSP on Instagram MSP on LinkedIn
MSP is an MVAA Gold Certified Employer
View the job specification at: https://www.michigan.gov/mdcs/-/media/Project/Websites/mdcs/JOBSPECS/D/DepartmentalAnalyst.pdf
Every day the contributions and achievements of State of Michigan employees have a direct impact on over 10 million Michiganders across the state. If you're looking for a fulfilling career in state government that can make a real difference in the lives of others, you can find your place working with us. We have opportunities in a number of career pathways, including, but not limited to, business and administrative support, education and human services, IT and computers, medical and healthcare, natural resources, law enforcement and public safety, skilled trades and more.
Join our team for an:
- Opportunity to make a difference
- Challenging and rewarding work
- Competitive salaries
- Fun working environment
- Great benefits (community service, vacation and sick leave, paid holidays, paid parental leave, longevity bonuses)
- Job stability and career advancement
- Flexible alternative and remote work schedules
- Tuition discounts and student loan forgiveness
- Professional development/training
- Employee discount plan
With positions in over 18 state departments, your perfect career fit is waiting for you at the State of Michigan.
From urban centers to beach towns to the great outdoors, the opportunities are endless in Pure Michigan. With your state salary and benefits and Michigan’s affordable cost of living, you can explore all that Michigan has to offer.
Ready to join our team? Visit www.Michigan.gov/Employment to search hundreds of state job openings by key word, job type, location, department, job category, salary and more.
The State of Michigan is an Equal Opportunity Employer. We aim to recruit, hire, develop, and retain a diverse and high performing workforce. Our diversity helps drive our creative and effective problem solving, mutual respect, teamwork, and effective communication with the people we serve.
Follow us on social media at www.Michigan.gov/SocialMedia and search hashtag #MiGovJobs for updates from state agencies.
