Business Analyst

Excelsior Orthopaedics•Eggertsville, NY

24d•$70,000 - $90,000•Onsite

About The Position

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.

Requirements

Bachelor's degree in a related field or Associates degree plus 5 years
Proven experience (3+ years) in a reporting, analytics, or business analyst role, preferably in a healthcare environment.
Advanced proficiency in Microsoft Excel, including pivot tables, complex formulas, lookups, data validation, and report automation.
Experience extracting and running reports from EMR systems and/or healthcare data warehouses.
Strong attention to detail with a demonstrated commitment to data accuracy and quality.
Ability to manage multiple reporting deadlines and prioritize tasks in a fast-paced environment.
Strong communication skills with the ability to present and explain data to both technical and non-technical audiences.

Responsibilities

Demonstrate our core values of being patient centered, team focused, service driven, accountable, and innovative every day.
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.
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.
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.
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