Senior Data Analyst, BI Developer

Get AI-powered advice on this job and more exclusive features. Faculty/Division: Temerty Faculty of Medicine Department: MedIT Campus: St. George (Downtown Toronto) Position Number: 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 thepromotion 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 securityconcepts, 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: 11/13/2025, 11:59PM ET Employee Group: USW Appointment Type : Budget - Continuing Schedule: Full-Time USW Pay Band 15 -- $97,348. with an annual step progression to a maximum of $124,491. Pay scale and job class assignment is subject to determination pursuant to the Job Evaluation/Pay Equity Maintenance Protocol. Job Category: Information Technology (IT) Recruiter: Sharon Hung 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 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 Seniority level: Associate Employment type: Full-time Job function: Education and Information Technology Industries: Higher Education, Information Services, and IT System Custom Software Development #J-18808-Ljbffr