Cogito Business Intelligence Developer, Cogito Reporting

Description

This is a new, permanent full-time, non-union Business Intelligence Developer role in the Cogito Reporting department at Toronto General Hospital, reporting to the Program Manager. One position is open.

Cogito is the data analytics and reporting suite of the EHR vendor the hospital uses. The developer builds Cogito reporting content, with a focus on AI and cognitive computing models, custom dashboards, complex reporting workbenches, SlicerDicer filters and complex data extracts built to end-user specifications.

You will work with other BI analysts and developers, data engineers, clinical subject matter experts and the application team.

The organization runs ten sites and has more than 44,000 team members. It is a research hospital affiliated with the University of Toronto and runs the largest hospital-based research program in Canada, covering neurosciences, cardiology, transplantation, oncology, surgical innovation, infectious diseases, genomic medicine and rehabilitation medicine.

Responsibilities

• Meet with stakeholders, subject matter experts and end users to pin down Cogito reporting needs and the needs of data consumers.
• Lead complex Cogito projects on the Data and Analytics roadmap.
• Write Cogito reporting content in SQL against the Clarity and Caboodle reporting databases.
• Develop, test and validate AI and cognitive computing models within Cogito reporting content.
• Build SlicerDicer custom filters and sessions on the Caboodle database.
• Create the Cogito reporting workbench using rules and PAFs.
• Build custom Cogito radar dashboards and a custom SQL reporting workbench.
• Read EMR upgrade and special update documentation and carry out the Cogito build work it calls for.
• Own all Cogito reporting content across the proof of concept, test and production environments.
• Write clear internal and client-facing documentation, including system requirement specifications and business requirements documents.
• Check peer reports for validity, accuracy and completeness.
• Create, change and maintain the Analytics Catalog and its metadata records.
• Design, implement and maintain an enterprise-wide reporting security policy.
• Train and support end users.
• Fix reporting content problems and user access issues.
• Build alternative reporting solutions when the EMR's reporting tools fall short.

Requirements

• An undergraduate degree in health informatics, computer science, epidemiology, industrial engineering, business analytics or an equivalent field is required.
• A master's degree is preferred.
• Certification in Cogito BI development (Cogito fundamentals, Clarity and Caboodle data models, and clinical and/or revenue/access data models) or equivalent experience is required. It can be completed during the probationary period.
• At least 3-5 years of experience building, testing and deploying business intelligence and data analytics reporting tools.
• Strong in-depth knowledge of the organization's system build, end-user workflows and usage patterns is preferred.
• Knowledge of clinical and business workflows and data in a Canadian healthcare setting.
• Knowledge of Ontario healthcare clinical and financial reporting requirements is required.
• Familiarity with the structure of the EMR application and its database.
• Experience working with an EMR system.
• Python proficiency is required.
• Proficiency in SQL and relational database concepts.
• Proven proficiency and experience with analytics tools.
• Ability to understand data structures.
• Experience in a large clinical IT transformation within a healthcare setting.
• Certification in Cogito is preferred.
• Strong communication and organizational skills.
• Critical thinking and an analytical mind.
• Technical skill to design and write reports.
• Ability to lead requirements gathering sessions, document user requirements and turn them into useful solutions.
• Ability to convert end-user, workflow-based report requests into the specific data points needed.
• Ability to analyze data, solve problems and explain solutions clearly to technical and non-technical stakeholders.
• Ability to work independently and as part of a team.
• Ability to learn on your own in a fast-moving environment where things change quickly.
• Ability to own your work and deliver it accurately, efficiently and on time.
• Ability to build a deep understanding of EMR data models through courses organized by content area.
• Additional information is required.

Conditions

Permanent full-time position, based at Toronto General Hospital.

Applications must be submitted by the closing date of November 16, 2026.

Current employees must have completed their probationary period, have a good employee record and meet the attendance standards of the attendance management program to be considered.

The organization may use artificial intelligence tools to help screen, assess and select candidates.

A criminal record check may be required of the successful candidate. Any misleading, inaccurate or incorrect information in an application may lead to it being dropped from consideration.

The organization is an equal opportunity employer. Accommodation requests can be made at any stage of recruitment.

Only candidates selected for further consideration will be contacted.

Benefits

• Work alongside highly skilled healthcare professionals.
• Pay and pension as a government organization, with membership in the Healthcare of Ontario Pension Plan (HOOPP).
• Competitive compensation packages.
• Close access to transit and a shuttle service.
• A flexible work environment.
• Opportunities for development and promotion within a large organization.
• Corporate discounts on travel, restaurants, parking, phone plans and auto insurance, plus on-site gyms and other perks.