"Alerted.org

Longitudinal Data Analyst - Departmental Analyst 9-P11 - State Budget Office

Print (https://www.governmentjobs.com/careers/michigan/jobs/newprint/4923750)

Apply



Longitudinal Data Analyst - Departmental Analyst 9-P11 - State Budget Office

Salary

$25.10 - $39.33 Hourly

Location

Lansing, MI

Job Type

Limited Term (position has expiration date)

Remote Employment

Flexible/Hybrid

Job Number

0701-25-30-56NG

Department

Technology, Management and Budget

Opening Date

04/30/2025

Closing Date

5/7/2025 11:59 PM Eastern

Bargaining Unit

NON-EXCLUSIVE REPRESENTED EMPLOYEE (NERE)

+ Description

+ Benefits

+ Questions

Job Description

About this position:

The Center 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.

CEPI is recruiting to fill aLongitudinal Data Analystposition in its Longitudinal Data Unit to perform a full range of analytical and report assignments in a manner that accurately portrays information on Michigan’s students, staff, and schools.

As the Longitudinal Data Analyst your primary activities will include:

+ Serving as a core project member supporting the build of a new, standards based Statewide Longitudinal Data System.

+ Providing expertise toward the implementation, operation and maintenance of the system including facilitating the development of new data structures within the system and testing data loading processes.

+ Meeting with stakeholders to understand their data reporting needs and then developing and executing procedures to create reports, summary data, data marts and dashboards.

Online application must contain detailed work experience. It will be used as the primary source for the review of your qualifications. For more information about this posting, please review the position duties listed in the provided links:

POSITION DESCRIPTION (https://mcsc.state.mi.us/AgencyPDFs/LDU\_LT\_%20Analyst%209-11.2023.docx)

JOB SPECIFICATION

Position Location/Remote Office: The office location is in Lansing, MI. The Center for Educational Performance and Information 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 us unable to offer employment to non-Michigan residents that do not plan to relocate.

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 that will earn a bachelor’s degree at the end of the current semester/school year may be considered with a scanned or electronic copy of unofficial transcripts. Please note, the final offer of employment is made once official transcripts are received and approved.

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.

Alternate 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.

Additional Requirements and Information

Serve Michigan with a Career in State Budget Office

Accounting / Auditing / Budgeting / Finance / Systems Data and Research

State Budget Office/Center for Educational Performance and Information is committed to providing an inclusive work environment that encompasses a culture of empathy, understanding, and respect with diversity of thought, perspective, and experiences.

Working for the Center for Educational Performance and Information is both rewarding and challenging.

+ Our team members work together through problem solving, collaborating, and supporting one other.

+ Idea sharing and formation is encouraged to support continued growth throughout our teams.

+ Staff are provided 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, visit www.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 resume identifying specific experience and dates of employment. Dates of employment should include month and year and hours per week.

+ Attach a cover letter.

+ 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.

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.

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

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

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 - 2 years

+ 3-5 years

+ More than 5 years

04

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.

05

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 - 2 years

+ 3-5 years

+ More than 5 years

06

Please describe your experience gathering, analyzing, and documenting business needs from a group of stakeholders. If no experience, please answer N/A.

07

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 - 2 years

+ 3-5 years

+ More than 5 years

08

Please describe your experience with testing data migrations, ETLs, reporting outputs or analyses. If no experience, please answer N/A.

09

How many years of experience do you have writing SQL queries?

+ None

+ Less than 6 months

+ 6 months - 2 years

+ 3-5 years

+ More than 5 years

10

Within the last five years, how much experience do you have working with SAS Enterprise Guide, Azure Synapse, PowerBI, or any other statistical or reporting software package?

+ None

+ Less than 6 months

+ 6 months - 2 years

+ 3-5 years

+ More than 5 years

11

Please describe your experience working with SAS Enterprise Guide, Azure Synapse, PowerBI, or any other statistical or reporting software package. If no experience, please answer N/A.

12

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

13

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 Capitol Jobs Marketplace

+ Handshake

+ LinkedIn

+ Michigan Civil Service Office of Career Services

+ Michigan Works! Agency

+ Other Job Posting Site (Indeed, ZipRecruiter)

+ Pure Michigan Talent Connect

+ State of Michigan Career Fair

+ NEOGOV job alert

+ Veterans Organization

+ X (previously Twitter)

14

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.?

15

Do you understand that this position will require working onsite a minimum of one (1) day per week?

+ Yes

+ No

16

Did you attach official transcripts, current cover letter and detailed resume to your application?

+ Yes

+ No

17

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. If selected for employment, are you able to submit proof of your legal right to work in the United States?

+ Yes

+ No

Required Question

Employer

State of Michigan

Department

Technology, Management and Budget

Address

[email protected]

Elliott-Larsen Bldg., 2nd fl., 320 S. Walnut Street

Lansing, Michigan, 48909

Phone

Attn: HR Office

Website

www.michigan.gov/dtmb

Apply

Please verify your email addressVerify Email