ITPA- Data Warehouse ETL Developer

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 a senior information technology analyst responsible for developing, maintaining and enhancing a variety of automated data warehouse ETL applications located on the State of Michigan’s Teradata Data Warehouse platform. This position will represent the team and coordinate team activities with other data warehouse teams on complex, multi-team projects. This position will coordinate and develop test plans and strategies for various types (i.e. integration, system, user acceptance).

This resource will be responsible for mastering knowledge of the business practices, workflows, performance indicators, and predictive factors related to Eligibility areas of MDHHS to best serve our customers. This position will coordinate other testing resources to execute the approved plans, testing approach and testing scripts during a release phase. In addition, the position will work with other data warehouse developers to review existing data warehouse policies and practices, modify work items as needed, or propose new ones.

The ability to work in a hybrid agile programming environment while utilizing Azure Dev Ops is preferred. Knowledge of programming languages and techniques is required, specifically in creating and maintaining PERL, Python, and Unix scripting languages.

DTMB does not participate in STEM-OPT.

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.

ITPA 12:
This position may be eligible for a sign-on bonus 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.

The state of Michigan offers competitive work experience that includes a tuition reduction program at several key higher education institutes if you would like to advance your education, good benefits, excellent vacation, and sick time policies, and an ability to successfully juggle your work and family life. We would like the opportunity to share with you more about the benefits of working for the state and joining the state of Michigan employee family if you are interested.

Please consider sending in your application today.

DTMB is proud to be a Michigan Veteran’s Affairs Agency (MVAA) Gold Level Veteran-Friendly Employer.

Information Technology Programmer/Analyst 12 – 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.

Information Technology Programmer/Analyst 12 – 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,…