RESPONSIBILITIES:

Reporting to the Manager, this position will be responsible for:

• Leading support for the HRCM billing database:

• Updating and maintaining tables (pricing, insurance etc.)

• Updating and maintaining access logins and permissions

• Assigning deficiency codes and troubleshooting issues

• Updating bill forms/reports in Crystal Reports

• Testing and documenting all production changes

• Reviewing day end reports to identify issues and taking necessary corrective actions

• Monitoring HL7 interface messages from the Hospital’s Patient Care System (Quadramed) to HRCM and coordinating resolution of any identified issues

• Troubleshooting application issues for end users and liaising with Infor as needed for solutions

• Creating ad hoc reports to support Management decision making using Crystal/ SQLPlus

• Generating, loading and submitting billing files to external payers (WSIB, OHIP etc.)

• Generating and transferring files to the Hospital’s external collection agency

• Executing monthly post to the general ledger (SAP) and ensuring accounts receivable control accounts are reconciled

• Generating accounts receivable aging reports

• Maintaining the department’s intranet website

• Monitoring system/user performance and identifying technical opportunities to improve efficiencies

• Leading activities relating to the installation and testing of new software releases

• Coordinate resolution of issues related to the online payments application

• Performing other special adhoc requests, assignments and analysis as needed

• Provide support and backup on other Finance applications as required

QUALIFICATIONS:

Mandatory:

• Successful completion of post-secondary education with specialization in computer systems and applications

• Minimum 3 years work experience in a role supporting both an Oracle database and HL7 interface

• Demonstrated experience with data extraction and report writing

• Proven project management skills

• Strong Crystal/SQLPlus skills

• Superior knowledge of Microsoft Office products (Word, Excel)

• Knowledge of SAP or other large ERP software

• Knowledge of TM1 or other data analytics tools

• Excellent written and oral communication skills with a strong customer centric approach

Preferred:

• Healthcare Revenue Management (HCRM) software experience

• SAP software experience