Business Intelligence Developer/ Advisor

_________________________________________________________

Position: Business Intelligence Developer/ Advisor

Dept/Health System: Performance & Business Intelligence

File#: 2023-33771

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

Status: Permanent Full Time x2

Posted: July 5th, 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:

• Identifying advanced analytics opportunities in interactions with clients
• Identify issues that arise in the application area as well as issues that impact other application teams and work to resolve them;
• 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
• Maintain and support existing BI Solution in SSRS, Power BI, EPIC, Data warehousing, BI developed data applications
• Build extracts using SQL, enterprise (EPIC,MS )reporting tools against enterprise systems (Clarity, Caboodle, Data warehouse)
• Maintain Data governance reports, data sets, and other BI solutions.
• Attend weekly meetings with team members to discuss the status of deliverables, shared issues, end user concerns, and upcoming milestones;
• 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;
• Identify and review the appropriate technological solutions for various BI data, analyses, reporting, and visualization needs.
• Document reporting and other BI Data Sets
• Test, debug and deployment of all BI solutions and web applications following industry standard SDLC – Software Development Life Cycle procedures
• Troubleshoot problems, questions, and review peer reports for validity;
• Achieve certification in vendor’s application as required
• Act as a primary support contact for SSRS administration, security and upgrades
• Define and document business rules for BI solutions, including data warehouse, reports, dashboard, scorecards and web applications.

Knowledge And Experience Required

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