Departmental Analyst (Trainee) 9-P11 (Boilerplate Reporting Analyst) Print (https://www.governmentjobs.com/careers/michigan/jobs/newprint/4658818) Apply  Departmental Analyst (Trainee) 9-P11 (Boilerplate Reporting Analyst) Salary $54,766.40 - $81,806.40 Annually Location Lansing, MI Job Type Permanent Full Time Job Number 4702-24-3361-KS Department Corrections - Central Office Opening Date 11/12/2024 Closing Date 11/26/2024 11:59 PM Eastern Bargaining Unit NON-EXCLUSIVE REPRESENTED EMPLOYEE (NERE) + Description + Benefits + Questions Job Description *This position is being re-posted. If you previously applied for this position, you would need to reapply.* 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 Employer here (https://www.michigan.gov/corrections/for-employees/military-and-veterans) . ***This position has the ability to be a hybrid position for up to 50% of the pay period. The selected candidate is expected to work a minimum of the first two weeks in the office to assist in learning the position. This position is responsible for supporting Legislatively mandated reports and for other government agencies by identifying, reviewing, and extracting offender data from automated data sources. This position is also responsible for analyzing, interpreting, and preparing presentation materials to support reporting. View the job specification here (https://www.michigan.gov/-/media/Project/Websites/mdcs/JOBSPECS/D/DepartmentalAnalyst.pdf?rev=1fc722c15b5f44bdb46d364de1664ecf) . View the position description here (https://MCSC.state.mi.us/AgencyPDFs/Position Description-3254.pdf) . Required Education and Experience Education for Departmental Analyst 9-P11 Possession of a bachelor's degree in any major. Experience for Departmental Analyst 9-P11 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. 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. Departmental Analyst (Departmental Trainee) 9 (FOR CLASSIFIED STATE EMPLOYEES ONLY) Education Educational level typically acquired through completion of high school. Experience Four years of experience as an advanced 9-level worker in an ECP Group One classification. OR Three years of experience as an E9, E10, or E11-level worker in an ECP Group One classification. OR Two years of experience as an experienced level worker in an ECP Group One technician or paraprofessional classification. OR Two years of experience as a first-line supervisor in an ECP Group Three classification. OR One year of experience as a second-line supervisor in an ECP Group Three classification. *Paraprofessional classifications are those requiring an associate's degree or two years of college. Educational Substitution College credits may be substituted on a proportional basis (one year of college education may substitute for one quarter of the required experience) for up to one half of the required experience. Additional Requirements and Information SELECTIVE POSITION REQUIREMENT (SPR) Minimum one year of experience developing queries from multiple tables and a variety of databases and analyzing the resulting data. **This position requires the ability to write SQL to extract large amounts of data from different databases and create reports. 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. 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 yourofficialcollege 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 foundhere (https://www.michigan.gov/documents/mdcs/OfficialTranscript\_693831\_7.pdf) . 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. 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 DEPTTRE - 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 the education and experience for the Departmental Analyst Trainee or an educational substitution, as listed on the job specification. If so, please attach a copy of your official college transcripts. + 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 + 3 years or more but less than 4 years + 4 years or more + 2 years or more but less than 3 years + 1 year or more but less than 2 years 04 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 + 11 or more tables + 7 to 10 tables + 4 to 6 tables 05 Select how many records result from the database queries developed by you (for proper screening, your application materials must document this experience): + less than 50 records + 2000 records or more + 200 records or more but less than 2000 records + 50 records or more but less than 200 records 06 What software did you use to develop these database queries and for which job in your work history (for proper screening, your application materials must document this experience)? 07 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 + 2 years or more but less than 3 years + 3 years or more but less than 4 years + 4 years or more + 1 year or more but less than 2 years 08 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)? 09 Did you include details to support your answers to the above supplemental questions in your application materials? + Yes + No 10 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 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 *CORR8 - Have you participated in an internship with the Michigan Department of Corrections? + Yes + No 18 *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. 19 *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. 20 *CORR11 - Have you ever been employed by the State of Michigan? + Yes + No 21 *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 Agency 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