Senior Healthcare Data Architect - Remote CDW

GovCIO; Phoenix (AZ); Remote; USD 165.000 - 185.000; Vollzeit

Benefits dieser Stelle

Employee Assistance Program (EAP)

Corporate Discounts

Learning & Development platform

Training, Education and Certification

Referral Bonus Program

Internal Mobility Program

Pet Insurance

Flexible Work Environment

Zusammenfassung

GovCIO is seeking a Data Engineer and Architect to support VA CDW data integration, analyzing source systems and designing database objects for ingestion. This role requires strong SQL skills and healthcare data experience, including VistA, Millennium, and related systems.

The position is fully remote in the United States. You will build and maintain data models, datasets, and governance documents, work with SMEs and DBAs, and ensure compliance with CDW standards and security.

Qualifikationen

• Bachelor's degree in CS/Engineering or related field with 14+ years of experience, or Master's with 10+ years.
• Healthcare data domain expertise and Millennium data interactions.
• PHI/PII handling across Millennium, VistA, ADR, MVI, GeoSpatial, PIT, Exam Management, and related systems.
• Advanced proficiency in T-SQL (queries, stored procedures, functions), indexing, partitioning, query optimization, and performance tuning.
• Experience with SSIS, SSAS, and Power BI for data integration and visualization.
• Strong data modeling: ERDs, data lineage flows, and conceptual/logical/physical data modeling.
• Knowledge of scalable data architectures (Kimball, Inmon, Data Vault).
• Familiarity with database tools such as Embarcadero or TOAD.
• Collaborating with SMEs, DBAs, ETL developers, and source extraction teams to resolve data quality.

Aufgaben

• Analyze source systems to define data structures, relationships, and PHI/PII classification.
• Design and maintain database objects supporting CDW data ingestion.
• Build conceptual, logical, and physical data models for enterprise integration.
• Document transformations and integration requirements to ensure CDW consistency.
• Partner with data stewards, SMEs, DBAs, ETL developers, and source teams across the data domain lifecycle.
• Create and deploy data models and metadata using the CDW MDR Editor; contribute to tooling improvements.
• Develop and maintain Data Domain Design Documents (DDDs) with ERDs and data lineage flows.
• Ensure compliance with CDW standards, governance, and security policies.
• Investigate and resolve data quality issues with root-cause analysis.

Kenntnisse

T-SQL

SSIS

SSAS

Power BI

Data Modeling

Data Governance

PHI/PII Handling

Healthcare Data

SQL Server

Performance Tuning

Ausbildung

Bachelor's degree in CS/Engineering or related field

Tools

Embarcadero

TOAD

Jobbeschreibung

GovCIO is seeking a Data Engineer and Architect to support VA CDW data integration, analyzing source systems and designing database objects for ingestion. This role requires strong SQL skills and healthcare data experience, including VistA, Millennium, and related systems.

The position is fully remote in the United States. You will build and maintain data models, datasets, and governance documents, work with SMEs and DBAs, and ensure compliance with CDW standards and security.