Business Intelligence

**Job Purpose**

Reporting to the Director of Reporting Systems and Analytics, the Business Intelligence (BI) Analyst plays a hands-on role in developing dashboards, reports, and data models that transform raw data into actionable insights for strategic and operational planning at the University. The BI Analyst collaborates with teams across the institution to enhance reporting capabilities, improve data accessibility, and ensure high-quality data governance. They design and implement business intelligence solutions, troubleshoot data issues, and contribute fresh ideas to improve how data is collected, analyzed, and presented.

By integrating and analyzing institutional and market data, the BI Analyst provides actionable insights to support initiatives such as enrollment forecasting, financial planning, academic program assessment, and strategic policy development ensuring that accurate, accessible, and high-quality data informs key decisions across the University.

**Key Activities**:
**Business Intelligence (BI) Analyst**
- BI System Development: Designs, develops, implements, and maintains BI streams and pathways, such as dashboards, reports, and analytics that address issues, requests, and University requirements.
- Security and Access Management: Responds to access and security requests for dashboards and reports hosted on the enterprise reporting website.

**Database Administration**
- Reporting Infrastructure Maintenance: Supports and maintains the reporting infrastructure of the Office of Institutional Planning and Analysis, including MS-SQL databases, data warehouses, and cubes.
- Data Issue Resolution: Collaborates with university-wide colleagues to resolve data issues and analyzes their potential impact on institutional reporting.
- Data Management: Maintains OIPA’s data dictionaries, manages data extraction/manipulation, and diagnoses and resolves data integrity issues.

**Institutional Reporting and Analysis**
- Collaborative Projects: Collaborates with various University departments and committees on data analysis projects such as Cyclical Program Reviews, Responsibility Centered Management (RCM), and Finance for budget purposes.
- Data Handling: Accesses and manipulates large, diverse electronic data sets for analysis, interpretation, report creation, and responds to a broad range of information requests within the organization.
- Professional Reporting: Prepares accurate, professional reports to communicate information to users at all levels of the organization.
- End-User Reporting: Works with University colleagues to evaluate and enhance end-user reporting capabilities.
- Data Quality Assurance: Assists data analysts in other departments to ensure the integrity and quality (accuracy, relevance, reliability, consistency, completeness, timeliness) of institutional information used for decision-making across the University, in line with data governance policies.

**Education Required**:

- A university degree in Computer Science or a related field or equivalent experience in business intelligence, data analytics, or a related discipline.

**Experience/Qualifications Required**:

- Four (4) years of experience with Microsoft reporting infrastructure including Management Studio (SSMS), Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), Power Platform (Power BI), and cloud technologies such as Azure and Fabric.
- Experience with student information systems in a post-secondary environment (preferably Datatel Colleague) preferred.
- Strong analytical problem-solving skills and an understanding of relational database design and function.
- Demonstrated ability to use various thinking skills to anticipate and solve problems.
- Clear, concise, and correct communication in written, spoken, and visual forms that meet the audience's needs.
- Ability to work as part of a team and foster good working relationships with internal and external stakeholders.
- Initiative and ability to work independently with mínimal supervision.
- Ability to maintain confidentiality.
- Experience managing multiple tasks within a rapidly changing environment, with demonstrated time and resource management skills to complete projects.

**Job Types**: Full-time, Permanent

Pay: $75,379.00-$83,753.00 per year

Schedule:

- Monday to Friday

Work Location: Hybrid remote in Peterborough, ON

Application deadline: 2025-03-19