Database Specialist- Eddy Senior Care

Key Responsibilities

• Prepare and distribute daily financial reports, including: Main Flash Report (Morning Minutes), EPIC dashboard reporting, and utility reports.
• Maintain and update Nursing Home (NH) tracking files, including: Patient eligibility, LTC status, and spenddown tracking, PDPM (rehab days) calculations and reconciliation.
• Accrual tracking and general ledger coding.
• Process and reconcile payments: Upload Medicare (MCR) and Medicaid (MCD) payment files, convert and process payment data from PDFs to Excel.
• Monitor and reconcile daily bank activity and cash logs.
• Execute month-end close activities, including: Accrual entries and reversals, Revenue reclassifications based on financial statements, Claims accrual tracking across multiple service lines.
• Prepare and post journal entries related to: Nursing Home (NH) accruals and reversals, Pharmacy (Pharmastar) fees and rebates, Hospice, dialysis, and agency-related accruals.
• Maintain regulatory and internal reporting requirements (EDS, RAPS).
• Utilize Waystar for payer registration and payment verification.
• Review billing system exceptions (PCC fails) and unresolved claims.
• Process spenddown billing through PeopleSoft.
• Prepare and distribute Day 1 reporting and accrual summaries to internal stakeholders.

Qualifications

• Bachelor’s degree in Finance, Accounting, or related field.
• 2+ years of experience in healthcare finance, billing, or revenue cycle operations.
• Advanced Excel skills (data manipulation, reconciliation, analysis).
• Strong attention to detail and ability to manage multiple deadlines.

Preferred Qualifications

• Experience with PDPM, LTC billing, or nursing home reimbursement.
• Familiarity with healthcare regulatory reporting (EDS/RAPS).
• Experience supporting audits or financial compliance processes.
• Experience with financial systems and reporting tools (e.g., EPIC, PeopleSoft, Waystar).
• Strong understanding of Medicare and Medicaid billing processes.