Departmental Analyst 9-12 (Data Reporting Analyst)
Print (https://www.governmentjobs.com/careers/michigan/jobs/newprint/5457582)
Apply
?
Departmental Analyst 9-12 (Data Reporting Analyst)
Salary
$25.85 - $43.73 Hourly
Location
Lansing, MI
Job Type
Permanent Full Time
Remote Employment
Flexible/Hybrid
Job Number
4702-26-4192-AR
Department
Corrections - Central Office
Opening Date
08/24/2026
Closing Date
8/31/2026 11:59 PM Eastern
Bargaining Unit
NON-EXCLUSIVE REPRESENTED EMPLOYEE (NERE)
Description
Benefits
Questions
Job Description
The Michigan Department of Corrections is proud to be a Michigan Veteran's Affairs Agency (MVAA) Gold Level Veteran Friendly Employer.
MDOC is proud to employ nearly 1,500 veterans and actively serving military members across the department. The Department has many benefits and services available to support our military and veteran employees, spouses, and families. Learn more about what makes MDOC a Gold-Level Veteran Friendly Employerhere (https://www.michigan.gov/corrections/for-employees/military-and-veterans) .
Departmental Analyst 12
This position functions as a Senior Data Reporting Analyst in the Projections and Policy Impacts (PPI) Section / Office of Research and Planning Division. This position leads various report teams and is responsible for the completion of the required / requested report. The team is responsible for all tasks (i.e., Planning and Analysis, Design and Development, Testing, and Implementation) required to produce complex legislative and complex custom ad-hoc reports. These reports have multiple sections, multiple data sources, and have high visibility to the Governor's Office and to the public.
This position reviews and approves staff recommendations related to FOIA requests. This includes all tasks completed (i.e., research results, documentation, and report results for submission/disbursement). This position is responsible for the accuracy of the documentation and translation of the request to the report submitted/disbursed).
This position must have extensive expertise in MDOC datasets, including all exclusions, disclosures, and definitions (including administrative definitions). In addition, this position must have extensive knowledge in administrative rules, laws, etc. that restrict certain identifiable data to be included or excluded in report outputs.
Departmental Analyst 9-P11
This position functions as a Data Reporting Analyst in the Projections and Policy Impacts (PPI) Section / Office of Research and Planning Division. This position is assigned to multiple teams and is responsible for all tasks (i.e., Planning and Analysis, Design and Development, Testing, and Implementation) assigned to produce complex legislative and complex custom ad-hoc reports. These reports have multiple sections, multiple data sources, and have high visibility to the Governor's Office and to the public.
This position completes research and makes recommendations/drafts documentation related to FOIA requests. This includes research results, requirements, and report results for submission/disbursement. This position documents information supporting the accuracy of the report and completes initial translations of the report for review and approval.
This position gains knowledge and expertise in MDOC data sets, including exclusions, disclosures, and definitions (including administrative definitions). In addition, this position gains knowledge in administrative rules, laws, etc. that restrict certain identifiable data to be included or excluded in report outputs.
View the job specification here (https://www.michigan.gov/mdcs/-/media/Project/Websites/mdcs/JOBSPECS/D/DepartmentalAnalyst.pdf) .
View the position description for the Departmental Analyst-E (9-P11)here. (https://MCSC.state.mi.us/AgencyPDFs/Position%20Description%20(E%20Level)-%204192.pdf)
View the position description for the Departmental Analyst-A (12) here. (https://MCSC.state.mi.us/AgencyPDFs/Position%20Description%20(A%20level)-%204192.pdf)
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.
Departmental Analyst 12
Three years of professional experience, including one year of experience equivalent to the experienced (P11) level in state service.
Selective Position Requirement for Departmental Analyst 12: Minimum two years of experience developing queries from multiple tables and a variety of databases and analyzing the resulting data.
Selective Position Requirement for Departmental Analyst 9-P11:Minimum one year of experience developing queries from multiple tables and a variety of databases and analyzing the resulting data.
Alternate Education and Experience
Departmental Analyst 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
Work Location: This position is located in Lansing, Michiganand will require reporting in person for the first two weeks. After the initial training period, a hybrid work schedule may be approved that will allow work to be performed remotely up to 50% of the time with the other 50% of the work being performed in-person in Lansing.
The Michigan Department of Corrections is not an E-Verify employer and does not sponsor visa applications.
Your application for any position does not guarantee that you will be contacted by the Department for further consideration. Only those applicants interviewed may be notified of the results.
New hires to the MDOC along with previous MDOC employees that are returning after being away from the department for more than two years will complete Non-Custody New Employee Training (NCNET) either 40 hours or 80 hours of initial in-person training based on their level of offender contact and job classification. All new employees will complete additional online training to successfully complete their non-custody new employee training.
Employment in the state classified service demands a high degree of loyalty and imposes high ethical standards on employees to ensure the integrity of state government and maintain effective services. All employees must meet these ethical standards, and all appointing authorities are obligated to enforce these ethical standards.
As part of this effort all employees are required to report any possible conflict of interest, please review the information and be prepared to respond to questions related to the information in your application. Ethical Standards and Conduct ( Note: you do not need to fill out the form)
Certain positions may require a criminal history background check. To view the conditions of State of Michigan Employment, please clickhere (https://www.michigan.gov/mdcs/state-employment/general/conditions-of-som-employment) .
The Department of Corrections may screen out job applicants who have been convicted of a felony in accordance with Public Act 191 of 2017. Applicants who have been convicted of a misdemeanor or felony are ineligible for employment with the Department of Corrections until satisfactory completion of any sentence imposed, including parole or probation.
All required documents must be attached and submitted at the time of application for further consideration.Applications must be submitted through NEOGOV to be considered.
Interested applicants who are attaching transcripts must attach a copy of your official college transcripts indicating the specific @type of degree earned and the conferred/graduation date. (Un-official or web-based transcripts will not be accepted.) More information regarding what constitutes an official transcript can be found here (https://www.michigan.gov/-/media/Project/Websites/mdcs/neogov/OfficialTranscript.pdf?rev=b0798c88b0704c4c8feaf3e3e9d1bf80) . If you have questions or need assistance uploading and/or attaching your documents, please call the Office of Career Services toll free at 1-800-788-1766.
Accommodations
If you require a reasonable accommodation to participate in the application or selection processes, please contact theADA coordinator (https://www.michigan.gov/ose/-/media/Project/Websites/ose/Contact/RACs.pdf) for the agency that posted this position vacancy.
State employment also offers rewarding careers where you can help Michiganders enjoy better lives. Many State of Michigan jobs offer alternate work schedules and remote-work options that can help give the flexibility you need. 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.
More details on benefits for our new hires are below:
Rewarding Work:State of Michigan jobs allow you to serve Michiganders in many different ways depending on your interests and skills. Help preserve and protect our environment and the public health; enforce state laws and regulations; advocate for children, families, and victims of discrimination; support our state's military and veterans; rebuild our state's infrastructure; or support other state agencies through our fiscal, IT, and HR systems.
Insurance Benefits:The State of Michigan offers health, mental health, dental, and vision insurance to eligible career employees, their spouses, and their children. The state also covers a life-insurance benefit of two times employees' annual salary (up to $200,000). The state also offers long-term-disability insurance that can provide continuing benefits if an injury or illness prevents employees from working. More information is available at www.mi.gov/employeebenefits.
Retirement Programs:The State of Michigan offers 401(k) and 457 plans for new hires to save for retirement. The state will automatically contribute an amount equal to 4% of your pay to a 401(k) account. The state will also match up to 5% of your pay if you contribute to your 401(k) account. Your contributions vest immediately, and the state's contributions fully vest after just 4 years. More information is available athttp://www.mi.gov/orsstatedc.
Vacation and Sick Leave:Eligible full-time employees receive between15 and 35 personal daysand 13 sick daysper year that may be rolled over to the following year if not used. Eligible employees also receive an additional day each year for community service or school functions.
Paid Parental Leave:Eligible employees can take 12 weeks of paid leaveimmediately after a birth or adoption to allow needed time together at home with a new child.
Paid Holidays:Eligible employees receive 13 or 14 paid holidays each year including New Year's Eve and Day, Martin Luther King Jr. Day, Presidents' Day, Memorial Day, Juneteenth, the Fourth of July, Labor Day, Election Day, Veterans Day, Thanksgiving, Thanksgiving Friday, Christmas Eve and Day.
Bonus Programs:Eligible employees with five years of service also receive annual longevity bonuses that grow as seniority increases. Some positions also may qualify for recruitment, retention, and performance bonuses or other special pay premiums.
Military Pay Differential:Employees in the guard or reserves may also qualify for supplemental pay benefits if miliary pay during qualifying duty is less than normal state pay. Prior military service may also allow seniority credits to accelerate eligibility for longevity bonuses and additional personal leave accrual.
Tax-Advantaged Programs:In addition to 401(k) and 457 retirement accounts, the state also offers flexible spending account (FSA), health savings account (HSA), and qualified transportation fringe benefit (QTFB) programs that can help you save money by reducing your taxable income.
Student Loan Forgiveness:Working for the State of Michigan may allow you to participate in programs that forgive the balance of qualifying student loans. Please view Student Loan Information (https://studentaid.gov/manage-loans/forgiveness-cancellation) to help determine if you could qualify is available from the U.S. Department of Education.
Tuition Reduction:Some colleges and universities offer savings to eligible employees and family members to further their education while working for the State of Michigan.
Professional Development: To help develop your career, programs are available to apply for reimbursement of up to $2,000 a year for education and training for college course credits and non-degree programs.
Alternative and Remote Work Schedules:Depending on the nature of their duties, many state jobs offer flexible work schedules and remote or hybrid telecommuting options that can help obtain the work-life balance that you seek.
Great Lakes and Great Times:Michigan boasts four Great Lakes, 11,000 inland lakes, 36,000 miles of rivers and streams, 20 million acres of forests, 100 state and national parks and recreation areas, 1,300 miles of bike trails, 6,500 miles of snowmobile trails, the second-most ski areas in the nation, 650 public golf courses, 600 campgrounds, and an international dark-sky park-just for starters. Our cities offer concerts and cultural events, storied sports teams, education hubs, vibrant downtowns, one-of-a-kind craft beverages, and renowned restaurants for every appetite. From urban centers to beach towns to the great outdoors, the opportunities are endless. With your state salary and benefits and Michigan's affordable cost of living, you can explore all that Michigan has to offer.
Updated: 2/28/24
01
DEPTALT - Do you possess one of the following? A bachelor's degree or higher in any major. If so, please attach a copy of your official college transcripts. OR at least one year of professional level experience in the state classified service. OR the 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. Please attach a copy of your DD214.
Yes
No
02
DEPTALT - Please select your level of experience.
None to one year of professional experience.
One to two years of professional experience.
Two to three years of professional experience.
At least three years of professional experience.
03
Select how long you have been developing database queries connecting multiple tables of data by joining common data columns in those tables (for proper screening, your application materials must document this experience):
None
Less than 1 year
1-3 years
3-5 years
More than 5 years
04
How many years of experience do you have writing SQL?
None
Less than 1 year
1-3 years
3-5 years
More than 5 years
05
Select how many data tables are combined in the database queries developed by you (for proper screening, your application materials must document this experience):
3 tables or less
4 to 6 tables
7 to 10 tables
11 or more tables
06
Select how many records result from the database queries developed by you (for proper screening, your application materials must document this experience):
less than 200 records
200 - 2,000
More than 2,000
07
What software did you use to develop these database queries and for which job in your work history (proper screening, your application materials must document this experience):
08
Select how long you have been analyzing data resulting from database queries (for proper screening, your application materials must document this experience):
None
Less than 1 year
1-3 years
3-5 years
More than 5 years
09
What software did you use to analyze your database query results and what analyses did you perform (for proper screening, your application materials must document this experience)?
10
Did you include details to support your answers to the above supplemental questions in your application materials?
Yes
No
11
*CORR1 - Are you a participant in the Return to Work program? This program is for employees that were displaced from their regular jobs due to work injuries which do not allow them to perform their normal work duties.
Yes
No
12
*CORR2 - Are you related to or acquainted with anyone who is currently incarcerated in a State prison, tether program, on parole or felony probation status? (NOTE: an affirmative response to this question will NOT automatically result in you being screened out for consideration)
Yes
No
13
*CORR3 - If yes, indicate name(s), and incarceration/supervision location of prisoner, parolee, or probationer. What is your relationship to the person(s)? If no, enter N/A
14
*CORR4 - I understand and agree that the Department of Corrections will complete a thorough investigation of my ENTIRE CRIMINAL HISTORY and may verify all data given in the criminal history check. Any material misrepresentation or deliberate omission of a fact in their application may be justification for refusal of, or if employed, termination from employment.
Yes
No
15
*CORR5 - I understand that if selected for an interview, I will be scheduled electronically through NEOGOV. I have provided a valid e-mail and understand it is my responsibility to monitor said e-mail account for interview opportunities. I also acknowledge that correspondence received through NEOGOV may be sent to a junk mail (including state of Michigan junk mail) or spam account and I will monitor those accounts accordingly.
Yes
No
16
*CORR6 - Are you an active Michigan Department of Corrections employee? ACTIVE: Includes employees on layoff status due to a Reduction in Force whose recall rights have not expired.
Yes
No
17
*CORR9 I confirm that I have reviewed the required information on the Ethical Standards and Conduct via the link provided on the job posting. Based on that review please select the appropriate answer below.
Neither I nor any member of my immediate family (grandparent, parent, parent-in-law, stepparent, sibling, spouse, child or stepchild), have personal or financial interests in a business or entity which is contracted with the State of Michigan. Indicate N/A in the box below if this applies.
I, or a member of my immediate family (grandparent, parent, parent-in-law, stepparent, sibling, spouse, child or stepchild), have personal or financial interests in a business or entity which is contracted with the State of Michigan as summarized below.
18
*CORR10 -If you responded that you or a family member does have a conflict of interest to the question above, please explain in detail below. If you responded neither you nor a family member has a conflict please enter N/A.
19
*CORR11 - Have you ever been employed by the State of Michigan?
Yes
No
20
*CORR12 - IF you answered yes to the question above please identify which department, former name if used and/or ID number if known. If you answered no, please enter N/A.
Required Question
Employer
State of Michigan
Department
Corrections - Central Office
Address
saylork4@michigan.gov
206 E. Michigan Avenue
Lansing, Michigan, 48909
Apply
Please verify your email addressVerify Email
