Supervisor Treasury Database - St. Marys Hospital Troy NY - FT Days

Trinity Health • Troy, NY

389d • $65,520 - $95,056 • Onsite

About The Position

The Treasury Database Supervisor at St. Mary's Hospital is responsible for overseeing the operations and management of the Quick Base Database that tracks cash collections related to the Epic platform. This role involves leadership, data analysis, and collaboration with various finance teams to ensure accurate financial reporting and compliance with internal controls. The supervisor will also manage a team, develop efficient finance processes, and act as a liaison between different departments to support financial operations.

Requirements

• Bachelor's degree in Finance, Accounting, Business Administration or Healthcare Administration
• Prior supervisory or managerial experience preferred
• Generally requires 5 years of finance experience
• Knowledge of database management and data analysis tools and applications
• Experience working with large data sets and analysis
• Experience and knowledge of generally accepted accounting principles
• Critical financial thinking
• Financial Systems: PeopleSoft, Hyperion, Microsoft Office Suite - expertise in Excel, Access
• Analysis and presentation of data
• Effective communication skills
• Financial Stewardship
• Extended hours of computer use.

Responsibilities

• Responsible for the daily reconciliation of cash collections recorded in QuickBase to the cash received in the banking institutions for multiple SPHP affiliates
• Oversees the validation of bank deposits to Epic and PeopleSoft assuring timely resolution of any discrepancies
• Prepares monthly reports, analyses and cash flows of various corporate bank accounts
• Oversees and ensures sound internal controls and segregation of duties for recording daily cash
• Acts as liaison with divisions, PBS-K and system office treasury to assure accuracy, consistency and completeness of financial data
• Research and respond to inquiries from the SPHP financial divisions for transactional data within Quickbase and PeopleSoft general ledger
• Takes the lead on developing efficient finance processes that will benefit all SPHP
• Coordinates and oversees the work papers and schedules required for external audit
• Coordinates and oversees the timely and accurate completion of bank reconciliations of cash accounts for specific affiliates
• Coordinates the timely and accurate reconciliations of unapplied legacy cash accounts for the Hospitals and Rehab Hospital accounts
• Oversees the patient refund processes for the SPHP and RSD systems, including the timely issuing of checks, maintaining of check registers, and monthly related journal entries
• Ensures the timely response to all check related inquiries from the patient refund shareholders across the SPHP and RSD system
• Oversees the yearly submission of Abandon Property to New York State, related to the patient refund processes
• Supervises finance staff and performs all supervisory tasks associated with effective day to day operations of a team of individuals
• Leads responses to various audits
• Coordinates with other members of the SPHP and local Finance Teams to ensure consistency in the delivery of finance functions throughout the system
• Works with other leaders in the organization to support their understanding of finance and fiscal accountability.

Benefits

• Competitive pay range based on experience, skills, and education
• Diversity and inclusion initiatives
• Opportunities for professional development and training

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Hospitals
• Education Level: Bachelor's degree
• Number of Employees: 10,001+ employees