Database Specialist- Eddy Senior Care

Database Specialist- Eddy Senior Care - FT Days

Location: 433 River Street Troy NY

Position Summary

We are seeking a detail-oriented and highly organized Database Analyst to support daily financial reporting billing operations and month-end close processes. This role is critical in ensuring accurate revenue recognition claim tracking accruals and reconciliation across multiple healthcare revenue streams including Medicaid (MCD) Medicare (MCR) and other payer sources. The ideal candidate will have strong analytical skills experience working with billing systems and the ability to manage recurring deadlines in a fast-paced healthcare finance environment.

Key Responsibilities Daily Operations

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

Manage recurring accrual accounts and ensure proper GL coding

Support preparation of cost reporting data (e.g. PDPM claim days)

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

Manage ePace billing for non-standard claims

Prepare and distribute Day 1 reporting and accrual summaries to internal stakeholders

Additional Responsibilities

Track and process disenrollment activity (LHCSA)

Support audit-related activities and recurring accruals (e.g. UHY audit fees)

Maintain PCI compliance for payment processing devices

Collaborate cross-functionally with finance billing and operational teams

Identify discrepancies and drive process improvements

Qualifications

Bachelors 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

Knowledge of accrual accounting and month-end close processes

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

Key Competencies

Analytical thinking and problem-solving

Strong organizational skills and attention to detail

Ability to work independently and meet deadlines

Effective communication and collaboration

Process improvement mindset

Why Join Us

Opportunity to play a key role in financial operations and reporting

Collaborative mission-driven healthcare environment

Exposure to complex reimbursement and billing systems

Career growth within finance and revenue cycle leadership

Apply today for more information!

Pay range: $22.40-$35.84

Pay is based on experience skills and education. Exempt positions under the Fair Labor Standards Act (FLSA) will be paid within the base salary equivalent of the stated hourly rates. The pay range may also vary within the stated range based on location

Our Commitment

Rooted in our Mission and Core Values we honor the dignity of every person and recognize the unique perspectives experiences and talents each colleague brings. By finding common ground and embracing our differences we grow stronger together and deliver more compassionate person-centered care. We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin disability veteran status or any other status protected by federal state or local law.