Job Summary

We are seeking a detail-oriented and highly analytical Business Analyst to support a physician-owned orthopaedic medical practice and ambulatory surgery center. This role is responsible for developing, maintaining, and delivering accurate, timely, and actionable reports across clinical, operational, and financial domains. The analyst will work extensively with the organization’s electronic medical record (EMR) systems, data warehouse, and other internal data sources to support performance monitoring, strategic decision-making, and operational improvement initiatives.

The ideal candidate has strong technical and analytical skills, advanced expertise in Excel, experience with reporting and visualization tools such as Tableau, and the ability to translate complex data into meaningful insights for physicians, providers, administrators, and leadership.

 

Duties and Responsibilities

Core Values

• Demonstrate our core values of being patient centered, team focused, service driven, accountable, and innovative every day.

Reporting & Data Management

• Generate and maintain recurring reports (daily, weekly, monthly, quarterly, and annual) from EMR systems, data warehouses, and other internal data sources.


• Develop, validate, and reconcile reports related to clinical productivity, surgical volume, financial performance, quality metrics, and operational efficiency.


• Ensure accuracy, consistency, and integrity across all reporting outputs and datasets.


• Maintain documentation of report logic, definitions, and data sources to support standardization and repeatability.

Analysis & Insights

• Analyze data to identify trends, variances, and opportunities for operational and financial improvement.


• Translate complex datasets into clear, actionable insights for clinical and administrative stakeholders.


• Assist leadership with data-driven decision-making through analysis and reporting.

Dashboard & Report Development

• Design and maintain Excel-based reports, dashboards, and analytical tools using advanced formulas, pivot tables, and data modeling techniques.


• Develop visualizations and dashboards using Tableau or other business intelligence tools.

Collaboration & Process Improvement

• Collaborate with physicians, practice leadership, and department managers to understand reporting needs and deliver meaningful analytics.


• Work with operational teams to understand workflows and identify key performance indicators (KPIs).


• Support ad hoc reporting requests, special analyses, and strategic initiatives.


• Assist with system upgrades, report optimization, and improvements to reporting processes and data workflows.


• Evolve in your role when performing supplemental responsibilities as assigned