Business Intelligence Architect and Developer

About the role

At the University of Waterloo, we create and promote a culture where everyone can reach their full potential. As an employee, you get support & opportunities that empower you to advance your career. Explore how we can bring big ideas to life, together. The University is a welcoming workplace for those of all abilities, interests, and expertise. As part of our workforce, you can do what you do best, every day. Learn more about our recruitment process. Job Requisition ID: 2026-00319 Time Type: Full time Employee Group: Staff Job Category: Analytics and Reporting Employment Type: Permanent Department: Institutional Analysis and Planning - Data Analytics and Reporting Hiring Range: $93,117.25 - $116,396.56 Posting Information: This posting is for an existing vacancy. The internal posting deadline for this position is Thursday, March 19, 2026, at 11:59PM. Job Description: Primary Purpose Under the direction and guidance of IAP leadership and in alignment with standards and best practices the Business Intelligence Architect and Developer is responsible for the design, development and maintenance of data warehouses, data marts, databases, data dictionaries, data transformations, user interfaces, systems interfaces, analytical models, and related processes used for data-driven decision-making by IAP, its partners and clients. The Business Intelligence Architect and Developer will proactively contribute to IAP's mandate of providing data, advice, analytical and planning support to the Senior Leadership of the university to inform policy development, strategic planning, decision-making and priority-setting. Key Accountabilities Institutional data - Abstracts and organizes institutional data from Waterloo's enterprise resource planning (ERP) and departmental systems to create and maintain business objects for institutional reporting and analysis. - Abstracts and organizes semi-structured institutional data from employee and student surveys to create and maintain business objects for institutional reporting and analysis. - Leads the creation and maintenance of institutional data stores as "single sources of truth" for varied reporting and analytics functions, including government reporting, Key Performance Indicators (KPIs), research projects, forecasting, scenario modelling, statistical analyses, machine learning and AI projects. - Synthesizes data from multiple sources for reporting and analysis. Supports the Data as a Strategic Resource (DSR) program by technology adoption, business process reengineering, and personnel development. - Collaborates with Information Systems and Technology to inform technology choices and best practices for data architecture, including software procurement, information management, risk management, retention schedules, cloud and on-premises infrastructure. - Consults with Legal and Immigration Services to inform best practices for data handling, information management, and information risk and privacy. - Engages with departmental subject matter experts to build knowledge of the core data elements in those systems and the business processes that generated those data elements. Information Technology Architecture - Designs, implements and maintains data warehouses for storage of "snapshot" data from ERPs, IST Data Lake and other data sources, internal and external to the institution. - Designs and implements dimensional models including star schemas, snowflake schemas, and conformed dimensions across multiple subject areas, for analytics solutioning. - Defines appropriate grain for fact tables and designs multi-fact schema architectures. - Creates and maintains logical and physical data models that balance query performance with storage efficiency. - Designs, develops, and implements data systems/solutions that meet defined business requirements for data pipelines (e.g., Electronic File Transfers, APIs, data flows, datasets, xml, text files) . - Makes use of multiple operating systems (e.g., Linux, Unix, Windows), cloud and on-premises infrastructure and services (e.g., SaaS, IaaS, PaaS) and scripting/coding languages managed by IST to deliver data systems/solutions. - Designs, develops, and implements data systems/solutions that improve user interfaces, usability and enable user adoption. - Ensures data and information is placed into the proper context by combining university data with both qualitative and quantitative environmental/external data and appropriate narrative. - Serves on University, and as appropriate, non-University committees and groups, offering data and analytical expertise and fostering data information sharing and collaborative approaches on a variety of projects. - Collaborates with data analysts across campus to help create a data culture in support of institutional goals. - Liaises with other departments campus-wide in providing technical support and guidance (e.g., IST). Facilitates training/education where required. Data Processing and Engineering - Designs, d

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at uwaterloo? Share your experience