Business Analyst

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

Requirements and Qualifications

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

Physical Demands

• Manual and finger dexterity and eye-hand coordination to enter data and operate office equipment.
• Corrected vision and hearing within normal range to observe and communicate with patients, providers, and staff.
• Frequently remaining in a stationary position, often sitting for prolonged periods working on a computer, telephone, copy/fax machine, and other office equipment.
• Occasional standing and walking required.
• Occasional lifting and carrying items weighing up to 10 pounds.

The pay range for this position is determined based on several factors, including the candidate’s years of experience, qualifications, training, licenses, designations, and the overall market conditions.

This job description does not state or imply that the duties and responsibilities listed are the only ones required of this position.  Team members in this role will be required to perform other job-related duties at the discretion of the employer and may have additional duties assigned as necessary.  

Excelsior Orthopaedics and Buffalo Surgery Center are committed to the full inclusion of all applicants.  All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. 

Salary : $70,000 - $90,000