ITPA11 - Data Warehouse Modeler

State-of-Michigan; Lansing (MI); Hybrid; USD 70,000 - 90,000; Full time

Benefits offered by this job

Signing bonus up to $2,500

Hybrid work schedule

MVAA veteran-friendly employer

Job summary

State of Michigan’s Department of Technology Management and Budget seeks an Information Technology Programmer Analyst to design, develop, and maintain MDHHS Data Warehouse database models. You will ensure naming standards and collaborate across data warehouse teams to implement scalable data structures.

Hybrid work is available (two days on-site in Lansing, three days remote). A bachelor’s degree in relevant fields is required, with additional IT experience and certification as applicable.

Qualifications

• Bachelor's degree with 21 semester credits in computer science or related field.
• Two years of IT experience or substitution options described in the posting.
• Ability to work with data warehouse models and MDHHS DW standards.

Responsibilities

• Design, development, and maintenance of database models for the MDHHS Data Warehouse.
• Coordinate team activities with other data warehouse teams on complex multi-team projects.
• Review and modify DDL, ensure naming and definitional standards are followed.
• Collaborate to review existing structures and propose design improvements.

Skills

Database modeling

Data warehouse

DDL design

Team coordination

Standards adherence

Education

Bachelor's degree in CS or related

Associate degree plus experience option

Tools

SQL

Data modeling tools

Job description

The Department of Technology, Management and Budget 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.

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

Education

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.

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.

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: https://www.michigan.gov/mdcs/-/media/Project/Websites/mdcs/JOBSPECS/I/InformationTechnologyProgrammerAnalyst.pdf