Define KPIs aligned with enterprise and clinical priorities
Design dashboard mockups and translate business needs into technical requirements
Prototype analytical logic using Excel or Power BI to guide IT development
Validate reporting accuracy through reconciliation and variance analysis
Ensure KPI consistency across departments
Develop complex Excel models using Power Query, pivot tables, and advanced formulas
Clean, validate, and reconcile large datasets from operational platforms
Identify trends in utilization, scheduling, and workflow performance
Translate raw data into actionable operational insights
Map current-state workflows and identify bottlenecks
Quantify operational and financial impact of constraints
Support development of scalable, future-state processes
Partner with operations, clinical leadership, and IT stakeholders
Present concise, executive-ready recommendations
Proactively surface risks, tradeoffs, and opportunities
Drive clarity in ambiguous or evolving business questions

2–5 years of experience in business analysis, operations analytics, or consulting
Advanced Excel proficiency (Power Query, complex formulas, pivot tables)
Experience building dashboards in Power BI
Strong data validation and reconciliation discipline
Ability to structure ambiguous problems into analytical frameworks
Clear, concise, executive-level communication skills.

Business Analyst

Key skills