Senior Healthcare Data Analyst: Epic, Oracle & Power BI

Avem Health Partners; Oklahoma City (OK); On-site; USD 90,000 - 140,000; Full time

Job summary

Avem Health Partners seeks a Senior Data Analyst to turn clinical, financial and operational data into actionable insight for leaders. You will own complex analyses across care, revenue cycle and supply chain, partner with Epic analysts, build KPI dashboards, and ensure data quality and governance.

You will design reports using Oracle and Power BI, mentor junior analysts, and help advance data platforms while safeguarding PHI and supporting value-based care initiatives.

Qualifications

• Bachelor’s degree in data analytics, statistics, computer science, health informatics, finance, or related field.
• 5+ years of data analysis experience, including 3+ years in a healthcare provider, health system or payer setting.
• Advanced SQL (complex joins, CTEs, window functions, performance tuning).
• 3+ years building enterprise dashboards in Power BI, including DAX and data modeling.
• Hands-on experience reporting from Epic Clarity and Caboodle.
• Experience working with Oracle ERP financial, supply chain or HCM data.
• Working knowledge of healthcare data: ICD-10, CPT, DRG, revenue cycle and quality measures.
• Python or R for statistical analysis and automation.
• Demonstrated understanding of HIPAA and handling of PHI.
• Strong understanding of software development lifecycle and project management methodologies.

Responsibilities

• Lead complex analyses across clinical, revenue cycle, supply chain, workforce and finance domains, and present findings and recommendations to directors and executives.
• Build and maintain KPI frameworks for quality, length of stay, readmissions, throughput, labor productivity and cost per case.
• Support value-based care, population health and regulatory reporting (CMS, Joint Commission, state agencies).
• Write and optimize SQL against Epic Clarity and Caboodle to extract encounter, order, charge and outcome data.
• Build and validate Epic reporting content (Reporting Workbench, Radar dashboards, SlicerDicer) in partnership with Epic analysts.
• Translate Epic workflow and documentation changes into downstream reporting impacts.
• Integrate Oracle ERP data (General Ledger, Accounts Payable, Procurement, Supply Chain, HCM) with clinical data for cost, margin and spend analysis.
• Develop reports using Oracle BI Publisher, OTBI and Oracle Analytics, and reconcile results with Finance.
• Design, publish and govern Power BI datasets, semantic models and dashboards, including DAX measures, row-level security and refresh schedules.
• Develop data pipelines and models in SQL Server, Azure Data Factory, Azure Synapse or Microsoft Fabric.
• Automate recurring work with Power Query, Power Automate and advanced Excel.
• Define metric definitions and data dictionaries; monitor data quality and resolve discrepancies across source systems.
• Protect PHI by applying HIPAA, minimum-necessary and de-identification standards in all deliverables.
• Gather requirements from clinical and business stakeholders, scope requests and manage delivery timelines.
• Mentor junior analysts, review their code and reports, and promote analytics best practices.

Skills

Advanced SQL

Power BI

Python or R

HIPAA compliance

Education

Bachelor's degree in data analytics or related field

Tools

Epic Clarity

Caboodle

Oracle ERP

OTBI

Job description

Avem Health Partners seeks a Senior Data Analyst to turn clinical, financial and operational data into actionable insight for leaders. You will own complex analyses across care, revenue cycle and supply chain, partner with Epic analysts, build KPI dashboards, and ensure data quality and governance.

You will design reports using Oracle and Power BI, mentor junior analysts, and help advance data platforms while safeguarding PHI and supporting value-based care initiatives.