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

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