Trillium Health Partners

Senior Advisor, Business Intelligence

System ID
Job Type
Full Time
Credit Valley Hospital
Number of Positions

Job Description

Position: Senior Advisor, Business Intelligence

Dept/Health Program: Performance Analytics & Business Intelligence

Posting ID: 2024-38195

Status: Permanent Full-Time (x2)

Role Level: PG11 ($45.04 to $56.29)

Site: Credit Valley Hospital

Hours of Work/Shift: 37.5 hours per week

Posted: July 9, 2024

Internal Deadline: July 16, 2024


Trillium Health Partners (THP) is one of the largest community-based acute care facilities in Canada. Comprised of the Credit Valley Hospital, the Mississauga Hospital, the Queensway Health Centre, and the Reactivation Center at Humber. Trillium Health Partners serves the growing and diverse populations of Mississauga, West Toronto and surrounding communities and is a teaching hospital affiliated with the University of Toronto.

Our Mission:     A New Kind of Health Care for a Healthier Community

Our Values:       Compassion, Excellence, Courage

Our Goals:        Quality, Access, Sustainability

Our Enablers:    People, Education, Innovation, Research


A key enabler to THP’s strategic plan is data and analytics. The Performance and Business Intelligence portfolio, in collaboration with teams across THP, will design, architect, govern and deploy high quality data and analytics, to support strategic performance insights and planning to enable THP’s mission of ‘A New Kind of Health Care for a Healthier Community’. Building upon several key achievements, this portfolio will continue to advance the development of an enterprise health data strategy and roadmap. The Performance and Business Intelligence portfolio is made up of Performance Analytics and Case Costing, the Business Planning Office, and the Business Intelligence Department. The Clinical Systems and Informatics portfolio is made up of our Epic applications and training teams focusing on the support and continued growth of our Epic platform, our clinical operating platform, the Clinical Enterprise Data Warehouse (Cogito), and Clinical Informatics which supports all clinical applications across THP.


Reporting into both the VP of Performance and Business and Intelligence and the VP of Clinical Systems and Informatics, the Business Intelligence department’s mandate is to plan, build, implement, and govern exceptional data infrastructure and solutions that are efficient, sustainable, and secure. We are advocates of data governance industry best practices (inclusive of data literacy, data quality, and data management) while providing reporting and analytics, and data visualization for our progressive enterprise.


Position Summary:


Reporting to Manager of Cogito and Business Intelligence and working closely with the THP@home Office; a program supporting patients in their own home by providing customized professional services and equipment the Senior Advisor, Business Intelligence will be a key team member in building our data infrastructure in THP’s strategy to address hospital capacity pressures by expanding integrated hospital to home care. Integrated hospital to home care and the THP@home Office is rapidly expanding to support additional patient groups and their care and is working towards building and consolidating systems for clinical documentation, monitoring and evaluation, financial billing and reconciliation, remote care monitoring, patient and family education, and partner performance management.

In addition, the Senior Advisor will also be responsible for running BI project solutions and moving the needle on the skill set of Business Intelligence team. A self-motivated individual with exceptional technical, theoretical, communication and analytical skills with a demonstrated commitment to customer service will excel in this position.



  • Expert Knowledge of Data modeling, SSRS, SSAS, Tabular Models/Cubes, SQL Server (2016 – 2023), PowerPivot, PowerView, and advanced SQL Scripting. Will help to advise, coordinate, direct and model BI Solutions in SSRS, Power BI, EPIC, Data warehousing, BI developed data applications.
  • Provide Leadership in Modelling and Developing Business Intelligence systems including documenting business requirements, data warehousing, reports, BI solutions, and Data Governance.
  • Expert analysis to identify opportunities, appropriateness of technology, and resolve issues in BI applications, solutions.
  • Education of clients regarding data literacy and data governance.
  • Design and develop dashboards and scorecards and reports using a third-party report writing tool such as SSRS, Power BI, or Tableau, to display data from a reporting server,
  • Build extracts using SQL, enterprise (EPIC,MS )reporting tools against enterprise systems (Clarity, Caboodle, Data warehouse).
  • Build analytical registries within Epic that align with integrated care pathways.
  • Project management support to facilitate advanced analytics, development of BI solutions, upgrades, and stakeholder engagement.
  • Be a leading voice in weekly meetings with team members to discuss the status of deliverables, shared issues, end user concerns, and upcoming milestones.
  • Identify issues that arise in the application area as well as issues that impact other application teams and advise on work to resolve them.
  • Be a leader in testing, debugging and deployment of all BI solutions and web applications following industry standard SDLC – Software Development Life Cycle procedures.
  • Provide professional internal and client-facing documentation (SRS - System Requirement Specifications, BRD - Business Requirements Documentation etc.) through a combination of wireframes, workflow diagrams and written documentation.
  • Achieve certification in vendor’s application as required.


