Enterprise Architect IV-- Data Analysis

Overview

Remote
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 8 Month(s)

Skills

Data Modeling
Data Warehouse
Dimensional Modeling
Documentation
Health Care
Information Systems
Application Development
Data Analysis
Data Governance
Database
ERwin
HIS
MMIS
Meta-data Management
SAP BASIS
Public Sector
Virtual Private Network
PASS
System Requirements
Telecommuting
Star Schema
SQL
Microsoft Visio
Microsoft SQL Server
Internet
Extract
Transform
Load
Communication

Job Details

  • Extensive experience in conceptual and dimensional data modeling, including star schema design for data warehouses.
  • Strong proficiency in data modeling tools such as Microsoft Visio and/or Erwin.
  • Demonstrated ability to create clear and accurate data documentation, including entity definitions, mappings, and data dictionaries.
  • Strong verbal and written communication skills, with the ability to facilitate discussions and document requirements across technical and non-technical audiences.
  • Experience working with data warehouse teams, including DBEs and DBAs, in enterprise environments.
  • Familiarity with human services programs or public sector data systems is preferred.
  • Knowledge of data governance, metadata, and ETL processes is a plus.

Required skills and experience:

  • Data Analysis (7-9 years of experience)
  • Data Modeling in conceptual data modeling for large, complex system (7-9 years of experience)
  • Data Warehousing (4-6 years of experience)
  • SQL (7-9 years of experience)
  • Microsoft Visio and/or Erwin data modeler (4-6 years of experience)
  • Strong understanding, experience in design dimensional models and data modeling methodologies
  • Excellent verbal and written communication
  • Demonstrated ability to work closely with:
  • Business analysts and program subject matter experts
  • Database Engineers
  • Database Administrators
  • External contractors and project team

In addition, the ideal candidate will have skills and experience in:

  • Experience working with public sector, human services, or healthcare data systems (e.g., APD, CAM/CALMS, MMIS)
  • Familiarity with data governance, data cataloging, and metadata management initiatives
  • Experience supporting data warehouse development using SQL Server, Snowflake, or similar platforms


Covendis rate card description for an Enterprise Architect IV:

Responsible for designing and implementing information systems which will adequately support the enterprise infrastructure of the organization. Analyzes system requirements and ensures that systems will offer security and will be effectively integrated with current applications. Ensures that all systems are working at optimal levels and offers support to application development department regarding new technologies and system requirements. Has thorough knowledge of infrastructure, application programming, and web and software applications. Requires a bachelor's degree in area of specialty and at least nine years or equivalent experience in the field or in a related area. Familiar with a variety of the field's concepts, practices, and procedures. Relies on extensive experience and judgement to plan and accomplish goals. Performs a variety of tasks. A wide degree of creativity and latitude is expected.

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 MS Teams. 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/ODHS background check, the selected candidate may need to pass a CJIS background check. This will likely add to the background check process timeline.

This position is approved for remote/hybrid/onsite work.
Onsite/Remote onboarding will be required for the first day.

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 regular basis. The key person should be available to work onsite within a reasonable timeframe.

Telecommuting will be 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 VPN or similar software. No hardware or additional software will be provided at the key person's home site or his/her PC.

For Services that are agreed to occur remotely that those Services will only be completed by the Key Person resourced for the Project and all work must be performed in the United States of America. Remote engagement requires Key Person to have consistent access and/or clarity for: high speed internet, cellular phone/landline phone, web camera and microphone.

OHA/ODHS operates on standard business days (Monday - Friday, 8 AM 5 PM, Pacific Standard Time, except for State of Oregon holidays and business closures) and Key Person must be available to engage with OHA/ODHS during that time frame.

uirements

Please have the candidate complete the required form upon selection. The form is located on the dashboard.

Qualifications

Type Category Qualification Description Competency Required
Skills Database Data Analysis Advanced (7-9 Years) Yes
Skills Database Data Modeling Advanced (7-9 Years) Yes
Skills Database Data Warehousing Proficient (4-6 Years) Yes
Skills Languages SQL Advanced (7-9 Years) Yes
Skills Others Visio Proficient (4-6 Years) Yes

--

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.