Reporting Analyst at The Orthopedic Institute of Pennsylvania

Enola, Pennsylvania, United States -

Full Time

Start Date

Immediate

Expiry Date

01 Jun, 26

Salary

0.0

Posted On

03 Mar, 26

Experience

0 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Extraction, Report Generation, Data Validation, Report Maintenance, Report Distribution, Microsoft Excel, VLOOKUP, XLOOKUP, Pivot Tables, Data Filtering, Conditional Formatting, IF Statements, Macros, VBA, Microsoft Outlook, SharePoint

Industry

Medical Practices

Description

Description 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 ESSENTIAL FUNCTIONS 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 Technical Skills 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 Power BI (Preferred): Basic ability to refresh data or view dashboards EDUCATION High School and GED required. Health care background preferred Experience running all reports EXPERIENCE Two years’ experience in medical accounts receivable (A/R) resolution required. Prior experience in a health care organization, orthopedic setting preferred. Benefits Include: Competitive Wages Medical, Dental, Vision, Disability, and Life Insurance within 30 days Company-Paid Group Life Insurance, Short-Term Disability & Long-Term Disability Paid Time Off (PTO) 401(k) plan and profit sharing Cell-Phone Discounts Casual Day on Fridays! Career Advancement Opportunities

Responsibilities

The Reporting Analyst is tasked with the timely extraction, formatting, and distribution of periodic business reports using Microsoft tools. This involves transforming data from various sources into organized spreadsheets and dashboards to aid management in performance tracking.