Full-time Business Intelligence Analyst

Algonquin College; Ottawa; Hybrid; CAD 118,055,000 - 136,308,000; Full time

Job summary

Algonquin College in Ottawa, Ontario, is seeking a BI, Reporting and Analytics developer to design, implement, and maintain data models, reports, and dashboards for institutional information needs. The role emphasizes accuracy, governance, and collaboration with internal clients to define data requests and BI requirements.

You will construct metadata models, ensure data reliability, and provide guidance on BI tools and practices while delivering enterprise-scale reporting solutions.

Qualifications

• Three-year diploma or equivalent in IT, Business, or analytical field.
• Approx. 100 hours instruction in Microsoft Fabric, Power Platform, and related certifications.
• Five years’ experience in reporting, analytics, or BI role.

Responsibilities

• Identify data sources in data warehouse or databases.
• Create, test, and maintain data models for solutions.
• Develop enterprise reports and dashboards.
• Document technical guidance for team and end-users.

Skills

BI analytics

Data analysis

Stakeholder communication

Education

Diploma in Information Technology or Business

Microsoft Fabric training (100+ hours)

Power Platform training (100+ hours)

Microsoft Certified Professional

Microsoft BI Designation

Tools

Power Platform

Microsoft Fabric

Microsoft BI

BI Certification Tracks

Job description

Department:

Academic Operations and Planning

Position Type:

Full-Time Support

Salary Range:

$41.20-$47.57-Hourly

Sc** heduled Weekly Hours:

36.25

Anticipated Start Date:

September 14, 2026

Length of Contract:

n/a

Posting Information

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

Posting Closing Date:

September 8, 2026

Please note: jobs are posted until 11:59 pm on the job closing date.

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.

Job Description:

*Note: this is a reposted position, previous applicants are not required to reapply.

The incumbent will be responsible for the preparation, analysis, interpretation and distribution of institutional information using a variety of business intelligence and database tools, as part of ad-hoc requests or projects.
This position is essential in ensuring the accuracy, completeness and reliability of institutional information to both internal and external stakeholders. The incumbent will be responsible for the construction of a variety of metadata models and reports, ensuring that they adhere to the appropriate controls. As part of the role, the incumbent may be required to meet with internal clients to provide guidance relating to business intelligence tools or establish requirements for upcoming data requests.
As a BI, Reporting and Analytics developer, the incumbent will possess a deep understanding of the Business Intelligence tools and techniques used by the college

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;

* This position is paid at Payband I

* Vacancy is for P23359

Why Join Algonquin College?

• 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. Benefits | Careers
• 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. About Us | Employee Learning and Development. Availability depends on role and employment status.
• 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 (subject to change).

How 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.