Data Integrity and Reporting Analyst - Departmental Analyst 9-P11 - State Budget Office
Print (https://www.governmentjobs.com/careers/michigan/jobs/newprint/5305479)
Apply
?
Data Integrity and Reporting Analyst - Departmental Analyst 9-P11 - State Budget Office
Salary
$25.85 - $40.51 Hourly
Location
Lansing, MI
Job Type
Limited Term (position has expiration date)
Remote Employment
Flexible/Hybrid
Job Number
0701-26-30-27NG
Department
Technology, Management and Budget
Opening Date
04/15/2026
Closing Date
4/22/2026 11:59 PM Eastern
Bargaining Unit
NON-EXCLUSIVE REPRESENTED EMPLOYEE (NERE)
Description
Benefits
Questions
Job Description
TheCenter for Educational Performance and Information(CEPI)is housed within State Budget Office and is responsible for coordinating the management, collection, and reporting of all education data, including the electronic exchange of student records between preschool, K-12, and postsecondary education. Learn more atwww.Michigan.gov/budget.
CEPI is recruiting to fill aData Integrity and Reporting Analystposition within its Office of Analytics and Reporting Division. This position analyzes and reports education data from the Michigan Statewide Longitudinal Data System (MSLDS) in a manner that accurately portrays information on Michigan's public preschool through postsecondary education students, staff, and schools over time. The position follows the standards, policies, procedures and protocols related to quality assurance, configuration management, metadata management, data quality, reporting tools and data manipulation techniques, and supports the creation of an environment that encourages maximum use of the MSLDS for improving education policy decision-making while meeting federal and state data reporting requirements.
As the Data Integrity and Reporting Analyst, your primary activities will include:
Providing analytical and reporting services from the MI Statewide Longitudinal Data System (MSLDS).
Meeting with stakeholders to collect business requirements then creating solutions that meet their data needs.
Assisting in the design, development, implementation, operation, and maintenance of the MSLDS, designing and testing data loads.
For more information about this position, please review the duties listed in the provided links:
POSITION DESCRIPTION-Departmental Analyst 9-P11 (https://mcsc.state.mi.us/AgencyPDFs/DIRU%20Analyst%209-P11%20PD.docx)
JOB SPECIFICATION-Departmental Analyst 9-P11
The office location is the Library of Michigan at 702 West Kalamazoo Street, Lansing. The CEPI currently offers a hybrid work option which requires one day working on-site at the official workstation with the potential of up to four days remote work per week. Candidates should confirm work location and schedule at the time of interview. Currently, the State of Michigan is unable to offer employment to non-Michigan residents that do not plan to relocate.
Candidates should confirm work location and schedule at the time of interview. Work must be performed in the state of Michigan. If you currently reside outside of Michigan, you must relocate to Michigan to perform the duties of this position. Relocation expenses are not reimbursed.
__
This position is being filled as limited term.
Limited Term is an appointment which has an expiration date. For this position, the Limited Term assignment will begin on the date of hire and expire two years from the date of hire. Limited-Term employees are encouraged and supported in seeking permanent employment within SBO/the State of Michigan prior to the appointments' end.
__
Required Education and Experience
Education
Possession of a bachelor's degree in any major.
Applicants who possess a degree from a foreign college or university must have their academic credentials evaluated or converted into U.S. educational equivalents unless the degree has been recognized by the Council on Higher Education Accreditation (CHEA). Go to evaluators (https://www.naces.org/members) for a list of accepted organizations that evaluate foreign credentials. Failure to provide this evaluation at the time of application may result in you being screened out of the process.
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.
Note: Experience is considered professional if the job performed required the possession of a bachelor's degree.
Alternate Education and Experience
Departmental Analyst 9 - P11
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
Serve Michigan with a Career in State Budget Office
Accounting / Auditing / Budgeting / Finance / Systems Data and Research
Why join CEPI and its Office of Analytics and Reporting team?
Working for CEPI is both challenging and rewarding. Our team members work together through problem solving, collaboration, and supporting one another.
We offer a hybrid work schedule, with the option to work remotely 4 days a week.
Idea sharing and formation is encouraged to support continued growth throughout our teams.
Staff are provided with access to training, resources, and experienced team members.
State Budget Office is committed to providing an inclusive work environment that encompasses a culture of empathy, understanding, and respect with diversity of thought, perspective, and experiences.
For more information on benefits, visitwww.mi.gov/employeebenefits.
Don't miss out on this opportunity to come work with us!
To be considered for this position you must:
Apply for this position online via NEOGOV; click on "Apply" in the job posting for instructions on submitting your electronic application. Hard copy applications are not accepted.
Relevant experience and/or education referred to in the supplemental questions must be documented in the resume, transcripts, and application to allow for accurate screening.
Attach a current cover letter and detailed resume identifying specific experience and dates of employment.
If applicable, attach a copy of official transcript(s). We accept scanned or electronic copies of official transcripts if they contain the following elements: college/university name and address, degree conferred, date granted, coursework completed, and the registrar's signature and/or seal.?
Failure to complete any of the above items may result in your application not being considered and screened out. See instructions for attaching files here: Instructions(Download PDF reader)
Your application for any position does not guarantee that you will be contacted by the Department/Agency for further consideration. Only those applicants interviewed will be notified of the results.
Visit the Michigan Civil Service CommissionState Employmentwebsite for useful information about the job search and application process.
In accordance with federal law, all new employees must provide proof of identity and eligibility to work in the United States within three business days of beginning employment. DTMB Human Resources uses E-Verify in conjunction with the federal I-9 form to verify authorization of employment. If selected for employment, you must be able to submit proof of your legal right to work in the United States. DTMB does not offer employment sponsorship and DTMB does not participate in STEM-OPT.
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
DEPTALTE - 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.
03
Applicants that will earn a bachelor's degree at the end of the current academic year may answer "yes" to official transcripts attached in the question #1. Please note that if you are the selected candidate, no conditional offer of employment can be made until official transcripts have been provided and approved. If your bachelor's degree will be awarded by the end of the current academic year, please provide the expected graduation date.
04
Within the last 5 years, how many years of experience do you have leveraging large databases to pull, analyze, and transform data given a set of parameters and criteria?
None
Less than 6 months
6 months to 2 years
3-5 years
More than 5 years
05
Please describe your experience leveraging large databases to pull, analyze, and transform data given a set of parameters and criteria. If no experience, please answer N/A.
06
How many years of experience do you have gathering, analyzing, and documenting business needs from a group of stakeholders?
None
Less than 6 months
6 months to 2 years
3-5 years
More than 5 years
07
Please describe your experience gathering, analyzing, and documenting business needs from a group of stakeholders. If no experience, please answer N/A.
08
Within the last 5 years, how much experience do you have with testing data migrations, ETLs, reporting outputs or analyses?
None
Less than 6 months
6 months to 2 years
3-5 years
More than 5 years
09
Please describe your experience with testing data migrations, ETLs, reporting outputs or analyses. If no experience, please answer N/A.
10
How many years of experience do you have writing SQL queries?
None
Less than 6 months
6 months to 2 years
3-5 years
More than 5 years
11
Within the last five years, how much experience do you have working with SAS Enterprise Guide, Azure Synapse, MS Power BI, or any other statistical or reporting software package?
None
Less than 6 months
6 months to 2 years
3-5 years
More than 5 years
12
Please describe your experience working with SAS Enterprise Guide, Azure Synapse, MS Power BI or any other statistical or reporting software package.
13
Are the responses to the above supplemental questions reflected in your application and supporting materials? Please note, if information is not accurately reflected, you could be screened out.
Yes
No
14
To collect SBO recruitment effort data, please select from below how you learned of this job opportunity. We appreciate the feedback!
College/University Career Services Office
College/University Career Fair
Employee Referral
GONGWER
Handshake
LinkedIn
Michigan Works! Agency
NEOGOV Job Alert
Other Job Posting Site (Indeed, ZipRecruiter)
Pure Michigan Talent Connect
State of Michigan Virtual Career Fair
Veterans Organization
X (previously Twitter)
15
If you selected Other Job Posting, Veteran's Organization, or Employee Referral in the previous question, please identify the source or employee name for which you learned of this opportunity.
16
Do you understand this job will require working onsite at the official work location in Lansing, MI a minimum of 1 day per week?
Yes
No
17
Did you attach current cover letter and detailed resume to your application?
Yes
No
18
In accordance with federal law, all new employees must provide proof of eligibility to work in the United States within three business days of beginning employment. The Department of Technology, Management, and Budget does not offer any @type of employment sponsorship or participate in STEM-OPT. If selected for employment, are you able to submit proof of your legal right work in the United States?
Yes
No
Required Question
Employer
State of Michigan
Department
Technology, Management and Budget
Address
DTMB-HR@michigan.gov
Elliott-Larsen Bldg., 2nd fl., 320 S. Walnut Street
Lansing, Michigan, 48909
Phone
Attn: HR Office
Website
https://www.michigan.gov/dtmb
Apply
Please verify your email addressVerify Email
