Remote Senior Data Architect for Healthcare CDW

GovCIO; Montgomery (AL); Remote; USD 165,000 - 185,000; Full time

Benefits offered by this job

Employee Assistance Program (EAP)

Corporate Discounts

Learning & Development platform

Training, Education and Certification

Referral Bonus Program

Internal Mobility Program

Pet Insurance

Flexible Work Environment

Job summary

GovCIO is hiring a Data Engineer and Architect to support the healthcare data integration for the Department of Veterans Affairs (VA). This role analyzes source database systems and develops database objects to support data ingestion into the Corporate Data Warehouse (CDW).

The position requires strong database design and SQL skills, along with experience with healthcare data and source systems such as VistA and Oracle Health Millennium. This position is fully remote in the United States.

Qualifications

• Bachelor’s degree in Computer Science, Engineering, or related field with 14 years of relevant experience; or a Master’s degree with 10 years of experience; or equivalent professional experience.
• Advanced proficiency in T‑SQL, indexing, partitioning, and performance tuning.
• Experience with SSIS, SSAS, and Power BI for data integration and visualization.
• Strong database design skills including ERDs, data lineage, and modeling.
• Familiarity with healthcare data domains and CDW standards.

Responsibilities

• Analyze source systems (VistA, Millennium, ADR, MVI, Geospatial, PIT, Exam Management) to define data structures and PHI/PII rules.
• Design and maintain database objects (tables, views, stored procedures) for CDW ingestion.
• Build conceptual, logical, and physical data models for enterprise data integration.
• Perform source-to-target analysis and mapping with documentation.
• Collaborate with SMEs, DBAs, ETL developers, and source extraction teams across lifecycle.
• Develop and maintain DDDs, ERDs, and data lineage flows with governance in mind.
• Ensure compliance with CDW standards, security requirements, and enterprise architecture.
• Investigate data quality issues and coordinate with teams for resolution.

Skills

SQL

T-SQL

SSIS

SSAS

Power BI

Data modeling

ERD/DDD

Data governance

Millennium

VistA

Education

Bachelor’s degree in CS/Engineering or related field

Master’s degree with 10 years experience

Tools

Embarcadero

TOAD

Job description

GovCIO is hiring a Data Engineer and Architect to support the healthcare data integration for the Department of Veterans Affairs (VA). This role analyzes source database systems and develops database objects to support data ingestion into the Corporate Data Warehouse (CDW).

The position requires strong database design and SQL skills, along with experience with healthcare data and source systems such as VistA and Oracle Health Millennium. This position is fully remote in the United States.