> Markdown version of [/jobs/ext/2237996-itpa11-data-warehouse-modeler](https://www.wearedevelopers.com/jobs/ext/2237996-itpa11-data-warehouse-modeler). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # ITPA11 - Data Warehouse Modeler - **Company:** State of Michigan - **Location:** Lansing, MI, United States (Remote available) - **Experience:** Experienced - **Salary:** $50,586.0 - $92,830.0 - **Contract:** Permanent contract - **Skills:** Computer Programming, Databases, Data Transmissions, Data Warehousing, Systems Analysis, Data Processing, Information Technology - **Published:** August 26, 2026 - **Apply:** https://jobs.mitalent.org/job-seeker/job-details/JobCode/404221420 ## About the Role Information Technology Programmer/Analyst P11 Possession 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. Experience No specific type or amount is required., 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., 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. ## Description TheDepartment of Technology, Management and Budget (https://youtu.be/H_IrVnVjcoA) 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., * 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: Instructions (http://www.michigan.gov/documents/mdcs/New_Online_Employment_Application_Guide_-_First_Time_User_446027_7.pdf) (Download PDF reader) ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Implementing continuous delivery in a data processing pipeline](https://www.wearedevelopers.com/videos/73-implementing-continuous-delivery-in-a-data-processing-pipeline) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Databaseless Data Processing - High-Performance for Cloud-Native Apps and AI](https://www.wearedevelopers.com/videos/1024-databaseless-data-processing-high-performance-for-cloud-native-apps-and-ai) - [Analytics in the Age of Agentic AI: A tour of ClickHouse and Langfuse](https://www.wearedevelopers.com/videos/100240-analytics-in-the-age-of-agentic-ai-a-tour-of-clickhouse-and-langfuse) - [Why and when should we consider Stream Processing frameworks in our solutions](https://www.wearedevelopers.com/videos/1085-why-and-when-should-we-consider-stream-processing-frameworks-in-our-solutions) ## Related Articles - [System change: restart as developer?](https://www.wearedevelopers.com/magazine/39-system-change-restart-as-developer) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [IT Salaries in Germany](https://www.wearedevelopers.com/magazine/287-it-salaries-in-germany) - [How should you format your IT resume?](https://www.wearedevelopers.com/magazine/68-how-should-you-format-your-it-resume) - [IT Salaries in UK](https://www.wearedevelopers.com/magazine/288-it-salaries-in-uk)