Salary: $24.32 - $44.63 Hourly
Location : Lansing, MI
Job Type: Permanent Full Time
Remote Employment: Flexible/Hybrid
Job Number: 0801-26-21-155AM
Department: Technology, Management and Budget
Opening Date: 08/24/2026
Closing Date: 9/7/2026 11:59 PM Eastern
Bargaining Unit: NON-EXCLUSIVE REPRESENTED EMPLOYEE (NERE)
Job DescriptionThe supports the business operations of state agencies through a variety of services, including building management and maintenance, information technology, centralized contracting and procurement, budget and financial management, space planning and leasing, construction management, motor vehicle fleet operations, and oversight of the state retirement systems. This position is with the Agency Services area of DTMB.
This position functions as an information technology analyst responsible for design, development, and maintenance of logical and physical database models for the Michigan Department of Health and Human Services (MDHHS) Data Warehouse (DW) databases located on the State of Michigan Enterprise Data Warehouse (EDW). The MDHHS Data Warehouse modeler serves as a primary source of strategic and operational information. The Data Warehouse Modeler needs to understand the current models and determine models to be developed based on the needs of the agency. Additionally, this position ensures standards, such as naming, abbreviation, definitional, and diagram, are followed to ensure consistency and adherence to best practices. The position will represent the team and coordinate team activities with other data warehouse teams on complex, multi-team projects, and will work with other data warehouse developers to review existing data warehouse structures, modify DDL work items as needed, or propose different designs.
DTMB does not participate in STEM-OPT. ITPA P11 -- Position DescriptionPosition Location/Remote Office: The office location is Lansing, MI. The State of Michigan is not able to offer employment to out-of-state applicants that do not plan to relocate. The Department of Technology Management and Budget currently offers a hybrid work option which requires two days working on-site at the official work location and three days of remote work per week.
SIGNING BONUS:This position may be eligible for a sign-on bonus of up to $2,500. Up to $1,250 to be paid upon new hire and the remainder to be paid after satisfactory completion of the initial probationary period (12-month period). This does not apply to current state employees.
DTMB is proud to be a Michigan Veteran's Affairs Agency (MVAA) Gold Level Veteran-Friendly Employer.
Required Education and Experience EducationInformation Technology Programmer/Analyst P11Possession of a Bachelor's degree with 21 semester (32 term) credits in one or a combination of the following: computer science, data processing, computer information systems, data communications, networking, systems analysis, computer programming, information assurance, IT project management or mathematics.
ExperienceNo specific type or amount is required.
Alternate Education and Experience Information Technology Programmer/Analyst P11 Possession of an associate's degree with 16 semester (24 term) credits in computer science, information assurance, data processing, computer information, data communications, networking, systems analysis, computer programming, IT project management, or mathematics and two years of experience as an application programmer, computer operator, or information technology technician; or two years (4,160 hours) of experience as an Information Technology Student Assistant may be substituted for the education requirement.
OR
Educational level typically acquired through completion of high school and four years of experience as an application programmer, computer operator, information technology technician, or four years (8,320 hours) of experience as an Information Technology Student Assistant may be substituted for the education requirement.
Additional Requirements and InformationTo 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, transcript and/or 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.
- If applicable, attach a copy of an official transcript(s). We accept scanned copies of official transcripts. We do not accept web-based, internet, or copies of unofficial transcripts. Official transcripts provide the name of the institution, confirmation that a degree was awarded and on what date, and the registrar's signature.
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: 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 eligibility to work in the United States within three business days of beginning employment. If selected for employment, you must be able to submit proof of your legal right to work in the United States.Certain positions may require certification in specific information technology programs.
View the job specification at:
AccommodationsIf you require a reasonable accommodation to participate in the application or selection processes, please contact the 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
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 at
Vacation and Sick Leave: Eligible full-time employees receive between
15 and 35 personal days and
13 sick days per 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 leave immediately 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 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
ITPRAN11 - Do you possess one of the following?A bachelor's degree or higher with at least 21 semester (32 term) credits in one or a combination of the following: computer science, data processing, computer information systems, data communications, networking, systems analysis, computer programming, information assurance, IT project management, or mathematics. If so, please attach a copy of your official college transcripts.ORAn associate's degree or higher with at least 16 semester (24 term) credits in one or a combination of the following: computer science, data processing, information assurance, data processing, computer information, data communications, networking, systems analysis, computer programming, IT project management, or mathematics; and at least 2 years of experience as an application programmer, computer operator, or information technology technician; or at least two years (4,160 hours) of experience as an Information Technology Student Assistant. If so, please attach a copy of your official college transcripts.ORAt least an educational level typically acquired through the completion of high school, and at least 4 years of experience as an application programmer, computer operator, information technology technician, or at least four years (8,320 hours) of experience as an Information Technology Student Assistant.
02
How many years of experience do you have with Teradata?
- None
- Less than 1 year
- 1 to 3 years
- 3 to 5 years
- More than 5 years
03
If you indicated you have experience, please describe. If you have no experience, enter NA.
04
4) How many years of experience do you have with Azure DevOps?
- None
- Less than 1 year
- 1 to 3 years
- 3 to 5 years
- More than 5 years
05
If you indicated you have experience, please describe. If you have no experience, enter NA.
06
How many years of experience do you have with database modeling tools?
- None
- Less than 1 year
- 1 to 3 years
- 3 to 5 years
- More than 5 years
07
If you indicated you have experience, please describe. If you have no experience, enter NA.
08
What are the different types of data models? Please describe each briefly.
09
Did you attach a cover letter, resume, and transcripts?Please note that all experience described in the questions above must be documented within your application materials.
10
This position is hybrid which requires a minimum of 2 days working in office at your designated work location within Michigan. Do you acknowledge this requirement, and would you still like to be considered for this position?
11
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. If selected for employment, are you able to submit proof of your legal right to work in the United States?
Required Question
Never miss an opportunity! Create an alert based on the job you applied for.