About The Ottawa Hospital
The Ottawa Hospital (TOH) is one of Canada's largest learning and research multi-campus hospitals. With more than 1,400 beds and approximately 17,000 staff, physicians, residents and volunteers, we deliver specialized care to the Eastern Ontario, Western Quebec and Eastern Nunavut regions. At The Ottawa Hospital, we don't just serve our community, we belong to the community. That insight is at the heart of our ambitious plan to reshape the future of healthcare for our community.
From the compassion of our people to the relentless pursuit of new discoveries, The Ottawa Hospital never stops seeking innovative solutions to the most complex health care challenges while continually engaging with the community to support our vision to provide each patient with the kind of care and compassion we would want for our loved ones.
Working together with its research institute, the University of Ottawa, and other partners, the hospital is continually gaining national and international recognition for high-quality patient care, teaching and research, while striving to meet the needs of the culturally diverse community we serve.
Position Information
The Business Intelligence and Reporting Team is looking for a Senior Programmer Analyst to design, develop and build data pipelines from different source systems to our Enterprise Data Warehouse. The role will support the creation and utilization of reporting and data visualization solutions in various platforms. The Business Intelligence and Reporting team sits within the Analytics Department under the Digital Solutions Portfolio. The Analytics Team supports The Ottawa Hospital achieve excellence in patient care, research and innovation by enabling access to high quality data, self-serve tools and reporting solutions.
Temporary position until March 31st, 2027 approximately
Rotation/Shifts
Days, 8 hour shifts.
• For information purposes only - The Hospital reserves the right to change.
Basic Requirements
• University degree and/or college Diploma in a relevant discipline
• Minimum of five (5) years work experience in a computer programming environment demonstrating strong analytical and programming skills (various languages and platforms using structured methods)
• Experience analyzing and documenting business requirements and recommending solutions
• Experience trouble shooting and debugging applications
• High level of proficiency with SQL and relational databases (SQL Server, Azure SQL, MySQL)
• Experience programming transact-SQL queries and stored procedures
• High level of proficiency with Data Warehousing, ETL Tools (preferably SSIS)
• Experience with Business Intelligence development (preferably PowerBI)
• Excellent communications skills (oral and written)
• Excellent client service skills including patience and diplomacy
• Eligible to work in Canada
Preferred Qualifications
• Work experience in a healthcare setting
• Certified in Epic Cogito, Caboodle, Access and/or Clinical Data models
• Experience with Epic reporting tools (Reporting Workbench, Slicer Dicer, Metrics, RW SQL)
• Experience with Analytics, Data Science, Statistical and Quantitative analysis
• Experience with Data Governance and Master Data Management
• Proficiency in speaking and comprehending both English and French
What You Can Expect From Us
The Ottawa Hospital is committed to providing a healthy, safe, and inclusive work environment for everyone. We are driven by our purpose to provide each patient with the world-class care, exceptional service and compassion we would want for our loved ones.
We offer an attractive and equitable compensation package including a comprehensive benefits package, a Defined Benefit Pension (DBP) plan, and insurance protection. We also offer discounts from choice providers on a variety of products and services.
The Ottawa Hospital provides various Health and Wellness resources as well as opportunities for personal and professional development opportunities from our in-house Learning and Leadership Development team to help align your goals with your career objectives.
Interested? Apply today!
If you are passionate about what you do, motivated by improving the health of the community, excited by leading-edge medical technology, and as committed to excellence, quality and patient safety as we are, we would like to hear from you. Please submit an on-line application for the position you are interested in. We thank all those who apply but only those selected for further consideration will be contacted.
The Ottawa Hospital is an equal opportunity employer and is committed to providing an inclusive work environment. Candidates are encouraged to request accommodations throughout all stages of the recruitment process. These accommodation requests will be kept confidential. To request an accommodation or if you have any questions regarding accessibility, please contact HRSupport@toh.ca.
