Full-time Business Intelligence Analyst

Algonquin College•Ottawa, ON

2d•CA$40 - CA$47•Hybrid

About The Position

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.

Requirements

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

Responsibilities

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
Institutional metric analysis (enrolment, retention and student satisfaction etc.)
Financial analysis (program costing and overhead analysis)
Provide guidance, support on BI matters (e.g. end user self-service best practices and enterprise report troubleshooting)
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