Remote Healthcare Data Architect for CDW

GovCIO; Boise (ID); Remoto; USD 165.000 - 185.000; Tempo pieno

Vantaggi offerti da questo lavoro

Employee Assistance Program

Corporate Discounts

Learning & Development platform

Training, Education and Certification 

Referral Bonus Program

Internal Mobility Program

Pet Insurance

Flexible Work Environment

Descrizione del lavoro

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

Applicants should have strong SQL skills, experience with SSIS/SSAS, and data governance. The role is fully remote across the United States and requires suitability/public trust clearance.

Competenze

• Bachelor's or Master's degree with extensive relevant experience, or equivalent.
• Experience with healthcare data domains and Millennium.
• Advanced proficiency in T-SQL, indexing, partitioning, and query tuning.
• Experience with SSIS/SSAS and Power BI for data integration and visualization.
• Strong database design skills including ERDs and data modeling.
• Familiarity with data governance and CDW standards compliance.
• Collaborates with SMEs/DBAs/ETL developers to maintain integrated data environment.
• Experience supporting maintenance outages, query optimization, and data security compliance.
• Outstanding data documentation skills (DDDs, ERDs, mappings).

Mansioni

• 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 data integration.
• Document transformations and source-to-target mappings for CDW consistency.
• Partner with data stewards, SMEs, DBAs, ETL developers, and source extraction teams across the lifecycle.
• Create and deploy data models and metadata using the MDR Editor; contribute to tool enhancements.
• Develop and maintain Data Domain Design Documents (DDDs) with governance reviews.
• Ensure compliance with CDW standards, data governance, security, and enterprise architecture.
• Investigate and resolve data quality issues and respond to Helpdesk with root-cause analysis.

Conoscenze

T-SQL

SSIS

SSAS

Power BI

Data modeling

Data governance

Data quality

SQL Server

PHI/PII handling

Documentation

Collaboration with SMEs/DBAs/ETL

Formazione

Bachelor's degree in CS/Engineering

Master's degree in a related field

Equivalent professional experience

Strumenti

MDR Editor

Embarcadero

TOAD

Descrizione del lavoro

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

Applicants should have strong SQL skills, experience with SSIS/SSAS, and data governance. The role is fully remote across the United States and requires suitability/public trust clearance.