Specialist, Application Data Support

UHN is Canada’s #1 hospital and the world’s #1 publicly funded hospital. With 10 sites and more than 44,000 TeamUHN members, UHN consists of Toronto General Hospital, Toronto Western Hospital, Princess Margaret Cancer Centre, Toronto Rehabilitation Institute, The Michener Institute of Education and West Park Healthcare Centre. As Canada's top research hospital, the scope of biomedical research and complexity of cases at UHN have made it a national and international source for discovery, education and patient care. UHN has the largest hospital-based research program in Canada, with major research in neurosciences, cardiology, transplantation, oncology, surgical innovation, infectious diseases, genomic medicine and rehabilitation medicine. UHN is a research hospital affiliated with the University of Toronto. 

UHN’s vision is to build A Healthier World and it’s only because of the talented and dedicated people who work here that we are continually bringing that vision closer to reality. 

www.uhn.ca 

Union: Non-Union
Site: Toronto Western Hospital
Department: Bariatric Program (Medical and Surgical)
Reports to: Manager -  Bariatric Program
Work Model: Hybrid (On-Site/Remote)
Hours: 37.5 per week
Wage Range: $40.61 - $50.76 per hour
Shifts: Monday-Friday Day shift
Status: Permanent Full-Time
Closing Date: April 24th, 2025

Position Summary

As an integral member of the Bariatric Data Administration team, the responsibilities of the SPECIALIST, APPLICATION DATA  SUPPORT include: leading and/or participating in the development and implementation of a comprehensive information system that facilitates the capture and management of required data; performing database management responsibilities, while ensuring optimum data quality; developing and maintaining excellent knowledge of the Bariatric Information System to ensure timely maintenance/updating of the system and security files, while ensuring confidentiality of patient data; providing advice, guidance and training to surgical and data support staff in the operations of the SSIS; maintaining data filing and retrieval systems;  sending reports to MOH and OBN; maintaining  external relationships with University of  Toronto Bariatric Collaborative partner sites; performing cross-functional and other duties consistent with the job classification, as assigned and/or requested.

Duties

• Participates in the development and implementation of a comprehensive information system that facilitates the capture and management of required data using various internal and external systems e.g., MYSIS, ORSOS, EPR, EPIC, Central Registry, Ministry systems, etc.
   
• Responsible for developing, supporting and maintaining Access databases; creating tables, queries, forms and reports in a well-designed secure multi-user database using EPIC and Microsoft Access; writing complex Access database queries to extract bariatric information from the database
   
• Contributes to the designing, testing, debugging and configuring process
   
• Performs database management responsibilities including the provision of education and training, while ensuring optimum data quality
   
• Utilizes strong database management skills to ensure the effective capture of data, e.g., number of new referrals; number of assessment; frequency of visits; clinical outcomes; post-op follow-up etc.
   
• Creates customized query reports for use by management and medical personnel, as required, including: performing preliminary analysis and creating statistical/informational/financial and inventory reports to facilitate management of the OR; instructing “expert users” in the use of query tools to ensure timely maintenance/ updating of the system and security files, while ensuring confidentiality of patient data 
   
• Maintains a log of outstanding problems; ensures outstanding problems are resolved quickly and effectively; Ensures sign-off by the appropriate Bariatric clinical staff for all changes to the system
   
• Participates in the implementation of new and/or upgrades to Bariatric Information System
   
• Performs cross-functional and/or other duties consistent with the job classification, as assigned or requested

• At Minimum over 3 years up to and including 4 years practical and related experience 
• One (1) year experience working with medical professionals required.          
• Experience developing proposals required.
• Extensive database management skills required.
• Extensive knowledge with business analysis and problem resolution required.
• Detailed knowledge of MS Access, including developing, supporting, and maintaining Access databases. 
• Comprehensive experience working with applications e.g., EPIC, EPR, Oracle required.
• Working knowledge of data query/reporting tools required.
• Ability to write complex Access database queries to extract bariatric information from the database.
• Ability to work effectively under stress required.
• Ability to work independently and be flexible and adaptable required.
• Ability to effectively deal with high priority unscheduled tasks and problems required.
• Ability to learn the query language employed by the SDIS required.
• Proficient in Microsoft Windows required.
• Statistical/financial analysis experience required.
• Excellent process analysis and application skills required.
• Excellent verbal, written and interpersonal communication skills required.
• Excellent problem recognition and problem solving skills required.
• Effective organizational/prioritization skills, ability to plan work efficiently and effectively required.
• Knowledge of (Bona Fide Occupational Requirement(s)
• At minimum, completion of a bachelors degree in Business Administration majoring in information systems, Clinical Epidemiology, Computer Science or recognized equivalent required.

Why join UHN?

In addition to working alongside some of the most talented and inspiring healthcare professionals in the world, UHN offers a wide range of benefits, programs and perks. It is the comprehensiveness of these offerings that makes it a differentiating factor, allowing you to find value where it matters most to you, now and throughout your career at UHN.

• Competitive offer packages
• Government organization and a member of the Healthcare of Ontario Pension Plan (HOOPP https://hoopp.com/)
• Close access to Transit and UHN shuttle service
• A flexible work environment
• Opportunities for development and promotions within a large organization
• Additional perks (multiple corporate discounts including: travel, restaurants, parking, phone plans, auto insurance discounts, on-site gyms, etc.)

Current UHN employees must have successfully completed their probationary period, have a good employee record along with satisfactory attendance in accordance with UHN's attendance management program, to be eligible for consideration.

All applications must be submitted before the posting close date.

UHN uses email to communicate with selected candidates.  Please ensure you check your email regularly.

Please be advised that a Criminal Record Check may be required of the successful candidate. Should it be determined that any information provided by a candidate be misleading, inaccurate or incorrect, UHN reserves the right to discontinue with the consideration of their application.

UHN is an equal opportunity employer committed to an inclusive recruitment process and workplace. Requests for accommodation can be made at any stage of the recruitment process. Applicants need to make their requirements known.

We thank all applicants for their interest, however, only those selected for further consideration will be contacted.