Departmental Analyst 9-12 (Data Reporting Analyst)

State of Michigan9 months ago
Lansing, MI, United States
Hybrid
Full-time
Junior Level (1-3 years)

Job Description

Position Overview

This position is being re-posted. If you previously applied for this position, you would need to reapply. The Michigan Department of Corrections, a Gold Level Veteran Friendly Employer employing nearly 1,500 veterans and actively serving military members, invites applications for Departmental Analyst positions at various levels (Departmental Analyst 12 and Departmental Analyst 9-P11). In these roles, you will function as a Data Reporting Analyst in the Projections and Policy Impacts Section / Office of Research and Planning Division, responsible for producing complex legislative and custom ad-hoc reports, handling FOIA requests, and ensuring data accuracy by leveraging extensive knowledge of MDOC datasets, administrative rules, and laws.

Key Responsibilities

  • Lead report teams and oversee tasks including planning and analysis, design, development, testing, and implementation for complex legislative and custom ad-hoc reports.
  • Review and approve staff recommendations related to FOIA requests, ensuring that research results, documentation, and report outcomes are accurate.
  • Develop queries from multiple tables and databases and analyze resulting data to support report production.
  • Collaborate with multiple teams to integrate data from various sources, ensuring high report quality and compliance with stakeholder requirements.

Required Qualifications

  • Education: Possession of a bachelor's degree in any major. Alternate qualifications include completion of high school and at least two years of full-time active-duty experience at or above the E-6 level (applicable for Departmental Analyst 12).
  • Experience Required: Varies by level – Departmental Analyst 9: No specific requirement; Departmental Analyst 10: One year of professional experience; Departmental Analyst P11: Two years (including one year equivalent to the intermediate level); Departmental Analyst 12: Three years (including one year equivalent to the experienced level). Additionally, selective requirements include experience developing queries from multiple tables and analyzing data from varied databases.
  • Qualifications: Demonstrated expertise in developing database queries, working with complex data sets, and ensuring the accuracy and compliance of report outputs.

Benefits & Perks

  • Location: Lansing, Michigan (initial in-person reporting for the first two weeks).
  • Schedule: Hybrid work schedule available after the training period, allowing up to 50% remote work.
  • Benefits: Access to a range of benefits and services supporting military and veteran employees, their spouses, and families. Additional training opportunities, including non-custody new employee training, are provided.

Required Skills

Data Reporting
Government Regulations
Advanced Query Development
Data Analysis
FOIA Compliance
Documentation and Translation
Legislative Reporting