Business Intelligence Developer Jobs

Press Tab to Move to Skip to Content Link
Date Posted: 06/21/2023
Req ID: 32151
Faculty/Division: VP - Research
Department: Ofc of Vice Pres, Research & Innovation
Campus: St. George (Downtown Toronto)
Position Number: 00050948
Description
About us:
The Vice-President, Research & Innovation (VPRI) portfolio supports the University of Toronto as a top public research university in the world. Our mission is to create the most supportive environment possibleso that our researchers, innovators and learners can do what they do best — advance understanding and apply new knowledge. Our work supports, fosters and promotes the research and innovation culture and activities of our faculty, staff and students, along with our partner hospitals, funding sponsors, and partners in the public and private sector. VPRI provides a full range of services including guidance to faculty, staff and students on funding opportunities, research agreement negotiation, oversight and accountability services including research accounting, environmental health and safety, innovation and entrepreneurship, partnerships, policies and procedures, and institutional awards and honours.
Your Opportunity
This position will serve as technical lead for the implementation of the University's research discovery and analysis tool, DiscoverResearch which is an institutional online tool available to our broader research community and the public and allows internal and external users to discover research expertise within the University. The BI Developer will work as part of the project team on the implementation and the leveraging of data from our human resources, research and other systems along with external bibliometric services, to support and populate our research reporting information systems. The BI developer will also include supporting underlying datamarts for all the research reporting information systems. The BI will lead the development andtesting of all feeds and reports. The BI will facilitate technical connections to divisional and central systems.
Your Responsibilities Will Include

• Writing complex technical code, designing, developing, testing, debugging and maintaining data engineering (ETL) pipelines, delivering and maintaining datasets, components and tools; testing and evaluating programming code to ensure it has validity, compatibility, and that it meets appropriate standards
• Analyzing, recommending, and designing highly complex software architecture; Developing and updating architectural framework for highly complex and confidential university-wide applications
• Preparing and maintaining product/system documentation; writing and delivering technical documentation and production support runbooks, assisting in developing guidelines and procedures for work methods and technical improvements of products.
• Testing and implementing new or upgradeddata engineering projects; analyzing, developing and maintaining a formal description of the data & data structures;
• Assessing and determining feasibility of programming requests and requirements, evaluating and testing products/procedures to ensure they represent the most efficient and cost effective choices.
• Analyzing, recommending and designing technical solutions for highly complex technical problems, developing and/or customizing products to meet client's requirements, including designing, coding, and testing; these solutions may extend to desktop tools such as Excel;
• Planning and implementing components of IT related projects
• Keeping abreast of current information technologies and their applicability to products and services used/supported by the University

Essential Qualifications

• Experience with testing user-facing applications
• Demonstrable understanding of analysis and design methodologies using appropriate tools
• Minimum four (4) years' relevant experience including in database engineering, in managing large scale data warehouse environments, developing data engineering pipeline and, with Informatica and other ETL tools.
• Proficiency in SQL (DB2, SQL Server)
• Strong knowledge of MS Excel and data integration programming
• Proficiency with ETL tools including Informatica
• Demonstrated understanding of analysis and design methodologies
• Knowledge of AMS systems: FIS, HRIS or similar SAP-based data administration systems
• Bachelor's Degree or acceptable combination of equivalent experience.
• Excellent development skills and ability to retrieve data from different relational databases

Assets (Nonessential)

• Experience with Azure
• Experience with UI/UX
• Experience creating mock-ups and designing modern user-interfaces
• Demonstrated understanding of web-based client/server technologies
• Working knowledge of API layer, HTML, HTTP REST API, and web development and integration

To Be Successful In This Role You Will Be

• Adaptable
• Team player

Closing Date: 07/06/2023, 11:59PM ET
Employee Group: USW
Appointment Type: Budget - Term This is a one (1) year Term role.
Schedule: Full-Time
Pay Scale Group & Hiring Zone
USW Pay Band 16 -- $91,328 with an annual step progression to a maximum of $116,794. Pay scale and job class assignment is subject to determination pursuant to the Job Evaluation/Pay Equity Maintenance Protocol.
Job Category: Administrative / Managerial
Recruiter: Anita Chooraman
Lived Experience Statement
Candidates who are members of Indigenous, Black, racialized and 2SLGBTQ+ communities, persons with disabilities, and other equity deserving groups are encouraged to apply, and their lived experience shall be taken into consideration as applicable to the posted position.
All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.
Diversity Statement
The University of Toronto embraces Diversity and is building a culture of belonging that increases our capacity to effectively address and serve the interests of our global community. We strongly encourage applications from Indigenous Peoples, Black and racialized persons, women, persons with disabilities, and people of diverse sexual and gender identities. We value applicants who have demonstrated a commitment to equity, diversity and inclusion and recognize that diverse perspectives, experiences, and expertise are essential to strengthening our academic mission.
As part of your application, you will be asked to complete a brief Diversity Survey. This survey is voluntary. Any information directly related to you is confidential and cannot be accessed by search committees or human resources staff. Results will be aggregated for institutional planning purposes. For more information, please see http://uoft.me/UP .
Accessibility Statement
The University strives to be an equitable and inclusive community, and proactively seeks to increase diversity among its community members. Our values regarding equity and diversity are linked with our unwavering commitment to excellence in the pursuit of our academic mission.
The University is committed to the principles of the Accessibility for Ontarians with Disabilities Act (AODA). As such, we strive to make our recruitment, assessment and selection processes as accessible as possible and provide accommodations as required for applicants with disabilities.
If you require any accommodations at any point during the application and hiring process, please contact [email protected] .