Sr. Data Architect (Remote)

Govcio LLC • UNAVAILABLE, UNAVAILABLE

1d • Remote

About The Position

GovCIO is hiring a Data Engineer and Architect to support healthcare data integration for the Department of Veterans Affairs (VA). The role analyzes source database systems and develops database objects that support data ingestion into the Corporate Data Warehouse (CDW). It requires strong database design and SQL skills, as well as experience with healthcare data and source systems such as VistA and Oracle Health Millennium. The position is fully remote in the United States.

Requirements

• Bachelor's degree in Computer Science, Engineering, or a 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, including 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, including queries, stored procedures, and functions, as well as 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, and physical data modeling.
• Expertise in scalable data architecture methodologies such as Kimball, Inmon, and Data Vault.
• Familiarity with database management tools such as Embarcadero or TOAD.
• Skill in investigating and resolving data quality issues, such as duplicates, invalid formats, and orphaned references, while 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, including producing DDDs, ERDs, source-to-target mappings, and process documentation.
• Ability to obtain and maintain a suitability/Public Trust.

Nice To Haves

• Experience with large-scale healthcare relational databases (4,000+ objects).
• Knowledge of VA healthcare data security and cybersecurity architecture.
• Experience contributing to tool enhancements that improve team workflows.

Responsibilities

• Analyze source systems (VistA, Millennium, ADR, MVI, Geospatial, PIT, and Exam Management) to define data structures, relationships, business rules, and PHI/PII classification.
• Design and maintain database objects, including tables, views, and stored procedures, to support CDW data ingestion.
• Build conceptual, logical, and physical data models for 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, and 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, including duplicates, invalid values or formats, orphaned references, and inconsistencies; respond to Helpdesk requests through root-cause analysis with technical and business teams.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior