Cogito Business Intelligence Developer

Union: Non-Union
Number of vacancies: 1
Site: Toronto General Hospital
Department: Cogito Business Intelligence
Reports to: Manager, Cogito Business Intelligence
Hours: 37.5 hours per week
Status: Permanent Full-Time
Closing Date: December 29, 2025

Position Summary

UHN Data & Analytics supports UHN’s growing demand for data, data-driven insights and helps TeamUHN ensure the needs of the patients come first.  Our collective goal is to better see, understand and use data to help UHN become a data-driven organization, which will help us achieve UHN’s strategic goals and ultimately advance care, research and education. UHN Data & Analytics supports UHN in data-driven decisions, data literacy, performance improvement, data governance, analytics, and automation as well as advances these capabilities through collaboration across the organization.

Cogito is Epic’s suite of data analytics and reporting tools. The Cogito Business Intelligence Developer (BID) reports to Manager, Cogito Business Intelligence. By working closely with other Cogito Business Intelligence (BI) Developers, this position is responsible to create data extract content based on end-user specifications.

The candidate for this role will possess a diverse skill set including SQL, Epic Clarity database and Caboodle database, excellent communication and interpersonal skills, as well as a background in data & analytics within a hospital environment.

Duties

• Work closely with stakeholders, subject matter experts, and end-users to understand the requirements, and analyze the needs of data consumers
• Identify and develop the appropriate technological solutions for various data needs;
• Build extract (in SQL) using Epic’s Reporting databases – Clarity and Caboodle;
• Write SQL queries and configure report settings for custom SQL metrics;
• Maintain existing reports/extracts, modify it as necessary;
• Distribute reports/extracts to data consumers;
• Review peer reports/extracts for validity;
• Test report/extract build in a specified testing environment and volume testing in live environments;
• Review upgrade documentation related to application features and determine how to implement the changes;
• Troubleshoot problems and questions.
• Provide support to end users.