Senior BI Specialist

Westfield State University; Toronto; On-site; CAD 103,000 - 133,000; Full time

Job summary

A prestigious educational institution in Ontario is seeking a Senior BI Specialist to deliver business intelligence solutions and support institutional initiatives. You will engage clients to understand their needs and create data analytics products using tools like SQL, Tableau, and PowerBI. Ideal candidates will have a strong background in data modeling and experience in agile environments, along with excellent analytical skills.

Qualifications

• Minimum five years of working experience as a BI developer.
• Experience working with MySQL and Microsoft SQL databases.
• Knowledge of Azure MI and Azure Data Factory.
• Demonstrated experience in engaging with clients.

Responsibilities

• Engaging with clients to analyze and document business requirements.
• Writing complex technical code for data analysis.
• Developing test scripts and performing testing activities.
• Troubleshooting and resolving technical issues.

Skills

SQL

Tableau

PowerBI

Data Modeling

ETL processes

Microsoft SQL

Azure Data Factory

MySQL databases

Business Intelligence tools

Analytical Skills

Education

Bachelor's Degree in Computer Science

Job description

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: USW Pay Band 16 -- $103,367. with an annual step progression to a maximum of $132,188. Pay scale and job class assignment is subject to determination pursuant tothe Job Evaluation/Pay Equity Maintenance Protocol.
Job Category: Engineering / Technical

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.

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

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 [e-mail].

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