Description

OIS currently requires an experienced Enterprise Architect with expertise in analyzing existing data architectures and developing modern rationalized data models, optimizing interactions with and within the database (SQL, stored procedures, ETL, etc.), in accordance with business, data security and regulatory requirements.

This will work towards fulfilling OIS twelve-month plan items including enterprise data catalog activities, enterprise data dictionary activities, and modernization vision and technology standards creation.

Contractor’s Key Person will also work with various program areas and business teams and the Enterprise Information Architect to develop a strategic roadmap to execute data modernization efforts.

Scope:

Contractor’s Key Person under this WOC will participate in setting the strategic direction for use of data to support OHA and DHS programmatic and administrative functions. Contractor’s Key Person will provide expertise in the planning efforts to identify and modernize the agency’s data catalogs, data dictionaries, databases, and data repositories and to define the future-state technical environment for OHA and DHS. The Enterprise Architect will facilitate the conversion of strategies to actions and identify ways to optimize the agency’s data for improved agency capture, storage and use.

The Enterprise Architect will play a critical role in building or buying the technology that will help DHS/OHA meet its business goals and long-term use of data for critical decision making. Contractor’s Key Person will provide expertise in solving data integration problems, creating a plan for security classification of data, and optimization and modernization of systems for the most effective use of data.

The Enterprise Architect will evaluate existing and develop new data architectures of systems included in various projects (e.g., OR-Kids, MMIS and COMPASS) as well as plan the data modernization and security efforts around these program solutions.

Tasks

Contractor’s Key Person shall:

• Audit existing data systems; models, queries, data quality, security, etc. and provide recommendations and a suggested roadmap for modernization.


• Provide data architecture training to development staff regarding the following topics: data modeling, data quality, data governance, database change management, standards development, data auditing and data governance


• Develop recommended data modeling standards for consideration; best practices


• Develop recommended table and column naming conventions/standards; best practices


• Develop recommended datatype standards; based on existing datatype standards where available and appropriate; address standards published by the United States Postal Service as an example; best practices


• Develop data security and access models


• Develop data security classifications process for classifying data based on the State of Oregon data classification guidelines


• Develop database administration standards and processes, including change control, to inform Agency’s SDLC process, and train staff in the application and use of these standards and processes; data model-driven change implementation processes for example


• Develop a data (or database) change request process with the developer and Data Resource Management teams


• Develop a data catalog for the data systems audited using the agency’s data catalog template.