[Hiring] Associate Data Architect @CAMC Health System

Role Description

This Associate Data Architect position is specifically focused on building enterprise Business Intelligence dashboards in Oracle Analytics Cloud (OAC) on the Oracle Health Data Intelligence (HDI) platform running on Oracle Cloud Infrastructure (OCI). This role will be directly involved in a major analytics platform transition as the organization moves away from legacy PIE reports and Tableau dashboards running on AWS/Vertica and standardizes enterprise analytics on HDI + OAC.

The person in this role will design, develop, and maintain dashboards primarily supporting Revenue Cycle, clinical, and operational analytics. In Revenue Cycle, this includes analytics for both Oracle Health Patient Accounting (OHPAC) and Cerner Patient Accounting (CPA) environments. In addition, the organization’s Oracle Health EHR data will be landing in HDI and will require new and enhanced dashboards to support executive, operational, and clinical decision-making.

This position will be on the front line of the HDI/OAC implementation and conversion, working closely with the Oracle Health team as data is transitioned, modeled, and validated, and as initial vendor-provided dashboards are stood up. Specific collaboration areas include OHPAC dashboards and Oracle Health Unified Analytics Reporting (UAR) dashboards. Once the core platform migration is complete, this role will continue to play a key part in expanding and enhancing analytics beyond what is delivered out-of-the-box, building custom dashboards to meet the organization’s unique business and operational needs.

On a day-to-day basis, the Associate Data Architect in this role will:

• Develop and maintain OAC dashboards and subject areas in HDI
• Write and optimize SQL (and PL/SQL where applicable) against Oracle databases
• Partner with business stakeholders to translate revenue cycle and operational questions into clear, reliable analytics solutions
• Ensure dashboards are performant, governed, and aligned with standardized enterprise definitions
• Collaborate with Oracle Health and internal IT teams during platform transition, validation, and ongoing enhancement

Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Healthcare Informatics, or related field required
• Master’s degree or advanced technical training in data, analytics, or cloud platforms preferred
• 5–7 years of experience in healthcare analytics, business intelligence, or data architecture
• Hands-on experience developing enterprise dashboards and reporting solutions in modern BI platforms
• Experience working with healthcare data domains such as revenue cycle, finance, clinical operations, or population health

Requirements

• Experience developing dashboards in Oracle Analytics Cloud (OAC) or similar enterprise BI tools (Tableau, Power BI)
• Experience working with Oracle databases, including strong SQL skills and familiarity with PL/SQL
• Experience supporting or analyzing data from Patient Accounting systems (Oracle Health Patient Accounting (OHPAC), Cerner Patient Accounting (CPA), or similar)
• Experience working in cloud-based analytics environments, preferably Oracle Cloud Infrastructure (OCI) or comparable platforms
• Experience with data warehouse or enterprise analytics platforms (e.g., HDI, EDW environments, or similar)
• Experience partnering with vendors and internal teams during system implementations, data migrations, or platform transitions
• Experience building governed, reusable analytics assets (standardized dashboards, curated datasets, semantic layers)

Benefits

• Full Time Regular 1.0

Company Description

Location: Northgate-400 Association Dr., US:WV:Charleston

Talent Acquisition Specialist: Guy S. Stewart ([email protected])