chartis - Athena Architect

Remote - United States$114k - $125k3mo ago

Remote Principal NA Cloud Computing Oil & Gas Solutions Architect SQL dbt Azure Reporting AWS

Requirements

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

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.