Remote Healthcare Data Architect for Enterprise CDW

GovCIO; Trenton (NJ); 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 VA healthcare data integration into the Corporate Data Warehouse (CDW). You will analyze source systems like VistA and Millennium, design database objects, and build scalable data models to enable robust data ingestion.

Responsibilities include data governance, data quality resolution, and collaboration with SMEs, DBAs, ETL teams across the data lifecycle. This is a fully remote role across the United States.

Qualifications

• Bachelor's or higher degree in CS/Engineering or related field with extensive experience.
• Experience with Millennium, VistA, ADR, MVI, GeoSpatial data and PHI/PII handling.
• Strong SQL Server skills including T-SQL, indexing, partitioning, and performance tuning.
• Proficiency with SSIS, SSAS, and Power BI for data integration/visualization.
• Knowledge of data governance, CDW standards, and data catalogs.
• Experience collaborating with SMEs, DBAs, ETL developers, and source extraction teams.
• Familiarity with Embarcadero or TOAD tools.
• Experience with maintaining data lineage, ERDs, and data modeling processes.

Responsibilities

• Analyze source systems to define data structures, rules, and PHI/PII classification.
• Design and maintain database objects to support CDW ingestion.
• Create conceptual, logical, and physical data models for enterprise integration.
• Document transformations and mappings for CDW data flow.
• Collaborate with data stewards, DBAs, ETL teams across the data lifecycle.
• Develop and deploy data models using MDR Editor and contribute tool improvements.
• Produce Data Domain Design Documents with ERDs and source-to-target mappings.
• Ensure CDW standards, governance, and security compliance.
• Investigate data quality issues and resolve via root-cause analysis.

Skills

T-SQL

SQL Server

Data modeling

Data governance

PHI/PII handling

ETL/SSIS

SSAS

Power BI

CDW knowledge

Healthcare data analysis

DBA collaboration

Education

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

14+ years of relevant experience

Master's degree (preferred)

Tools

Embarcadero

TOAD

MDR Editor

Job description

GovCIO is hiring a Data Engineer and Architect to support VA healthcare data integration into the Corporate Data Warehouse (CDW). You will analyze source systems like VistA and Millennium, design database objects, and build scalable data models to enable robust data ingestion.

Responsibilities include data governance, data quality resolution, and collaboration with SMEs, DBAs, ETL teams across the data lifecycle. This is a fully remote role across the United States.