Information Technology Programmer/Analyst P11

This position will serve as a statewide administrator for the Enterprise Data Warehouse (EDW), consisting of 3 distinct platforms (Production, Development/DR and Test). The EDW provides Enterprise Data Warehousing services to executive branch agencies as well as the State Court Administrator Offices statewide.  The EDW is considered a Red Card platform.  A total of 4 agencies are supported, with a user base of over 10,000 internal and external clients and 33 Terabytes of data. This position researches and coordinates EDW strategies with all current and potential clients, DTMB management and vendor personnel. This position defines the technical planning, implementation plan, and delivery of the EDW platform service and supporting technologies to meet the State of Michigan's business requirements and objectives. This includes vendor communication, trouble reporting, escalated troubleshooting, and release/patch management. This position is responsible for providing operating system guidance along with EDW security expertise for the systems as well as advising the agencies on disaster recovery planning strategies related to the EDW and their business applications. The position is also responsible for platform performance monitoring and resolving performance issues. 

KNOWLEDGE, SKILLS, AND ABILITIES: 
    
Knowledge of system development methods used for the development of new systems and enhancements to existing information systems.
Knowledge of concepts and basic operating principles of data communications and information systems hardware and software.
Knowledge of principles, theories, techniques, and methods of information system analysis and programming.
Knowledge of contemporary and generative programming languages and techniques.
Knowledge of data communication and transaction-based processing.
Knowledge of the operational and technical problems involved in the administration of a specialized program.
Knowledge of relational database methodology.
Knowledge of the principles of data warehouse systems and supporting technologies.
 

Education
Information Technology Programmer/Analyst P11/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
No specific type or amount is required.

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

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.

 Information Technology Programmer/Analyst P11 - Position Description

Certain positions may require certification in specific information technology programs.

View the job specification at: http://www.michigan.gov/documents/InformationTechnologyProgrammerAnalyst_12733_7.pdf

* Required Question