Senior Cloud Data Architect - Healthcare Data Warehouse

General Dynamics IT; United States; On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

401K with company match

Paid time off

Full-flex work week

Military-friendly workplace

Job summary

General Dynamics IT is seeking a Data Architect Principal to turn data into measurable outcomes for CMS. You will design and lead program-wide data warehouse architecture, integrate healthcare data domains, and ensure HIPAA governance across PHI/PII while collaborating across teams to deliver robust data solutions.

The role emphasizes cloud data engineering with Snowflake, data governance, and agile collaboration in a mission-driven environment.

Qualifications

• Bachelor's degree required; 8+ years of related experience.
• Experience designing scalable Data Warehouse environments.
• Strong understanding of data structures and data modeling.
• Knowledge of Kimball and Inmon data-warehousing methodologies.
• Proficiency with Snowflake healthcare data warehouse architecture.
• Cloud data engineering experience with Snowflake.
• Experience with HIPAA governance for PHI/PII, including RBAC/ABAC and auditing.
• Experience with Agile/Scrum environments using Jira and Confluence.

Responsibilities

• Design and support the architecture of a program-wide data warehouse.
• Lead data warehouse project work to ensure requirements, timelines, and deliverables are met.
• Perform testing (unit, validation, regression) and ensure code meets user specs.
• Provide technical architecture expertise for planning, estimation, and solution design.
• Work across teams to define requirements and validate testing processes.
• Design scalable, multi-layer warehouse patterns (landing, transformed, standardized, curated, analytics).
• Model and integrate healthcare data domains using industry standards (X12, ICD-10, CPT/HCPCS, NDC, DRG, HL7, FHIR).
• Implement HIPAA governance for PHI/PII, including RBAC/ABAC, masking, row-level security, tagging, auditing, and lineage tracking.
• Contribute to SDDs, data dictionaries, and source-to-target mappings.
• Architect normalized and denormalized data solutions using best practices.
• Design scheduling workflows and automation processes.
• Support continuous improvement of processes, tools, and engineering approaches.

Skills

Cloud Data Architecture

Database Design

Data Model Design

Data Warehouse Architecture

Snowflake

Hadoop

Databricks

Git

Education

Bachelor's degree

Tools

Snowflake

Hadoop

Databricks

Git repositories

Job description

General Dynamics IT is seeking a Data Architect Principal to turn data into measurable outcomes for CMS. You will design and lead program-wide data warehouse architecture, integrate healthcare data domains, and ensure HIPAA governance across PHI/PII while collaborating across teams to deliver robust data solutions.

The role emphasizes cloud data engineering with Snowflake, data governance, and agile collaboration in a mission-driven environment.