linkedin
Full-time Business Intelligence Analyst
Algonquin College of Applied Arts and Technology
Ottawa, CAN
Full Time
Mid
Hybrid
1 weeks ago
Business IntelligenceData ModelingMicrosoft FabricPower PlatformMicrosoft Certified ProfessionalMicrosoft BI Designation
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
Business IntelligenceData ModelingMicrosoft Fabric
About the Role
Algonquin College is hiring a Business Intelligence Analyst to prepare, analyze, and distribute institutional information using BI tools. The role involves creating data models, reports, and dashboards, and providing guidance to internal clients.
Key Skills for This Role
Business IntelligenceData ModelingMicrosoft FabricPower PlatformMicrosoft Certified ProfessionalMicrosoft BI Designation
Responsibilities
- Identify appropriate data sources within the data warehouse or other databases
- Create, test and maintain data models to support the required solutions
- Create, test and maintain enterprise level reports and dashboards
- Produce and maintain technical documentation for team members and end users
- Perform institutional metric analysis (enrolment, retention and student satisfaction etc.)
- Perform financial analysis (program costing and overhead analysis)
- Meet with internal clients to provide guidance, support on BI matters
- Determine future reporting needs and establish requirements for new data requests
- Research and stay current with relevant practices, products, technology, programs and tools
Requirements
- 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
Full Job Posting
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.
Duties And 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
- Research and stay current with relevant practices, products, technology, programs and tools
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
Why Join Algonquin College?
- Compensation: Many roles offer a competitive base salary and comprehensive benefits, including health, dental, and retirement plans
- Learning and Development Opportunities: Access to training, tuition assistance programs, certifications, workshops, and professional courses
- Company Culture: Values of caring, learning, integrity, and respect
- Inclusion, Diversity, Equity, and Accessibility (IDEA): First Ontario college to implement an Equity, Diversity, and Inclusion policy
- Flexible Work Arrangement Policy: Select positions are eligible for hybrid work
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career