Senior Data Analyst

The Senior Data Analyst turns clinical, financial, and operational data into insight that leaders use to improve patient outcomes, cost, and efficiency. This role bridges EHR, ERP, and data platforms, owning complex analyses, enterprise reporting, and dashboard delivery from request to adoption. The analyst also mentors junior analysts and sets standards for data quality and governance.

Essential Functions

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

Behavioral Standards

• Support the mission, vision, and goals of Avem Health Partners and serve as a role model within the company.
• Exhibit positive customer service behavior in everyday work interactions.
• Demonstrate a courteous and respectful attitude to internal workforce and external customers.
• Communicate accurately and appropriately.
• Handle difficult situations in a discreet and professional manner.
• Hold self-accountability for professional practice.
• Participate in performance improvement activities to support and improve departmental goals.
• Demonstrate knowledge of unit goals and actively participate in committees and projects.
• Stay current with literature regarding changing practices, interventions, and best practices.
• Seek educational and professional opportunities for personal growth and meet mandatory education requirements.
• Act as a preceptor as requested.
• Demonstrate excellent attendance and actively participate in meetings and training sessions.
• Adhere to the Avem Health Partners Code of Conduct and Standards of Behavior.
• Comply with established policies, procedures, and all health and safety requirements.