Reporting Analyst

The Orthopedic Institute of Pennsylvania•Enola, PA

16h

About The Position

The Reporting Analyst is responsible for the timely extraction, formatting, and distribution of periodic business reports. You will use Microsoft tools to transform data from various sources into organized, readable spreadsheets and dashboards that help management track performance.

Requirements

Microsoft Excel: VLOOKUP/XLOOKUP, Pivot Tables, and Data Filtering
Excel (Advanced): Conditional Formatting, IF statements, and basic Macros (VBA)
Microsoft Outlook: Managing distribution lists and scheduling automated report deliveries
SharePoint/Microsoft Teams: Organizing files in a central location for team access
High School and GED required.
Two years’ experience in medical accounts receivable (A/R) resolution required.
Experience running all reports

Nice To Haves

Power BI (Preferred): Basic ability to refresh data or view dashboards
Health care background preferred
Prior experience in a health care organization, orthopedic setting preferred.

Responsibilities

Data Extraction: Pulling raw data from internal databases, CMR systems or EHR software (Medent and Raintree)
Report Generation: Using Excel to compile daily, weekly, and monthly reports
Data Validation: Checking for errors, missing values, or "weird" numbers before the report goes out
Maintenance: Updating existing report templates and ensuring formulas remain functional
Distribution: Sharing reports via Outlook, SharePoint, or Microsoft Teams to relevant stakeholders
Systems: Running reports in Medent and Raintree and other software systems that the company may require