Remote Senior Data Architect – Healthcare CDW

GovCIO; Richmond (VA); 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 hiring a Data Engineer and Architect to support VA healthcare data integration into the Corporate Data Warehouse. The role analyzes source databases (VistA, Millennium, ADR, MVI) and designs database objects for CDW ingestion, driving scalable data models and governance compliance.

You will collaborate with data stewards, DBAs, ETL developers and source teams to resolve data quality issues and optimize performance, while maintaining documentation and MDR/CDW standards for a secure data

Qualifikationen

• Bachelor's degree in Computer Science, Engineering, or related field with 14+ years of experience; or Master's with 10+ years.
• Expertise in healthcare data domains and Millennium data interactions.
• Ability to identify PHI/PII across multiple systems including Millennium and VistA.
• 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 and data lineage processes.
• Familiarity with Kimball, Inmon and Data Vault data architecture.
• Knowledge of CDW standards, data governance and security requirements.

Aufgaben

• Analyze source systems to define data structures, relationships and business rules.
• Design and maintain database objects to support CDW ingestion.
• Build conceptual, logical and physical data models for enterprise integration.
• Document transformations and data mappings for CDW consistency.
• Collaborate with SMEs, DBAs and ETL teams across the data lifecycle.
• Create and deploy data models and metadata using the MDR Editor.
• Develop and maintain Data Domain Design Documents with ERDs and mappings.
• Ensure compliance with CDW standards and data governance policies.
• Investigate data quality issues and perform root-cause analysis with teams.

Kenntnisse

T-SQL

SSIS

SSAS

Power BI

Data modeling

Data governance

PHI/PII handling

Query optimization

Ausbildung

Bachelor's degree in CS/Engineering

Master's degree (preferred)

Tools

Embarcadero

TOAD

Jobbeschreibung

GovCIO is hiring a Data Engineer and Architect to support VA healthcare data integration into the Corporate Data Warehouse. The role analyzes source databases (VistA, Millennium, ADR, MVI) and designs database objects for CDW ingestion, driving scalable data models and governance compliance.

You will collaborate with data stewards, DBAs, ETL developers and source teams to resolve data quality issues and optimize performance, while maintaining documentation and MDR/CDW standards for a secure data