Senior Data Analyst

JOB PURPOSE: 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.

ESSENTIAL FUNCTIONS INCLUDE BUT NOT LIMITED TO:

• 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

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

EDUCATION/QUALIFICATIONS:

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

CERTIFICATION/LICENSURE: (One or more of the following)

• Epic certification or proficiency: Clarity Data Model, Caboodle Data Model or Cogito.
• Microsoft certification: Power BI Data Analyst Associate or Fabric Analytics Engineer.
• Experience with Oracle Fusion Cloud ERP, OTBI, BI Publisher or Oracle Analytics Cloud.

PHYSICAL REQUIREMENTS:

• To perform this job successfully, an individual must be able to perform each essential job duties satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. Such accommodations must be requested by the employee/applicant to be considered.
• This job requires visual abilities, auditory abilities, must be intact to perform duties.