Apply now »

Senior BI Specialist

Date Posted: 07/21/2025
Req ID: 44120
Faculty/Division: Operations and Real Estate Partnerships
Department: Institutional Research and Data Governance
Campus: St. George (Downtown Toronto)
Position Number: 00051272

 

Description:

 

About us:

The University’s Institutional Research and Data Governance (IRDG) office provides leadership and administrative support for the institution’s data strategy. The IRDG office’s mandate is to:

• Provide reporting and analytics services within our distributed institutional research model: lead institution-wide analysis projects, provide training opportunities for divisional analysts, implement new analytics tools and platforms, and improve access to curated institutional datasets.
• Support external reporting of institutional data (SMA metrics, key performance indicators for governance, international rankings, data exchanges with peer institutions).
• Implement an institution-wide data governance program to support the University in strategically harnessing data to achieve institutional goals.
• Provide leadership and administrative support for the institution’s data strategy.

Your opportunity:

Under the general direction of the Manager, Data Engineering & Business Intelligence, the incumbent provides business intelligence solutions to support institutional initiatives at the University of Toronto. The incumbent will engage clients to understand business needs and translate requirements into institutional datasets, reporting and analytics products that generate insights for the University and its Divisions. These applications will require a variety of technical skills including SQL, as well as visualization technologies such as Tableau and PowerBI. The incumbent will work closely with various teams within IRDG (Data Engineering, Data Governance) and Enterprise Applications and Solutions Integration team within the CIO portfolio to operationalize data and analytics products. Duties include: working with clients in Central and Academic Divisions such as Human Resources, Research Services, Enrolment Services, Financial Services and academic divisions, to determine business and information requirements; the ideal candidate will have an understanding of data models, experience with ETL technology and experience developing solutions in Azure environments. Individual must have experience working in agile development style, understands process and must be collaborative.

Your responsibilities will include:

 

  • Engaging with clients to analyze and document business requirements
  • Analyzing and developing program scripts to extract, reformat and analyze data
  • Writing complex technical code
  • Developing test scripts and performing testing activities
  • Commenting on programming code for the purposes of standardization and consistency
  • Analyzing and making recommendations for programming enhancements
  • Troubleshooting and resolving technical issues
  • Developing project schedules including milestones, critical path, timelines, deliverables and reporting

 

Essential Qualifications:

 

  • Bachelor's Degree in Computer Science, Applied Mathematics, Engineering or an acceptable combination of equivalent experience.
  • Minimum five (5) years of working experience as a BI developer
  • Experience working with MySQL databases and Microsoft SQL
  • Knowledge of Azure MI
  • Knowledge of Azure Data Factory
  • Demonstrated experience in engaging with clients to understand business requirements
  • Demonstrated experience in creating reports/dashboards/KPIs in accordance with business requirements
  • Demonstrated experience working with large and complex data sets as well as experience analyzing volumes of data
  • Demonstrated experience in creating data modelsand datasets
  • Experience with Tableau, PowerBI or other business intelligence tools essential.
  • Exceptional analytical skills, showing fluency in the use of tools such as MySQL.
  • Ability to design, build, and maintain the business’s ETL pipeline and data warehouse.


Assets (Nonessential):

 

  • Familiarity with Microsoft Azure DevOps


To be successful in this role you will be:

 

  • Articulate
  • Cooperative
  • Motivated self-learner
  • Resourceful
  • Team player

 

Closing Date: 07/29/2025, 11:59PM ET
Employee Group: USW 
Appointment Type: Budget - Continuing 
Schedule: Full-Time
Pay Scale Group & Hiring Zone:
 
Job Category: Engineering / Technical
Recruiter: Sabrina Gava

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.

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 uoft.careers@utoronto.ca.


Job Segment: Business Intelligence, Administrative Assistant, Computer Science, Data Warehouse, ERP, Technology, Administrative

Apply now »