**** Direct Client Requirement ****
Title: Database Enterprise Architect
Location: Salem, OR
Duration: 6 Months
Interview Type: Skype or In Person
Work Status: Successful applicants must be legally authorized to work in the U.S.
Job Type: C2C,C2H ,W2,
Experience: 10 YEARS
The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and the Department of Human Services (DHS). OIS provides the technology systems and services that support more than 11,000 OHA and DHS agency staff at local offices and facilities around the state. These systems and services help the two agencies determine client service program eligibility; provide medical, housing, food and job assistance; provide addiction, mental health, vocational and rehabilitative services; protect children, seniors and people with physical and/or developmental disabilities; process claims and benefits; manage provider licensing and state hospital facilities; and promote and protect the state public health.
OIS seeks 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.
The selected 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.
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.
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
Our primary criteria are the qualifications and experience of the proposed key person. Please propose your strongest candidate, at a rate less than or equal to the maximum.
Interviews will be conducted via Skype. Interview times will reflect Pacific Standard Time.
Due to circumstances beyond our control, we anticipate two weeks or more for the background check completion for the selected candidate. In addition to the standard OHA/DHS background check, the selected candidate will need to pass a CJIS background check. This will likely add to the background check process timeline.
Key Person shall initially work on site. Onsite work will follow social distancing guidelines.
After onboarding, the selected key person could potentially telecommute as agreed to between the Agency Authorized Representative and the key person. Any decision to allow telecommuting is made with the understanding that decision will be re-evaluated by the Agency Authorized Representative on a weekly basis. The key person should be available to work onsite within 24 hours notice.
Telecommuting is contingent upon the key person providing his/her own adequate computer, monitor(s), Internet connection, and telephone, and be readily available during normal working hours via phone, email or instant message. Access to Agency systems will be provided via Citrix Remote Desktop or similar software. No hardware or additional software will be provided at the key person’s home site or his/her PC.
If the Agency Authorized Representative and key person agree to allow off-site work, the expectation is for that key person to work onsite as soon as the general workforce transitions back into the Agency workplace.
Work schedule is typically Monday – Friday, 8 AM – 5 PM Pacific Standard Time.
Skills Communication skills both verbal and written
Skills Data architecture Data architecture analysis, development and recommendations
Skills Data architecture training Data architecture training
Skills Data catalogs Develop data catalogs
Skills Data classification Data classification
Skills Data integration Expertise in solving data integration
Skills Data modeling standards Develop recommended data modeling standards and best practices
Skills Data models Developing modern rationalized data models
Skills Data optimization Data optimization
Skills Data security classifications Develop data security classifications and access control models
Skills Database administration standards Develop database administration standards and processes
Skills Datatype standards Develop recommended datatype standards
Skills Naming conventions Develop recommended table and column naming conventions/standards and best practices
Skills SQL optimization SQL optimization
Skills SQL Server development SQL Server development Advanced Yes
05/11/2020 – 11/06/2020
Position Keywords: SQL Database Enterprise , queries , COMPASS , SQL , vocational , data quality , , MMIS , data models , ETL
Pay Rate: DOE
Job Duration: 6 Months
% Travel Required: None
Job Posted by: Consulting Services
Job ID: 11052-20
Work Authorization: Successful applicants must be legally authorized to work in the U.S