• Job Description

  Req#: 32807

  Job Description

  _________________________________________________________

  Position: Business Intelligence Developer/ Advisor

  Dept/Health System: Performance & Business Intelligence

  File#: 2023-32807

  Role Level: PG10 ($38.67-$48.32) Per hour

  Status: Permanent Full Time

  Posted: April 27th, 2023

  Deadline:Until filled

  _______________________________________________________________

  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 stakeholders 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 a number of 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 Decision Support and Case Costing, the Business Performance 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 and implement efficient, sustainable and secure solutions for data infrastructure, data management, data quality, data analytics, reporting and data visualization.

  Position Summary:

  Reporting to Manager of Cogito and Business Intelligence, the Business Intelligence Developer/ Advisor is responsible for supporting Business Intelligence solutions for Trillium Health Partners. In addition, the BI Advisor will also be responsible for deployment, development and troubleshooting data as well as technical issues THP BI products. A self-motivated individual with exceptional technical, communication and analytical skills with a demonstrated commitment to customer service will excel in this position. The Business Intelligence Advisor is responsible for providing the following:

  THP is committed to internal talent, and therefore priority will be given to internal applicants.

  Job Responsibilities:

  • Maintain and support existing BI Solution in SSRS, Power BI, EPIC, Data warehousing, BI developed data applications
  • Define and document business rules for BI solutions, including data warehouse, reports, dashboard, scorecards and web applications.
  • Identify and review the appropriate technological solutions for various BI data, analyses, reporting, and visualization needs.
  • Maintain Data governance reports, data sets, and other BI solutions.
  • 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)
  • Document reporting and other BI Data Sets
  • Act as a primary support contact for SSRS administration, security and upgrades
  • Troubleshoot problems, questions, and review peer reports for validity;
  • Identifying advanced analytics opportunities in interactions with clients
  • Test, debug and deployment of all BI solutions and web applications following industry standard SDLC – Software Development Life Cycle procedures
  • Attend 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 work to resolve them;
  • 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

  Knowledge and Experience Required

  • 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 2019
  • Ability to lead and/or participate in requirement gathering sessions, document user requirements and translate them into useful solutions;
  • Experience developing indicators and associated documentation;
  • Experience in maintaining proper data governance best practices
  • Applicable knowledge in SQL programming and stored procedures
  • Experience with Visual studio 2012+ and TFS (Team Foundation Server)
  • Applicable knowledge to design and development in Microsoft BI Stack (SSRS, SSIS, SSAS, .Net, SharePoint) and EPIC reporting software
  • Experience troubleshooting and performance tuning SQL scripts, stored procedures and SSRS reports
  • Knowledge of SQL Server security and administration
  • Experience using, developing Data Marts and Models
  • Ability to lead and/or participate in requirement gathering sessions, document user requirements and translate them into useful solutions
  • Knowledge of mobile application design is considered an asset

  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.

  To pursue this career opportunity, please visit our website: www.trilliumhealthpartners.ca

  Trillium Health Partners is an equal opportunity employer committed to fostering a healthy, safe and respectful environment for healing, based on our values compassion, excellence and courage. To be Better Together, we commit to fostering a respectful workplace culture that promotes a safe and supportive environment for everyone who provides care, supports caregiving, receives care or visits the hospital.

  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.

• About the company

  Trillium Health Partners is a hospital system which serves Mississauga, Ontario and western Toronto, Ontario in Canada.

Notice