Oracle Health Architect
Remote architect role at healthcare consultancy Chartis: design data architecture on Oracle Health (Cerner)/Athena platforms and lead end-to-end mapping of clinical and revenue-cycle data to the OMOP Common Data Model. Day to day: building ETL pipelines, aligning vocabularies (SNOMED, LOINC, RxNorm), and ensuring data quality per OHDSI standards.
- Compensation
- $55–$60 / hr
- Location
- Remote
- Work setup
- Remote
- Seniority
- Not specified
- Employment
- Part time
- Experience
- Not specified
- Category
- Architecture
- Posted
Skills
Must have
- Deep expertise in Athena data structures
- Strong background mapping healthcare data to the OMOP Common Data Model (CDM)
- Experience with Oracle Health (Cerner) data platforms, including Athena
- Develop and maintain ETL pipelines to transform source data into OMOP-compliant structures
- Deep knowledge of Athena vocabulary and standardized terminologies (SNOMED, LOINC, RxNorm)
- Adherence to OHDSI standards and data quality frameworks
- Experience working with clinical data (EHR, encounters, diagnoses, procedures, labs, medications)
- Experience integrating revenue cycle data (billing, claims, charges, payments)
- Implement data validation, reconciliation, and quality checks
- Maintain documentation of mappings, transformations, and data lineage
- Support data governance and compliance initiatives (HIPAA)
Nice to have
- Partner with clinical, operational, and analytics teams to define reporting requirements
Full 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.