Sr. Data Architect (Remote)

Location: Fully remote in the United States

Salary: $165,000–$185,000 annually

Company

hirify.global delivers IT services and solutions that transform government operations and support government agencies.

What you will do

• Analyze VistA, Oracle Health Millennium, ADR, MVI, Geospatial, PIT, and Exam Management source systems to define structures, relationships, business rules, and PHI/PII classifications.
• Design and maintain tables, views, stored procedures, data models, metadata, and other database objects supporting Corporate Data Warehouse ingestion.
• Perform source-to-target analysis and mapping, document transformations, and maintain Data Domain Design Documents with ERDs, source inventories, data lineage, and business rules.
• Collaborate with data stewards, SMEs, DBAs, ETL developers, and source extraction teams on data lifecycle activities, outages, query optimization, and issue resolution.
• Investigate data quality problems and perform root-cause analysis for duplicates, invalid values or formats, orphaned references, and inconsistencies.
• Ensure compliance with CDW standards, data governance policies, security requirements, and enterprise architecture guidelines; contribute to Metadata Repository Editor enhancements.

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; or equivalent professional experience.
• Intermediate to advanced healthcare data knowledge, including 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 T-SQL proficiency, including queries, stored procedures, functions, indexing, partitioning, query optimization, and performance tuning.
• Experience with SSIS, SSAS, and Power BI for data integration and visualization.
• Strong database design skills covering ERDs, data lineage flows, and conceptual, logical, and physical data modeling.
• Expertise in scalable data architecture methodologies including Kimball, Inmon, and Data Vault.
• Familiarity with Embarcadero or TOAD, data catalogs, CDW standards, data security compliance, and large-scale data quality investigations.
• Strong collaboration and documentation skills, including DDDs, ERDs, source-to-target mappings, and process documentation; ability to obtain and maintain suitability/Public Trust.

Nice to have

• Experience with large-scale healthcare relational databases containing 4,000+ objects.
• Knowledge of VA healthcare data security and cybersecurity architecture.
• Experience contributing to workflow-improving tool enhancements.

Culture & Benefits

• Fully remote work environment and a collaborative team focused on meaningful government IT work.
• Employee Assistance Program, corporate discounts, pet insurance, and other health and well-being benefits.
• Learning and development platform, certification preparation, and training, education, and certification assistance for full-time employees.
• Referral Bonus Program and Internal Mobility Program.
• Full-time employment with benefits; position is at will.

Hiring process

• Virtual video interview with the hiring manager and/or team; camera must be on and a valid photo ID must be presented during each interview.
• Selected candidates complete enhanced biometric ID verification and a background check covering criminal history, education, and employment history.