Business Systems Analyst - Toronto, Canada - Sunnybrook Health Sciences Centre

Sunnybrook Health Sciences Centre

Verified Company

Toronto, Canada

3 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

This position will work out of the Bayview and will report into Finance.

Patient Accounts is a high-volume, fast paced department of 25 staff responsible for all billing and collections at the Hospital.

This role will be responsible for supporting the department's INFOR HRCM billing database, HL7 interface and other technical needs

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
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
Performing other special adhoc requests, assignments and analysis as needed

Qualifications/Skills:

Mandatory:

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: