Accounting, Accounting Close, Accrual-Basis Accounting, Analysis Skills, Billing, Communication Skills, Cost Reporting, Cross-Functional, Data Processing, Database Analysis, Detail Oriented, Dialysis, Epic Reporting, Finance, Financial Audit, Financial Compliance, Financial Operations, Financial Reporting, Financial Statements, Financial Systems, Flash Reporting, General Ledger Accounting, Healthcare, Hospice Care, IP (Internet Protocol), Journal Entries, Leadership, Maintain Compliance, Medicaid, Medical Billing, Medicare, Nursing Home, Operations, Organizational Skills, PCI, Payment Processing, Peoplesoft, Pharmacy, Problem Solving Skills, Process Improvement, Reconciliation, Regulatory Reports, Reimbursement, Reporting Dashboards, Revenue Recognition, Team Player, Time Management
Employment Type:
Full time
Shift:
Day Shift
Description:
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) o EPIC dashboard reporting and utility reports
- Finance Flash Report (eClaims, ER, OBS, IP activity)
- 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
- 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
- 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.
T
Trinity Health
Trinity Health is one of the largest not-for-profit, faith-based health care systems in the nation. It is a family of 121,000 colleagues and nearly 36,500 physicians and clinicians caring for diverse communities across 27 states. Nationally recognized for care and experience, the Trinity Health system includes 101 hospitals, 126 continuing care locations, the second largest PACE program in the country, 136 urgent care locations and many other health and well-being services. In fiscal year 2023, the Livonia, Michigan-based health system invested $1.5 billion in its communities in the form of charity care and other community benefit programs.
10,000 employees or more
https://jobs.trinity-health.org/search-results