Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

Database Enterprise Architect (1304 views)

Salem, OR
April 15, 2020

**** Direct Client Requirement ****

Title: Database Enterprise Architect

Location:  Salem, OR

Duration: 6 Months

Rate: DOE

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                                    

Advanced                                                        No         

Skills                     Data architecture Data architecture analysis, development and recommendations                          

Advanced                                                        Yes        

Skills                     Data architecture training Data architecture training                        

Proficient                                                        Yes        

Skills                     Data catalogs                                                  Develop data catalogs                 

Advanced                                                        Yes        

Skills                     Data classification                                              Data classification                      

Advanced                                                        Yes        

Skills                     Data integration                                                  Expertise in solving data integration                             

Advanced                                                        Yes        

Skills                     Data modeling standards                                   Develop recommended data modeling standards and best practices                   

Advanced                                                        Yes        

Skills                     Data models                                                     Developing modern rationalized data models                

Advanced                                                        Yes        

Skills                     Data optimization                                                  Data optimization                  

Advanced                                                        Yes        

Skills                     Data security classifications                               Develop data security classifications and access control models                          

Advanced                                                        Yes        

Skills                     Database administration standards                           Develop database administration standards and processes                 

Advanced                                                        Yes        

Skills                     Datatype standards                                  Develop recommended datatype standards                          

Advanced                                                        Yes        

Skills                     Naming conventions                       Develop recommended table and column naming conventions/standards and best practices                             

Proficient                                                        Yes        

Skills                     SQL optimization                             SQL optimization                            

Advanced                                                        Yes        

Skills                     SQL Server development                SQL Server development                Advanced                                                           Yes

Estimated Duration

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

Don't have time now?
Get a reminder in your inbox