Remote Healthcare Data Architect & CDW Specialist

GovCIO; Austin (TX); Remote; USD 165,000 - 185,000; Full time

Benefits offered by this job

Flexible Work Environment

Learning & Development platform

Certification assistance

Job summary

GovCIO is seeking a Data Engineer and Architect to support Department of Veterans Affairs healthcare data integration. You will analyze source systems like VistA and Millennium and design scalable CDW data models and metadata to enable ingestion into the CDW.

Responsibilities include building and maintaining database objects, ensuring governance, security, and data quality, and collaborating with SMEs, DBAs, ETL developers, and data-extraction teams across the lifecycle.

Qualifications

• Bachelor's degree in Computer Science, Engineering, or related field; 14+ years experience or Master’s with 10+ years
• Intermediate to advanced knowledge of healthcare data domains and Millennium Experience

Responsibilities

• Analyze source systems (VistA, Millennium, ADR, MVI, Geospatial, PIT, Exam Management) to define data structures and PHI/PII classification.
• Design and maintain database objects (tables, views, stored procedures) for CDW ingestion.
• Build data models (conceptual, logical, physical) for enterprise data integration.
• Document and map source-to-target transformations and requirements for CDW.
• Collaborate with SMEs, DBAs, ETL developers, and source extraction teams across the data domain lifecycle.
• Develop and maintain Data Domain Design Documents (DDDs) and metadata using MDR Editor; contribute to tool improvements.
• Ensure compliance with CDW standards, governance, security, and EA guidelines.
• Investigate and resolve data quality issues and support Helpdesk requests.

Skills

T-SQL

SSIS

SSAS

Power BI

Data modeling

Kimball/Inmon/Data Vault

PHI/PII handling

CDW standards

Collaboration

Education

Bachelor's degree in Computer Science, Engineering, or related field

Master's degree (preferred)

Tools

Embarcadero

TOAD

Job description

GovCIO is seeking a Data Engineer and Architect to support Department of Veterans Affairs healthcare data integration. You will analyze source systems like VistA and Millennium and design scalable CDW data models and metadata to enable ingestion into the CDW.

Responsibilities include building and maintaining database objects, ensuring governance, security, and data quality, and collaborating with SMEs, DBAs, ETL developers, and data-extraction teams across the lifecycle.