Oracle Health Architect

Role overview

Design healthcare data architecture and lead the transformation of Oracle Health data, including Athena structures and vocabularies, into the OMOP Common Data Model. The work supports analytics, reporting, and interoperability across clinical and revenue cycle information, with close attention to data quality, traceability, and governance.

Responsibilities

- Develop scalable data architecture and practices for healthcare data modeling, integration, and governance. - Lead end-to-end mapping from Oracle Health sources to OMOP structures, and build and maintain the ETL pipelines that perform the transformations. - Align source concepts with OMOP vocabularies, using Athena terminology expertise and standards such as SNOMED, LOINC, and RxNorm. - Integrate clinical records—including encounters, diagnoses, procedures, labs, and medications—with billing, claims, charges, and payment data. - Create validation, reconciliation, and data quality checks; work with stakeholders to resolve discrepancies. - Document mappings, transformations, and lineage, and collaborate with clinical, operational, and analytics partners to turn reporting needs into technical solutions.

Requirements

- Deep experience with Oracle Health data structures and Athena. - Strong background mapping healthcare data to the OMOP Common Data Model. - Ability to design and maintain ETL processes and apply OHDSI standards and data quality frameworks. - Knowledge of clinical and revenue cycle data and how to integrate them into consistent reporting models. - Familiarity with standardized healthcare vocabularies such as SNOMED, LOINC, and RxNorm. - Ability to collaborate across business and technical teams and support data governance and compliance, including HIPAA.

Benefits and work setup

- Remote work is allowed. - The listed hourly pay range is $55–$60.