Athena Architect

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

Job summary

Chartis is seeking an experienced Athena Data Architect to lead end-to-end data architecture for Athena data and to map data into the OMOP CDM for advanced analytics. You will collaborate with clinical, revenue cycle, and analytics teams to define requirements and reporting needs.

The role involves designing ETL/ELT pipelines, ensuring data quality, and translating complex healthcare workflows into scalable data models using standard vocabularies such as SNOMED, ICD, CPT, and LOINC, enabling

Qualifications

• 5+ years in healthcare data architecture or data engineering.
• Hands-on experience with Athena (athenahealth) data models and extracts.
• Proven experience implementing or supporting the OMOP Common Data Model (CDM).
• Strong data mapping, transformation, and normalization.
• Proficiency in SQL and experience with ETL/ELT tools (Informatica, dbt, Talend, Azure Data Factory).
• Solid understanding of clinical data (EHR) and/or revenue cycle data (RCM).
• Experience with healthcare data standards and vocabularies.
• Strong analytical and problem-solving skills.

Responsibilities

• Lead end-to-end data architecture and modeling for Athena (athenahealth) data.
• Drive the mapping and transformation of Athena data into the OMOP CDM to support analytics and reporting.
• Collaborate with clinical, revenue cycle, and analytics stakeholders to define data requirements and reporting needs.
• Design and implement ETL/ELT pipelines to standardize and load data into OMOP-compliant structures.
• Ensure data quality, integrity, and consistency across clinical and financial datasets.
• Translate complex healthcare workflows into scalable data models.
• Provide expertise in healthcare data standards, vocabularies, and terminologies (SNOMED, ICD, CPT, LOINC).
• Partner with data engineers, analysts, and BI teams to enable downstream reporting and analytics.
• Document data mappings, lineage, and architecture for governance and compliance.
• Support performance tuning and optimization of large healthcare datasets.

Skills

Healthcare data architecture

Data modeling

Data mapping

SQL

Tools

Informatica

dbt

Talend

Azure Data Factory

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.

Athena Data Architect (OMOP Mapping Focus)

We are seeking an experienced Athena Data Architect with deep expertise in Athena data structures and strong experience mapping healthcare data to the OMOP Common Data Model (CDM). This role will drive the design, transformation, and alignment of Athena data for advanced analytics and reporting, with a focus on clinical and revenue cycle domains.

Key Responsibilities

• Lead the end-to-end data architecture and modeling for Athena (athenahealth) data.

• Drive the mapping and transformation of Athena data into the OMOP Common Data Model (CDM) to support analytics and reporting use cases.

• Collaborate with clinical, revenue cycle, and analytics stakeholders to define data requirements and reporting needs.

• Design and implement ETL/ELT pipelines to standardize and load data into OMOP-compliant structures.

• Ensure data quality, integrity, and consistency across clinical and financial datasets.

• Translate complex healthcare workflows (clinical + revenue cycle) into scalable data models.

• Provide expertise in healthcare data standards, vocabularies, and terminologies (e.g., SNOMED, ICD, CPT, LOINC).

• Partner with data engineers, analysts, and BI teams to enable downstream reporting and analytics.

• Document data mappings, lineage, and architecture for governance and compliance.

• Support performance tuning and optimization of large healthcare datasets.

Required Qualifications

• 5+ years of experience in healthcare data architecture or data engineering.

• Deep hands-on experience with Athena (athenahealth) data models and extracts.

• Proven experience implementing or supporting the OMOP Common Data Model (CDM).

• Strong experience with data mapping, transformation, and normalization.

• Proficiency in SQL and experience with ETL/ELT tools (e.g., Informatica, dbt, Talend, Azure Data Factory, etc.).

• Solid understanding of clinical data (EHR) and/or revenue cycle data (RCM).

• Experience working with healthcare data standards and vocabularies.

• Strong analytical and problem-solving skills.

Preferred Qualifications

• Experience with OHDSI tools and ecosystem.

• Familiarity with FHIR, HL7, or other interoperability standards.

• Experience with cloud platforms (AWS, Azure, GCP).

• Background in healthcare analytics or reporting environments.

• Exposure to value-based care or population health analytics.

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.