Data Warehouse Architect

Role Overview

We are seeking a Data Architect/Data Engineer to support the design, integration, and management of enterprise clinical data. This role will focus on building a unified clinical data domain by designing data architectures, integrating data from multiple source systems, implementing data processing and cleansing routines, and supporting enterprise healthcare analytics initiatives.

This opportunity is based in Richmond, VA, and is open to candidates within a 100-mile radius of Richmond, VA. The client is only considering candidates who can work without requiring present or future employment sponsorship.

Key Responsibilities

• Design conceptual and logical data models for enterprise clinical data domains
• Develop data architecture to support integration of multiple clinical data sources
• Identify common data elements across disparate healthcare systems
• Design and implement longitudinal data models for unified clinical reporting
• Coordinate data extraction and ingestion from source systems
• Develop and maintain data cleansing, transformation, and processing routines
• Ensure data quality, integrity, and consistency across integrated datasets
• Collaborate with business, clinical, and technical teams to support data initiatives
• Document data models, workflows, and processing standards
• Support ongoing data management, reporting, and analytics initiatives

Required Skills (with Years)

• Data Architecture – 5+ years
• Data Processing, Transformation, and Integration – 5+ years
• Oracle Health (Cerner) – 3+ years
• Clinical Data Management and Data Modeling
• Data Cleansing and Data Quality Management
• ETL/Data Integration Processes
• Data Mapping and Data Governance

Preferred Skills

• Python – 5+ years
• Google BigQuery – 2+ years
• Google Cloud Platform (Google Cloud Platform) Infrastructure – 2+ years
• Healthcare Data Integration
• Enterprise Data Warehousing
• SQL and Database Management