Senior Healthcare Data Architect - Remote

GovCIO; Hartford (CT); 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 healthcare data integration for the VA. You will analyze source databases and build objects to support CDW ingestion, emphasizing data modeling, governance, and PHI/PII handling. This is a fully remote US-based position.

The role requires advanced T-SQL, SSIS/SSAS, Power BI, and experience with Millennium, VistA, and related systems. You will collaborate across data stewards, DBAs, and ETL teams.

Qualifications

• Bachelor’s degree in Computer Science, Engineering, or related field with 14+ years of relevant experience; or a Master’s with 10+ years; or equivalent.
• Experience with healthcare data domains and Millennium data interactions.
• Ability to identify PHI/PII across Millennium, VistA, ADR, MVI and related systems.
• Advanced proficiency in T-SQL, indexing, partitioning, and query optimization.
• Experience with SSIS, SSAS, and Power BI for data integration/visualization.
• Strong ERD/data lineage and data modeling skills.
• Familiarity with Kimball, Inmon, Data Vault methodologies.
• Experience with data governance and CDW standards.

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 conceptual, logical, and physical data models for scalable enterprise data integration.
• Conduct source-to-target analysis and mapping; document transformations and integration requirements.
• Collaborate with data stewards, SMEs, DBAs, ETL developers, and extraction teams across the lifecycle.
• Create and deploy data models and metadata using the CDW MDR Editor; contribute to workflow improvements.
• Develop Data Domain Design Documents with ERDs, data lineage, and source-to-target mappings for governance.
• Ensure adherence to CDW standards, governance policies, security requirements, and EA guidelines.
• Investigate data quality issues and coordinate root-cause analysis with technical and business teams.

Skills

T-SQL

SSIS/SSAS

Power BI

Data modeling

Data governance

PHI/PII handling

Healthcare data analysis

Performance tuning

Collaboration with SMEs/DBAs

Documentation

Education

Bachelor's degree in Computer Science or related field

Tools

Embarcadero

TOAD

MDR Editor

Job description

GovCIO is hiring a Data Engineer and Architect to support healthcare data integration for the VA. You will analyze source databases and build objects to support CDW ingestion, emphasizing data modeling, governance, and PHI/PII handling. This is a fully remote US-based position.

The role requires advanced T-SQL, SSIS/SSAS, Power BI, and experience with Millennium, VistA, and related systems. You will collaborate across data stewards, DBAs, and ETL teams.