- Employer
- Trent University
- Location
- Peterborough, Ontario (Hybrid)
- Salary
- $75,379 - $100,505 per annum i.e. $2,899.19 - $3,8
- Ref
- X-484
- Starts
- Closes
- Job Category
- Finance, Budget and Audit
- Job Type
- Permanent
Trent University is actively committed to creating a diverse and inclusive campus community and encourages applications from all qualified candidates. Trent University offers accommodation for applicants with disabilities in its recruitment processes. If you require accommodation during the recruitment process or require an accessible version of a document/publication, please contact Human Resources.
Job Purpose:
Reporting to the Director of Reporting Systems and Analytics, the Business Intelligence (BI) Developer transforms data into user-friendly, actionable information by developing analytics and business intelligence systems, reporting, dashboards, and metrics. These tools support evidence-based decision-making at all levels of the University. The BI Developer will engage in the collection, analysis, interpretation, and dissemination of institutional and market data for operational decision-making, assessment, and reporting. The BI Developer is also responsible for ensuring that all data processes adhere to the University’s data governance framework, maintaining high standards of data quality, security, and compliance.
As a key member of the Office of Institutional Planning and Analysis (OIPA), the University’s central hub for institutional data, the BI Developer plays a crucial role in supporting the University's data governance initiatives while working closely under the guidance of the Director. The BI Developer will seek decision-making, guidance, and escalate issues to the Director when necessary, ensuring a collaborative approach to maintaining the integrity and effectiveness of data processes.
Key Activities:
Business Intelligence (BI) Developer
- 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:
Honours University Degree (4 years) in a related Computer Science discipline.
Experience/Qualifications Required:
- Minimum of five (5) years of working 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.
- Demonstrated proficiency in T-SQL, DAX, Python or R, and experience applying machine learning techniques and tools for data analysis and predictive modelling.
- Minimum of three (3) years of experience working with student information systems in a post-secondary environment (preferably Datatel).
- Strong analytical problem-solving skills and a thorough 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 minimal supervision.
- Ability to maintain confidentiality.
- Experience managing multiple tasks within a rapidly changing environment, with demonstrated time and resource management skills to complete projects.