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. The role bridges EHR, ERP and the 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.

• 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, Slicer Dicer) 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.

• The individual must 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 utilizing principles to support and improve departmental goals.
• Demonstrate knowledge of unit goals and is active in committees and projects to achieve these goals.
• Keep current with literature regarding changing practices, interventions and best practices.
• Assume responsibility for seeking out educational and professional opportunities for personal learning needs and growth as well as meeting mandatory education requirements.
• Act as a preceptor as requested.
• Demonstrate excellent work attendance and actively participate in a variety of meetings and training sessions as required.
• Adhere to the Avem Health Partners Code of Conduct and Standards of Behavior. Comply with established policies and procedures and all health and safety requirements.

• Bachelor's degree in data analytics, statistics, computer science, health informatics, finance or a 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/or 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.
• Excellent communication, documentation and presentation skills.
• Self-starter, passionate about making a difference.

• Epic certification or proficiency:
  Clarity Data Model,…