Analyst II (Jr. Analyst, Data and Reporting)

University of Guelph; Guelph; On-site; CAD 50,000 - 70,000; Full time

Job summary

The Ontario Veterinary College at the University of Guelph seeks a collaborative Jr. Analyst, Data and Reporting to join the OVC Data and Analytics team within Integrated College Services.

You will transform data into meaningful information to support planning, operations, service delivery, and decision-making across the College, delivering data via Power BI and Copilot Agents. Responsibilities include designing data assets, reports, and dashboards; integrating data into the analytics

Qualifications

• Undergrad degree in a relevant field (CS, stats, business, data analytics, information systems).
• 3–5 years experience with data, reporting, BI, or analytics tools.
• Experience organizing, validating, transforming, and analyzing data.
• Experience developing reports, dashboards, or other data products.
• Knowledge of databases, data structures, data modelling, or data management practices.

Responsibilities

• Understand business processes, information needs, and reporting requirements.
• Design, develop, maintain, and improve data assets using SharePoint and other systems.
• Develop dashboards and analytical tools to support decision-making.
• Integrate College-managed data into the analytics environment.
• Review and organize data for quality, consistency, and usability.
• Assist with data modelling, governance, and platform administration.
• Identify opportunities to improve reporting processes and access to information.
• Troubleshoot data and reporting issues with stakeholders.
• Prepare documentation and provide guidance for data tools and reports.
• Collaborate with OVC Technology Group and Institutional Research and Planning.
• Contribute to AI, automation, and advanced analytics initiatives.

Skills

Data analysis

Reporting

Communication

Problem solving

Attention to detail

Education

Bachelor’s degree in CS/Statistics/Business/Data Analytics/IS

Tools

SharePoint

Power BI

Microsoft Fabric

SQL

Job description

Select how often (in days) to receive an alert:

Analyst II (Jr. Analyst, Data and Reporting)

Location:
Guelph, ON, CA, N1G 2W1

Primary Category Page: Staff and Management

Division: OVC Administration

Requisition ID: 3041

Department: OVC Integrated College Services
This position is represented by the agreement between the Professional Staff Association and the University of Guelph

Temporary full-time from 11/23/2026to05/19/2028

General Purpose

The Ontario Veterinary College is seeking a collaborative and service-oriented Jr. Analyst, Data and Reporting to join the OVC Data and Analytics team within Integrated College Services.

Working with faculty, staff, administrative units, and technology colleagues, the Jr. Analyst will help transform data into meaningful information that supports planning, operations, service delivery, and decision-making across the College. The position will contribute to the development and improvement of OVC’s data assets, reports, dashboards, and analytical solutions.

A key focus of the role will be supporting business-managed data structures, primarily through Microsoft SharePoint and some 3rd party applications. The Jr. Analyst will help integrate these data assets into the College’s analytics environment (Microsoft Fabric) and ensure that information is accurate, consistent, accessible, and aligned with operational and reporting needs. Finally, data is delivered via PowerBI and/or Copilot Agents.

Key Responsibilities

The Jr. Analyst will:

• Work with stakeholders to understand business processes, information needs, and reporting requirements.
• Design, develop, maintain, and improve structured data assets using SharePoint and other departmental systems.
• Develop and maintain reports, dashboards, and analytical tools that support operational and strategic decision-making.
• Support the integration of College-managed data into OVC’s broader analytics environment.
• Review, validate, and organize data to improve its quality, consistency, accuracy, and usability.
• Assist with data modelling, documentation, governance, and platform administration.
• Identify opportunities to improve reporting processes, data collection, automation, and access to information.
• Troubleshoot data and reporting issues and work with stakeholders to develop practical solutions.
• Prepare documentation and provide guidance or training to support effective use of data tools and reports.
• Collaborate with analysts in the OVC Technology Group and Institutional Research and Planning.
• Contribute to emerging initiatives involving artificial intelligence, automation, advanced analytics, and modern data platforms.

Requirements

The successful candidate will have:

• An undergraduate degree in computer science, statistics, business, data analytics, information systems, or a related discipline.
• 3-5 years experience working with data, reporting, business intelligence, information systems, or analytical tools.
• Experience organizing, validating, transforming, and analyzing data.
• Experience developing reports, dashboards, or other data products.
• Knowledge of databases, data structures, data modelling, or data management practices.
• Strong analytical and problem-solving skills, with careful attention to accuracy and detail.
• The ability to understand business requirements and translate them into practical data or reporting solutions.
• Strong communication and interpersonal skills, including the ability to explain technical information to non-technical audiences.
• The ability to manage competing priorities, work collaboratively, and contribute effectively within a service-oriented team.
• Sound judgment when working with sensitive, confidential, or restricted information.
• Experience with Microsoft 365, SharePoint, Power BI, Microsoft Fabric, SQL, or related data and reporting technologies would be considered an asset.

About OVC and Integrated College Services:

The Ontario Veterinary College is a diverse and complex academic environment supporting teaching, research, clinical service, and College operations. The position is part of OVC’s Integrated College Services model, which brings together specialized administrative and technology teams to provide coordinated, client-focused support across the College. OVC’s service model emphasizes collaboration, consistency, continuous improvement, and teams providing service rather than individuals working in isolation.

This position offers an opportunity to contribute to the continued development of OVC’s data and analytics capabilities while working on practical projects that improve how information is collected, managed, understood, and used across the College.

Employee Type: Temporary
Position Number: 10928909

*Te ntative evalation; subject to committee review.

At the University of Guelph, fostering a culture of inclusion is an institutional imperative. The University invites and encourages applications from all qualified individuals, including from groups that are traditionally underrepresented in employment, who may contribute to further diversification of our Institution.

Posting Date: 10/23/2026
Closing Date: 10/30/2026