Full-time Business Intelligence Analyst

Algonquin College of Applied Arts and Technology; Ottawa; On-site; CAD 57,000 - 66,000; Full time

Benefits offered by this job

Health benefits

Tuition assistance

Career development

Flexible work arrangement

Job summary

Algonquin College is seeking a BI, Reporting and Analytics Developer to design, implement and optimize enterprise BI solutions. You will identify data sources, build data models and develop dashboards to support enrolment, budgeting and program analytics.

You will document processes and collaborate with internal clients to shape reporting needs and ensure data accuracy. The role requires a 3-year diploma in a related discipline, plus 5+ years in BI or analytics, and hands-on experience with

Qualifications

• Minimum three (3) year diploma or equivalent in Information Technology, Business or related analytical discipline.
• Approximately 100 hours of instruction in Microsoft Fabric, Power Platform, Microsoft Certified Professional, Microsoft BI Designation.
• Minimum of five (5) years practical experience in a reporting, database administration, analytics or business intelligence role.

Responsibilities

• Identify data sources within the data warehouse or other databases.
• Create, test and maintain data models to support required solutions.
• Create, test and maintain enterprise-level reports and dashboards.
• Produce and maintain technical documentation for team members and end-users.
• Provide guidance on BI tools and end-user self-service best practices.
• Meet with internal clients to determine reporting needs and requirements.

Skills

Data analysis

Reporting

Business intelligence

Education

3-year diploma or equivalent in IT/Business or related analytical discipline

100 hours Microsoft Fabric, Power Platform, MCPro, BI designation

Tools

Power BI

SQL

Microsoft Fabric

Power Platform

Job description

Position: BI, Reporting and Analytics Developer

Job Details

Department: Academic Operations and Planning

Position Type: Full‑Time Support

Salary Range: $41.20-$47.57-Hourly

Scheduled Weekly Hours: 36.25

Anticipated Start Date: September 14, 2026

Length of Contract: n/a

Posting Closing Date: September 8, 2026

Vacancy is for P23359

This position is paid at Payband I and is subject to the terms of the Full‑Time Support Staff Collective Agreement: https://www.algonquincollege.com/hr/files/2019/04/2018-2022_college_support_ft.pdf

Posting Information

Support Staff employees, as defined by the full‑time Support Staff Collective Agreement, will be given first consideration.

Location

Algonquin College campuses in Ottawa and Pembroke are located on the traditional unceded, and unsurrendered territory of the Anishinàbe Algonquin People.

Land Acknowledgment

Algonquin College campuses in Ottawa and Pembroke are located on the traditional unceded, and unsurrendered territory of the Anishinàbe Algonquin People. The Algonquin People have inhabited and cared for these lands since time immemorial. We take this time to express our gratitude and respect to them and to the land for all that it has provided and will continue to provide.

Duties and Responsibilities

As a BI, Reporting and Analytics developer, the incumbent creates, maintains and expands functionality by:

• Identifying appropriate data sources within the data warehouse or other databases;
• Creating, testing and maintaining data models to support the required solutions;
• Creating, testing and maintaining enterprise-level reports and dashboards;
• Producing and maintaining technical documentation for team members and end‑users.

Performs a variety of analysis activities, and provides technical guidance regarding BI tools:

• Institutional metric analysis (enrolment, retention and student satisfaction etc.).
• Financial analysis (program costing and overhead analysis).

Meets with internal clients to:

• Provide guidance, support on BI matters (e.g. end user self‑service best practices and enterprise report troubleshooting).
• To determine future reporting needs and establish requirements for new data requests if existing reports and processes do not achieve client’s required outcomes.
• Researches and stays current with relevant practices, products, technology, programs and tools.

Other duties as assigned by manager.

Required Qualifications

Minimum three (3) year diploma or equivalent in Information Technology, Business or related analytical discipline; Approximately 100 hours of instruction in the following: Microsoft Fabric, Power Platform, Microsoft Certified Professional, Microsoft BI Designation; Minimum of five (5) years practical experience in a reporting, database administration, analytics or business intelligence role.

Benefits and Compensation

• Compensation: Many roles offer a competitive base salary and comprehensive benefits, including health, dental, and retirement plans designed to support your well‑being. Eligibility for benefits vary by position.
• Learning and Development Opportunities: Access to training, tuition assistance programs (Algonquin College Courses and Degree Completion), certifications, workshops, and professional courses that allow you to grow and advance in your career.

Company Culture

Our values of caring, learning, integrity, and respect define how we interact with one another. We foster a supportive and collaborative environment.

Algonquin College has been recognized by Forbes as one of Canada’s Best Employers for 2025 and one of Canada’s Best Employers for Diversity for 2024.

Inclusion, Diversity, Equity, and Accessibility (IDEA): We are proud to be the first Ontario college to implement an Equity, Diversity, and Inclusion policy, fostering an inclusive workplace where all employees feel respected and valued.

Affinity Group Conversation Communities | Inclusion & Diversity & Truth and Reconciliation Flexible Work Arrangement Policy.

Select positions are eligible for hybrid work in accordance with the College’s Flexible Work Arrangement Policy https://www.algonquincollege.com/policies/hr26/ (subject to change).

We Use AI in Hiring

Algonquin College uses artificial intelligence technology to assist in screening and assessing applicants and their applications, while ensuring that all processes respect and uphold the provisions of applicable collective agreements above all else.

Accessibility

Algonquin College values diversity and is an equal opportunity employer. We are committed to fostering an inclusive, equitable, and culturally respectful workplace. We offer an inclusive work environment and encourage applications from candidates of all backgrounds, including Indigenous peoples, persons with disabilities, members of racialized groups, and individuals from diverse communities. If you require accommodation during the recruitment process, please contact the Human Resources department at [e-mail].

While we thank all those who apply, only those to be interviewed will be contacted.

Want a career that you can be proud of? We can help you build it. We are committed to growing your career through career and professional development, and providing you with the support, resources and technology you need to be successful. Algonquin College is proud to be recognized by Forbes as one of Canada's Best Employers.

Learn More

Algonquin College is proud to offer a lifetime retirement pension. Find out more information on the CAAT Pension Plan website: Full‑time Employees DB Prime Member Handbook Part‑time Employees DB Plus Member Handbook