Job Description:
Position: Business Intelligence Developer
Potin ID: 2024- 39067
Dept: Clinical Systems and Informatics (CSI), QRP
Number of Positions: 1
Status: Temporary Full-Time (12-Month Contract)
Role Level: Professional Group
- Business Intelligence Developer: PG 10 $42.77hr- $53.44 hr
Rate commensurate with experience
Hours of Work: Business Hours, 37.5 hrs/wk
Site: Mississauga Hospital
Posted: September 13,2024
Internal Deadline: September 20,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
Trillium Health Partners (THP) is a leading hospital with an outstanding record of performance, fiscal responsibility and quality patient care. THP operates on three main sites – Credit Valley Hospital, Mississauga Hospital, and Queensway Health Centre and offers a full range of acute care as well as a variety of specialized, community-based programs. THP’s mission is to create a new kind of health care for a healthier community. Guided by its values of compassion, excellence, and courage, THP’s strategic plan envisions a new approach to health – working in partnership to create an inter-connected system of care that is organized around the patient, both inside the Hospital and beyond its walls, by balancing quality, access and sustainability. With a vision for developing a common information platform that supports an efficient patient experience, common clinical best practices and continuity of information, THP has identified information and technology as key enablers on their journey to transforming care. For more information about THP, please visit their website at https://trilliumhealthpartners.ca
Reporting to Manager of Cogito and Business Intelligence, the Business Intelligence Developer 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
- Previous experience with Epic and/or Epic Certification within Cogito
- 3 plus years’ experience in SQL Server (2016 – 2022)
- 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 2016+ 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
We offer employees, in roles that are conducive to remote work, the flexibility and the right mix of remote and in-office work. Acknowledging that the primary work space will be remote work from home, but there will be times when onsite presence is appropriate just as there will be times when onsite presence may not be possible. The expectation is that remote work locations, as part of the Flex First program, will be in the employee’s place of residence, and adhere to all THP policies and procedures, with special consideration towards privacy. Since employees should be available to return to the workplace with 24 hours’ notice, remote work outside of the province or country is not acceptable.
To pursue this career opportunity, please visit our website: www.trilliumhealthpartners.ca
Internal candidates who believe they possess the necessary qualifications and experience for this position are encouraged to apply.
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.
