Oracle Health Architect

Chartis; United States; Remote; USD 76,000 - 83,000; Full time

Job summary

Chartis seeks an experienced Oracle Health Architect with deep Athena data expertise to lead the mapping of Oracle Health data to the OMOP CDM and design scalable data transformations for advanced analytics across clinical and revenue cycle domains.

The ideal candidate will own data architecture, governance, and ETL pipelines, ensure OHDSI standards, and collaborate with clinical, operational, and analytics teams to deliver reliable, auditable data solutions.

Qualifications

• Experience designing scalable data architectures in healthcare
• Expertise mapping Oracle Health data to OMOP CDM
• Proficient ETL development for OMOP-compliant structures
• Strong knowledge of OHDSI standards and data quality
• Experience with Athena vocabulary and terminologies (SNOMED, LOINC, RxNorm)
• Ability to integrate clinical and revenue cycle data
• Ability to document data lineage and governance

Responsibilities

• Design scalable data architecture using Oracle Health (Cerner) with Athena
• Lead end-to-end mapping of Oracle Health data to OMOP CDM
• Develop ETL pipelines transforming source data into OMOP structures
• Ensure OHDSI standards and data quality across datasets
• Leverage Athena vocabularies (SNOMED, LOINC, RxNorm) for mapping
• Integrate clinical data and revenue cycle data into unified models
• Collaborate with stakeholders to define reporting requirements and governance
• Document mappings, transformations, and data lineage

Skills

Architecture design

Data modeling

Data governance

ETL development

Stakeholder collaboration

Healthcare analytics

Documentation

Tools

Oracle Health

Athena

OHDSI standards

SNOMED

LOINC

RxNorm

EHR data

Revenue cycle data

Job description

About Chartis

Chartis comprises 1,250 professionals who value working for a purpose-driven organization, people who have committed their careers to helping providers, payers, technology innovators, retail companies, and investors create and embrace solutions that reshape healthcare for the better. We work with over 900 clients annually to help make US healthcare more affordable, accessible, safe, and human.

Through our family of brands—Chartis, Jarrard, Greeley, and HealthScape Advisors—we have created a culture that prioritizes respect for our clients, commitment to each other, and unwavering integrity. From physicians, nurses, healthcare executives, and community health leaders to strategists, digital advisors, transactions experts, and healthcare futurists, we bring a diverse set of perspectives to assess healthcare challenges from every angle.

Believing in what we do helps us attract and retain the best and brightest because the work we do every day makes a meaningful impact. This theme of believing in a better way forward is woven into our brand, Believe in better.

Chartis has offices in Boston, Chicago, New York, San Francisco, Washington D.C., and Nashville. Remote work is allowed.

Oracle Health Architect (OMOP / Athena Data Specialist)

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). This role will lead the design and implementation of data transformations to support advanced analytics, reporting, and interoperability across clinical and revenue cycle domains.

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.).

Hourly range: $55-$60 per hour. The hourly range for this role takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, skills, experience, training, licensure and certifications, practice area, and other business and organizational needs.

At Chartis, we pride ourselves on having a diverse workforce. We value and celebrate the uniqueness of individuals and the different perspectives they provide. We offer equal opportunity employment regardless of race, color, religion, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, marital status, or protected veteran status.