GovCIO
GovCIO

Sr. Data Architect

• Posted 2 hours ago • Updated 2 hours ago
Full Time
USD $165,000.00 - 185,000.00 per year
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Recruiting
  • Data Warehouse
  • SQL
  • Oracle
  • Data Structure
  • Database
  • Mapping
  • Meta-data Management
  • Data Dictionary
  • Data Domain
  • Business Rules
  • Enterprise Architecture
  • Help Desk
  • Root Cause Analysis
  • Computer Science
  • Business Operations
  • Microsoft Windows Vista
  • Geospatial Analysis
  • Management
  • Transact-SQL
  • Stored Procedures
  • Performance Tuning
  • Microsoft SSIS
  • Microsoft SQL Server
  • Microsoft SSAS
  • Microsoft Power BI
  • Data Integration
  • Visualization
  • Database Design
  • Physical Data Model
  • Data Architecture
  • Database Administration
  • Toad
  • Data Quality
  • Data Governance
  • Collaboration
  • Extract
  • Transform
  • Load
  • Extraction
  • Query Optimization
  • Regulatory Compliance
  • Documentation
  • Relational Databases
  • Health Care
  • Data Security
  • Cyber Security
  • Workflow
  • Security Clearance

Summary

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

Responsibilities

  • 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.

Qualifications

Required Skills and Experience
  • 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.



Preferred Skills and Experience
  • 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.

Clearance required

  • Ability to obtain and maintain a suitability/Public Trust

Posted Salary Range

USD $165,000.00 - USD $185,000.00 /Yr.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10443217
  • Position Id: 10291
  • Posted 2 hours ago

Company Info

About GovCIO

GovCIO is a rapidly growing provider of advanced technology solutions and digital services for the federal government. Combining our extensive federal experience with the latest innovations in IT and disruptive approaches, our experts develop comprehensive solutions to meet the most pressing demands of today’s government agencies. From the U.S. military to Health and Human Services, we have an impressive track record of helping our customers optimize how they operate.

We’re transforming government IT, empowering our federal customers to meet the challenges of today while building the government of tomorrow.

About_Company_One
Go to company profile
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.