This job has expired

Senior BI Developer

University of Toronto
St. George (Downtown Toronto)

View more

Administrative Jobs
Institutional & Business Affairs, Institutional Research & Planning
You need to sign in or create an account to save a job.

Job Details

Senior BI Developer

Date Posted: 07/19/2021
Req ID: 6401
Faculty/Division: Operations & Real Estate Partnerships
Department: Institutional Research and Data Governance
Campus: St. George (Downtown Toronto)


About us:

The University’s Institutional Research and Data Governance (IRDG) office was formally launched in 2020. In addition to providing the 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; implement an institution-wide Data Governance program to support the University in strategically harnessing data to achieve institutional goals; and support external reporting of institutional data (SMA metrics, key performance indicators for governance, international rankings, data exchanges with peer institutions).

Your opportunity:

Under the general direction of the Director, Reporting & Analytics, the incumbent provides business intelligence solutions to support institutional initiatives at the University of Toronto. The incumbent will engage clients to understandbusiness 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, R, or SAS, 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
  • Commenting on programming code for the purposes of standardization and consistency
  • Analyzing and making recommendations for programming enhancements
  • Developing test scripts and performing testing activities
  • 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 years working experience as a BI developer.
  • Experience working with MySQL databases and Microsoft SQL.
  • 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 analysing volumes of data.
  • Demonstrated experience in creating data models and 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 platform an asset.

To be successful in this role you will be:

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

Closing Date: 08/02/2021, 11:59PM ET
Employee Group: USW
Appointment Type: Budget - Continuing
Schedule: Full-Time
Pay Scale Group & Hiring Zone:
USW Pay Band 16 -- $89,529 with an annual step progression to a maximum of $114,493. Pay scale and job class assignment is subject to determination pursuant to the Job Evaluation/Pay Equity Maintenance Protocol.
Job Category: Information Technology (IT)

.buttontext00b26598368a4abe a{ border: 1px solid transparent; } .buttontext00b26598368a4abe a:focus{ border: 1px dashed #25355a !important; outline: none !important; }

All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.

Diversity Statement
The University of Toronto is strongly committed to diversity within its community and especially welcomes applications from racialized persons / persons of colour, women, Indigenous / Aboriginal People of North America, persons with disabilities, LGBTQ2S+ persons, and others who may contribute to the further diversification of ideas.

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

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].
All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.

Job Segment: Business Intelligence, Developer, Computer Science, ERP, Engineer, Technology, Engineering


Established in 1827, the University of Toronto is Canada's largest university, recognized as a global leader in research and teaching. U of T's distinguished faculty, institutional record of groundbreaking scholarship and wealth of innovative academic opportunities continually attract outstanding students and academics from around the world.

U of T is committed to providing a learning experience that benefits from both a scale almost unparalleled in North America and from the close-knit learning communities made possible through its college system and academic divisions. Located in and around Toronto, one of the world's most diverse regions, U of T's vibrant academic life is defined by a unique degree of cultural diversity in its learning community.The University is sustained environmentally by three green campuses, where renowned heritage buildings stand beside award-winning innovations in architectural design.


U of T is one of Canada’s Top 100 Employers.
U of T is one of Canada's Best Diversity Employers.


Are you looking for a challenging, meaningful career in a supportive and diverse environment?

Work where the world comes to think.

Work where the world comes to discover.

Work where the world comes to learn.


Opportunities exist for people from a wide range of backgrounds, ranging from recent graduates to experienced senior professionals.

We offer challenging work within an open environment that celebrates diversity in all its forms. Our focus is on creating a positive work environment that attracts and retains excellent employees through a combination of competitive compensation, favourable working conditions, opportunities for career growth and development and a unique organizational culture.

Employees have access to:

  • Excellent health and dental benefits;
  • On-site support for training and career development;
  • Flexible work arrangements;
  • Childcare subsidy;
  • Tuition waivers;
  • Scholarships and/or tuition waivers for dependants;
  • Generous paid time off;
  • Support on equity and diversity issues;
  • On-site child care;
  • University Pension Plan;
  • Subsidized athletic facility membership;
  • World-renowned libraries;
  • Confidential counselling services;
  • Parking and TTC Metropasses;
  • Employee and Family Assistance Plan;
  • Continued health benefits for pensioners.


Find Us
You need to sign in or create an account to save a job.

Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert