ITPA12 - Data Warehouse ETL Developer

Full 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 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. The 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 DevOps 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.

ITPA 12 -- Position Description

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.

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.

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

Requirements

Education

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.

Experience

Information Technology Programmer/Analyst 12
Two years of professional experience equivalent to an Information Technology Infrastructure or Programmer/Analyst P11.

Qualifications

Additional Information

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, 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(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 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