Data Warehouse Architect

SMX Services and Consulting, Inc.

$100K — $130K *
Healthcare
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years of experience in Data Architecture
  • 5+ years of experience in Data Processing
  • 3+ years of experience with Oracle Health (formerly Cerner)
  • Experience with Google BigQuery is preferred
  • Familiarity with Python and Google Cloud Platform (GCP) is advantageous

Responsibilities

  • Design the conceptual and logical data architecture for a clinical data domain.
  • Identify and map common data elements across multiple disparate healthcare source systems.
  • Develop and implement a strategy to consolidate data into a cohesive, longitudinal data model.
  • Coordinate data extraction and export activities with source system owners and stakeholders.
  • Design and implement data cleansing and processing routines to ensure high-quality data.
  • Support the development of scalable data integration and warehouse solutions for analytics.
  • Collaborate with teams to establish best practices for data governance and architecture.

Benefits

  • Opportunity to work onsite in Richmond, VA
  • Engagement in a critical healthcare data project
  • Collaboration with cross-functional teams
  • Potential for professional growth in cloud technologies
  • Development of skills in data governance and quality practices
Full Job Description
Role: Data Warehouse Architect
Location: Richmond, VA (Onsite)
Start Date: August 3, 2026
End Date: January 22, 2027
Interview Type: Webcam Interview Only

Position Overview

We are seeking an experienced Data Warehouse Architect to design and implement a scalable clinical data architecture that integrates data from multiple healthcare source systems into a unified, longitudinal data platform.

Note: Only candidates located in or near the Richmond, VA area will be considered, as this role requires an onsite presence.

Required Skills
  • Data Architecture - 5+ years
  • Data Processing - 5+ years
  • Oracle Health (formerly Cerner) - 3+ years

Preferred Skills
  • Google BigQuery
  • Python
  • Google Cloud Platform (GCP) / Google Cloud Infrastructure

Key Responsibilities
  • Design the conceptual and logical data architecture for a clinical data domain.
  • Identify and map common data elements across multiple disparate healthcare source systems.
  • Develop and implement a strategy to consolidate data from various source systems into a cohesive, longitudinal data model.
  • Coordinate data extraction and export activities with source system owners and stakeholders.
  • Design and implement data cleansing, transformation, and processing routines to ensure high-quality, standardized data.
  • Support the development of scalable data integration and warehouse solutions that enable analytics and reporting.
  • Collaborate with cross-functional teams to establish data governance, quality, and architecture best practices.

Similar Jobs

More Jobs at SMX Services and Consulting, Inc.

More Healthcare Jobs

Find similar Data Warehouse Architect jobs: