Senior Healthcare Data Architect (Remote)

GovCIO; Annapolis (MD); À distance; USD 165 000 - 185 000; Plein temps

Avantages offerts par ce poste

Employee Assistance Program (EAP)

Corporate Discounts

Learning & Development platform

Training, Education and Certification

Referral Bonus Program

Internal Mobility Program

Pet Insurance

Flexible Work Environment

Résumé du poste

GovCIO is actively seeking a Data Engineer and Architect to support VA healthcare data integration into the Corporate Data Warehouse (CDW). The role analyzes source systems and designs database objects to enable scalable data ingestion, with strong SQL, data modeling, and governance focus.

Remote in the United States. Responsibilities include data modeling, metadata deployment via MDR Editor, and collaboration with data stewards, DBAs, ETL teams, and source extraction partners to ensure CDW

Qualifications

• Bachelor's degree in Computer Science, Engineering, or related field with 14+ years of relevant experience; or a Master's degree with 10+ years of experience; or equivalent professional experience.
• Intermediate to advanced knowledge of healthcare data domains, with expertise analyzing clinical business operations and data interactions in Millennium.
• Ability to identify and handle PHI/PII 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 SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and Power BI for data integration and visualization.
• Strong database design skills, including ERDs, data lineage flows, and conceptual/logical/physical data modeling.
• Expertise in scalable data architecture methodologies (Kimball, Inmon, Data Vault).
• Familiarity with database management tools such as Embarcadero or TOAD.
• Skilled in investigating and resolving data quality issues (e.g., duplicates, invalid formats, orphaned references) collaborating with extraction teams on resolution
• Familiarity with data governance processes, including data catalogs and CDW standards compliance.
• Strong collaboration skills working with SMEs, DBAs, ETL developers, and source extraction teams to maintain an integrated data environment.
• Experience supporting maintenance outages, query optimization, and data security compliance.
• Outstanding documentation skills, producing DDDs, ERDs, source-to-target mappings, and process documentation.

Responsabilités

• Analyze source systems (VistA, Millennium, ADR, MVI, Geospatial, PIT, Exam Management) to define data structures, relationships, business rules, and PHI/PII classification.
• Design and maintain database objects (tables, views, stored procedures) supporting CDW data ingestion.
• Build conceptual, logical, and physical data models that enable scalable enterprise data integration.
• Perform source-to-target analysis and mapping, documenting transformations and integration requirements to ensure CDW consistency.
• Partner with data stewards, SMEs, DBAs, ETL developers, and source extraction teams across the data domain lifecycle, including maintenance outages and query optimization support.
• Create and deploy data models and metadata using the CDW Metadata Repository (MDR) Editor; contribute to tool enhancements that improve team workflows.
• Develop and maintain Data Domain Design Documents (DDDs) — including overviews, ERDs, source inventories, data lineage flows, business rules, and source-to-target mappings — along with supporting documentation for governance review.
• Ensure compliance with CDW standards, data governance policies, security requirements, and enterprise architecture guidelines.
• Investigate and resolve data quality issues (duplicates, invalid values/formats, orphaned references, inconsistencies) and respond to Helpdesk requests through root-cause analysis with technical and business teams.

Connaissances

T-SQL

SSIS

SSAS

Power BI

Data modeling

Data governance

PHI/PII handling

Healthcare data

VistA/Millennium

ETL

SQL Server

Formation

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

Master's degree with 10+ years experience

Outils

MDR Editor

TOAD

Embarcadero

Description du poste

GovCIO is actively seeking a Data Engineer and Architect to support VA healthcare data integration into the Corporate Data Warehouse (CDW). The role analyzes source systems and designs database objects to enable scalable data ingestion, with strong SQL, data modeling, and governance focus.

Remote in the United States. Responsibilities include data modeling, metadata deployment via MDR Editor, and collaboration with data stewards, DBAs, ETL teams, and source extraction partners to ensure CDW