Senior Data Analyst & BI Developer

University of Toronto; Toronto; On-site; CAD 80,000 - 120,000; Full time

Job summary

A leading educational institution in Toronto is looking for a Senior Data Analyst, BI Developer to enhance data-driven decision-making. The role involves designing and maintaining Power BI dashboards, ensuring data governance, and collaborating with various stakeholders. The successful candidate will possess a Master's degree, strong technical skills in data analysis and BI tools such as Power BI and Tableau, along with experience in data management and governance. This position offers a dynamic environment in a prestigious institution.

Qualifications

• Master's degree or equivalent in a relevant field.
• Five years of experience in data analysis for decision making.
• Strong technical skills with BI tools and data management.

Responsibilities

• Design and maintain Power BI dashboards.
• Translate data models into actionable business intelligence.
• Ensure data governance and compliance.

Skills

Advanced Power BI

DAX

SQL

Data modeling

Data governance

Data quality frameworks

Statistical analysis

Agile/Scrum

Problem solving

Data storytelling

Education

Master's Degree in statistics, information science, data science, or equivalent

Tools

Power BI

Tableau

Azure SQL

Azure DevOps

Python

Databricks

Job description

Description

About us:

Home to over 40 departments and institutes, the University of Toronto's Temerty Faculty of Medicine lies at the heart of the Toronto Academic Health Science Network and is a global leader in ground‑breaking research and education, spanning clinical medicine, basic science and the rehabilitation sciences sectors.

Your opportunity

MedIT provides information technology support for the Temerty Faculty of Medicine. Our mission is to partner and collaborate with clients, University, and third parties to determine value based, sustainable technology solutions that enable the Faculty to achieve its academic mission.

We are seeking a Senior Data Analyst, BI Developer to join our growing Data Team. This role will work closely under the supervision and guidance of the Data Architect. The Senior Data Analyst, BI Developer will be pivotal in enabling data-driven decision-making at MedIT and other units at Temerty Medicine. You will ensure consistent, reliable and governed data, alignment with our data strategy, self-service analytics, and compliance. You will be responsible for end-to-end report development, data modelling, performance tuning, visual storytelling, collaborating with cross-functional teams clarify requirements, define KPIs, and support analytics initiatives.

Your responsibilities will include

• Design, develop, and maintain Power BI dashboards and reporting artifacts
• Translate enterprise data models and requirements into actionable BI solutions in collaboration with Data Architect and other stakeholders
• Support BI architecture and cross-functional analytics initiatives, ensuring governance, data quality, security (RLS/AAD), and standardized KPI definitions.
• Manage BI delivery pipelines including CI/CD (Azure DevOps or Git), automated dataset refreshes, performance tuning (incremental refresh, aggregations, composite models), and deployment automation via APIs and scripting.
• Collaborate with stakeholders to define KPIs, requirements, analytics roadmaps, and promote data literacy and best practices.
• Ensure compliance and governance in data handling, oversee permissions, privacy alignment (PIPEDA/FIPPA), and maintain documentation, standards, and reusable BI components.

Essential Qualifications

• Master’s Degree with a background in statistics, information science, data science, mathematics, computer science or an acceptable equivalent combination of education and experience.
• Minimum five (5) years of relevant experience supporting data-driven decision making by conducting detailed data analysis and using large datasets, preferably in a post-secondary education or research-intensive institution.
• Advanced Power BI, DAX, SQL, and data model optimization skills; proven ability to build enterprise semantic layers and data marts.
• Strong technical skills: understanding of relational databases, creating scripts for performing batch uploads, and experience with Business Intelligence tools such as Tableau, Power BI, and SSRS.
• Deep knowledge of data warehouse/lakehouse architectures, ETL pipelines, and dimensional modeling (Kimball/Inmon).
• Experience with Azure Synapse, Databricks, Azure SQL, or equivalent platforms; familiarity with Azure Data Factory or similar ETL orchestrators
• Strong understanding of data governance, data quality frameworks, metadata management, security, and compliance in academic or public-sector settings.
• Ability to utilize statistical tools to conduct regression analysis, correlation studies and other statistical analysis.
• Familiarity with Agile/Scrum, version control (Git, Azure DevOps), and BI testing frameworks.
• Experience with Power BI REST API, PowerShell, or Python to automate deployment, metadata extraction, and reporting workflows.
• Strategic thinker with strong problem-solving skills and a passion for data literacy
• Strong oral and written communications skills to explain complex statistical information to decision makers, probe for information to establish needs and respond to request, and communicate data query requirements to other Data Analysts.
• Ability to work independently and as part of a team.
• Ability to make meaningful stories from data.
• Excellent analytical and problem solving skills.
• Ability to work well under pressure and meet competing priorities with the highest level of accuracy.
• Applicants are also expected to show evidence of a commitment to equity, diversity, inclusion, and the promotion of a respectful and collegial learning and working environment.

Assets (Nonessential)

• Experience working with student data in higher education environment.
• Experience developing data visualizations using Tableau dashboards for higher education.
• Working knowledge of University of Toronto systems (Student Information Systems (ROSI), Degree Explorer, eMarks, Web Scheduler, eService, Slate).
• Experience with Microsoft Fabric, Azure Purview, or Power BI Certified Datasets.
• Exposure to data security concepts, including Row-Level Security, access controls, and compliance considerations (HIPAA, FIPPA, etc.).

To be successful in this role you will be

• Accountable
• Articulate
• Meticulous
• Proactive

Closing Date: 02/23/2026, 11:59 PM ET

Location: St. George (Downtown Toronto)

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