Sr. Data Architect (Remote)

GovCIO; Montpelier (VT); À 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 recruiting a Data Engineer and Architect to support the VA’s Corporate Data Warehouse (CDW). The role analyzes source databases, builds database objects, and designs scalable data models for secure ingestion of healthcare data from systems like VistA and Millennium.

This position is fully remote in the United States. You will collaborate with data stewards, DBAs, ETL teams, and source extraction groups to ensure data quality, governance, and compliant architecture across the enterprise

Qualifications

• Experience with healthcare data and clinical business operations.
• Strong SQL skills and data integration experience in healthcare.
• Ability to handle PHI/PII across multiple source systems.

Responsabilités

• Analyze source systems to define data structures, business rules and PHI/PII classification.
• Design and maintain database objects supporting CDW data ingestion.
• Build data models enabling scalable enterprise data integration.
• Map source-to-target transformations and maintain data lineage.
• Collaborate with SMEs, DBAs, ETL developers and source teams throughout the lifecycle.
• Develop and maintain DDds, ERDs, and documentation for governance.
• Ensure CDW standards, governance policies, and security requirements.
• Investigate data quality issues and provide root-cause analysis with teams.

Connaissances

T-SQL

SSIS

SSAS

Power BI

Data modeling

Database design

Data governance

PHI/PII handling

Embarcadero

TOAD

Formation

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

Outils

Embarcadero

TOAD

Description du poste

United States

Suitability/Public Trust

Fully remote

Information Technology

Overview

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.

Company Overview

GovCIO is a team of transformers--people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens.

But we can't do it alone. We need great people to help us do great things - for our customers, our culture, and our ability to attract other great people. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer?

What You Can Expect

Interview & Hiring Process

If you are selected to move forward through the process, here’s what you can expect:

• During the Interview Process

• Virtual video interview conducted via video with the hiring manager and/or team

• Camera must be on

• A valid photo ID must be presented during each interview

• During the Hiring Process

• Enhanced Biometrics ID verification screening

• Background check, to include:

• Criminal history (past 7 years)

• Verification of your highest level of education

• Verification of your employment history (past 7 years), based on information provided in your application

Employee Perks

At GovCIO, we consistently hear that meaningful work and a collaborative team environment are two of the top reasons our employees enjoy working here. In addition, our employees have access to a range of perks and benefits to support their personal and professional well-being, beyond the standard company offered health benefits, including:

• Employee Assistance Program (EAP)

• Corporate Discounts

• Learning & Development platform, to include certification preparation content

• Training, Education and Certification Assistance*

• Referral Bonus Program

• Internal Mobility Program

• Pet Insurance

• Flexible Work Environment

*Available to full-time employees

Our employees’ unique talents and contributions are the driving force behind our success in supporting our customers, which ultimately fuels the success of our company. Join us and be a part of a culture that invests in its people and prioritizes continuous enhancement of the employee experience.

We are an Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or status as a protected veteran. EOE, including disability/vets.

Posted Pay Range

The posted pay range, if referenced, reflects the range expected for this position at the commencement of employment, however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, education, experience, and internal equity. The total compensation package for this position may also include other compensation elements, to be discussed during the hiring process. If hired, employee will be in an “at-will position” and the GovCIO reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, GovCIO or individual department/team performance, and market factors.