Full-time Business Intelligence Analyst

Please Note: If you are a current Algonquin College employee apply to this job via the Workday application.

Department:

Position Type:

Salary Range:

Scheduled Weekly Hours:

Anticipated Start Date:

Length of Contract:

Posting Information

Posting Closing Date:

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:

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 clients 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

This position is subject to the terms of the Full-Time Support Staff Collective Agreement: 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 Canadas Best Employers for 2025 and one of Canadas 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 Colleges 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 . While we thank all those who apply only those to be interviewed will be contacted.