Senior Bi Specialist

Toronto, ON, CA, Canada

Job Description

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.

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD2543822
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Toronto, ON, CA, Canada
  • Education
    Not mentioned