Key Qualifications:

  • University Degree in Computer Science or Community College Diploma (3-year program)
  • Microsoft BI certification is considered an asset.
  • 3 plus years’ experience in SQL Server (2016 – 2022)
  • Theoretical and Applicable knowledge to design and development in SSRS 2016+, Power BI, EPIC reporting software
  • Knowledge and experience using Epic relational databases (Clarity and Caboodle)
  • Theoretical and Applicable knowledge creating analytical registries within Epic.
  • Lead in requirement gathering sessions, document user requirements and translate them into useful solutions.
  • Experience in maintaining proper data governance best practices.
  • Theoretical and Applicable knowledge in SQL programming and stored procedures
  • Experience with Visual studio 2016+ and TFS (Team Foundation Server)
  • Theoretical and Applicable knowledge to in Data Architecting and development in Microsoft BI Stack (SSRS, SSIS, SSAS, .Net, SharePoint) and EPIC reporting software
  • Experience troubleshooting data models and performance tuning of SQL scripts, stored procedures and SSRS reports.
  • Knowledge of SQL Server security and administration
  • Experience using, designing, and developing Data Marts and Models
  • Theoretical and Applicable knowledge in SQL database technologies
  • Knowledge of mobile application design is considered an asset.

To be successful as a senior advisor, you should demonstrate great skill in creativity and innovation, ability to thrive in a high-pressure environment, and possess excellent communication skills.


To pursue this career opportunity, please visit our website:


Internal Candidates who believe they possess the necessary qualifications and experience for this position and who have been in their current position for at least six (6) months are encouraged to apply.


Candidates are selected on the basis of their skill, ability, experience and qualifications.

Where these factors are relatively equal seniority shall govern providing the successful applicant.


 Trillium Health Partners’ (THP) is an equal opportunity employer who values the importance of antiracism work and is committed to integrating antiracism, diversity, equity and inclusion best practices throughout THP operations, policies and culture. Therefore, we ask that even if you do not see yourself fully reflected in every job requirement listed on this posting, we still encourage you to reach out and apply. Research has shown that candidates from underrepresented groups often only apply when they feel 100% qualified. We encourage all applicants who are members of groups that have been marginalized on any grounds enumerated under the Ontario Human Rights Code based on race, gender identity or expression, sex, sexual orientation, disability, political belief, religion, marital or family status, age, and/or status as a First Nations, Métis or Inuk/Inuit person to consider this opportunity.


In accordance with the Accessibility for Ontarians with Disabilities Act, 2005 and the Ontario Human Rights Code Trillium Health Partners will provide accommodations throughout the recruitment and selection process to applicants with disabilities.  If selected to participate in the recruitment and selection process, please inform Human Resources of the nature of any accommodation(s) that you may require in respect of any materials or processes used to ensure your equal participation.


All personal information is collected under the authority of the Freedom of Information and Protection of Privacy Act.


Trillium Health Partners is identified under the French Language Services Act.



We thank all those who apply but only those selected for further consideration will be contacted.



Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed