Data Warehouse Architect w/ govt. experience - HBITS-07-14610

• 84 months experience working with Agency/business subject matter experts to understand business needs/requirements, Vendors of Commercial Off the Shelf (COTS) Business products, and technology teams to determine and design data warehouse, application and system requirements for a government agency.

• 84 months experience architecting, designing, documenting, and implementing data warehousing, COTS and Custom business application integrations, and master data management for a government agency.

• 84 months experience data modeling and designing normalized Data Warehouse environments for enterprise level applications; and, implementing those designs using Oracle Data Integrator (ODI) and Extract, Transform, Load technologies or a government agency.

• 84 months experience developing data integrations for heterogeneous systems and business intelligence using SQL (Structured Query Language) for a government agency.

• 84 months experience performing database comparative analysis for designing new transactional databases and data warehouses, as well as improvements in existing transactional databases and data warehouses for a government agency.

• 84 months experience in analytical reasoning, computation, interpretation, and presentation of data to solve business problems for a government agency.

• 84 months experience implementing systematic Data Error/Recovery and Cleanup procedures or a government agency.

• 84 months experience integrating with Kafka or a government agency.

_______________________________________________________________________

Agency: NYS Department of Transportation

Detailed Job Description: Act as Expert Database Architect and L2 Technical Operational Support working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below.