Oracle Health Architect

Overview

We are seeking an experienced Oracle Health Architect with deep expertise in Athena data structures and a strong background in mapping healthcare data to the OMOP Common Data Model (CDM).

Key Responsibilities

• Architecture & Data Strategy

  • Design and implement scalable data architecture leveraging Oracle Health (Cerner) data platforms, including Athena.
  • Define best practices for healthcare data modeling, integration, and governance.

• OMOP Data Model Mapping

  • Lead the end-to-end mapping of Oracle Health data to the OMOP CDM.
  • Develop and maintain ETL pipelines to transform source data into OMOP-compliant structures.
  • Ensure adherence to OHDSI standards and data quality frameworks.

• Athena Data Expertise

  • Utilize deep knowledge of Athena vocabulary and standardized terminologies (e.g., SNOMED, LOINC, RxNorm).
  • Align source system concepts with OMOP standard vocabularies.

• Clinical & Revenue Cycle Data Integration

  • Work with clinical data (EHR, encounters, diagnoses, procedures, labs, medications).
  • Integrate revenue cycle data (billing, claims, charges, payments) into unified reporting models.
  • Ensure consistency and traceability across domains.

• Data Quality & Validation

  • Implement data validation, reconciliation, and quality checks.
  • Collaborate with stakeholders to resolve data discrepancies and improve data integrity.

• Stakeholder Collaboration

  • Partner with clinical, operational, and analytics teams to define reporting requirements.
  • Translate business needs into technical data solutions.

• Documentation & Governance

  • Maintain detailed documentation of mappings, transformations, and data lineage.
  • Support data governance and compliance initiatives (HIPAA, etc.).

Pay

Hourly range: $55-$60 per hour.