Excel Pivot Table Remote Jobs in Miami, FL (NOW HIRING)

Sunrise,FL - USA

Position Requirements

RESPONSIBILITIES
Data Management: Monitor daily, weekly, and monthly file transmissions to and from vendors (e.g., bad debt, skip tracing).
Performance: Monitor vendor performance metrics (KPIs/SLAs) and support regular reviews with internal stakeholders. Document operational processes and assist in the development of standard operating procedures (SOPs). Track and log patient-related vendor escalations (e.g., disputes, billing errors, patient complaints).
Process Improvement: Develop and implement strategies to streamline file transfer and file reconciliation for each vendor. Support the implementation of new vendors or transition processes. Provides insights to support leadership in decision-making.
Stakeholder Communication: Maintain a communication log to track vendor interactions, follow-ups, and issue resolution. Schedule and participate in regular check-ins or business reviews with key vendors and internal stakeholders.
Reporting and Analytics: Perform detailed reconciliation of vendor inventory files against AthenaIDX or other RCM systems to ensure accuracy and completeness. Investigates all discrepancies of placement (including payments and adjustments) and drive resolution in coordination with internal teams and vendors.
Problem Resolution: Address and resolve issues related to file and invoice reconciliation to/from vendors. Support change management initiatives by effectively communicating vendor-related changes (e.g., process updates, system changes, new requirements). Support audits, compliance reviews, and vendor performance evaluations as needed.
Vendor Relationship Management: Serve as the primary point of contact for assigned vendors, maintaining strong, collaborative working relationships.
REQUIRED QUALIFICATIONS
Minimum of 3 years of experience in healthcare operations, revenue cycle management, vendor management, or a similar administrative role.
Ability to research and resolve discrepancies or data mismatches with vendors or internal departments.
Detail-oriented with a strong ability to track issues, escalate appropriately, and follow through to resolution.
Strong verbal and written communication skills to liaise with vendors, internal teams, and patients as needed.
Professional demeanor and customer service orientation, especially when handling escalations or complaints.
Proficiency in Microsoft Office: Particularly Excel (with focus on Pivot Table and VLOOKUP functions)
Comfortable working with large data sets, file reconciliations, and understanding file formats (e.g., CSV, XLSX, flat files).
Ability to work independently and collaboratively in a fast-paced environment
Ability to prioritize and manage multiple ongoing requests, reconciliations, and projects with minimal supervision.
PREFERRED QUALIFICATIONS
Experience with third-party vendor coordination or address verification processes is highly desirable.
Experience in managing or supporting projects involving third-party vendors, including onboarding, contract adherence, and performance tracking.
Proactively identifies trends, data inconsistencies, or operational inefficiencies and recommends process improvements.
Works effectively across teams including Compliance, RCM, IT, Legal, and external vendors to resolve issues.
Maintains the highest standards of privacy and security when handling sensitive patient or vendor information.
Approaches vendor and patient concerns with professionalism, empathy, and a sense of urgency.

Total Rewards:
Generous benefits package, including:
Paid Time Off
Health, life, vision, dental, disability, and AD&D insurance
Flexible Spending Accounts/Health Savings Accounts
401(k)
Leadership and professional development opportunities

The Vendor Operations Analyst supports the strategic and operational oversight of our external third-party vendor relationships that contributes to early-out vendors, skip tracing, bad debt agencies, and statement processing partners. This role plays a critical function in ensuring data accuracy, performing weekly and monthly reconciliation of all data exchanges, optimizing vendor performance, and supporting compliance with internal policies and external regulations. The Analyst will also facilitate communication between vendors and internal stakeholders to ensure service-level agreements (SLAs) are met and performance benchmarks are achieved.
The ideal candidate is highly organized, detail-oriented, analytical, proficient with excel and adept at managing multiple priorities in a fast-paced environment, with a strong focus on data accuracy, cross-functional collaboration, and timely reporting of discrepancies.

EEO Statement

North American Partners in Anesthesia is an equal opportunity employer.