University of Waterloo

Institutional Analyst

Requisition ID 2021-6758
Job Category
Institutional Analysis
Employment Type
Time Type
Hiring Range
$57,962 - $78,883


Under the direction and guidance of IAP leadership, the Institutional Analyst (IA) is responsible for the development of databases, models, analyses, and reporting as well as communicating the results of analyses internal and external to IAP. The IA 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.


Institutional data analysis and reporting

  • Develops and prepares analytical models, reports and relevant data visualizations (including dashboards, graphs, presentations and web applications) to inform evidence-based decision-making at the University

  • Supports indicator development and ongoing reporting for Waterloo operational and strategic measures

  • Analyzes trends and patterns in university performance over time using various benchmarks and comparative data

  • Prepares annual and customized reports and presentations for senior leadership and university governance bodies, including monitoring student enrolment, retention and graduation rates, student survey outcomes, etc.

  • Prepares standard and customized reports and accountability submissions for the Ministry of Advanced Education & Skills Development (MAESD), Council of Ontario Universities (COU), U15 Data Exchange and other consortia, university rankings agencies, Statistics Canada

  • Uses external data from a variety of sources including Statistics Canada, in combination with institutional data to prepare analysis and reports that address research questions

Institutional data management

  • Ensures that institutional data is accurate, consistent, properly maintained and shared in compliance with relevant privacy protection, confidentiality and other ethical principles

  • Identifies and addresses data integrity/reliability issues and uses data cleaning processes to achieve required data quality standards

  • Works with large data sets to perform data mining and complete statistical analyses

  • Transforms, synthesizes, and cleanses data: identifies opportunities to reduce duplication and errors and to ensure consistency in data; identifies data integrity issues and proposes data cleansing processes to develop clear and consistent data quality standards

  • Designs and develops user interfaces for accountability reporting using web applications and best practices in data visualization, for example, scorecard and dashboard reporting

  • Helps lead the adoption and standardization of new data analysis tools and techniques, in partnership with stakeholders across campus


  • Develops accurate graphs, reports, dashboards and presentations to convey complex information in an understandable and compelling manner

  • Creates business/analytical models and related user interfaces that allow stakeholders to self-serve and explore planning parameters

  • 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

  • Communicates with technical and non-technical users to gather data and data system requirements, reporting requirements, consolidate and document technical data requirements, transform data into visualizations, and assist with project planning

  • Ensures timely communication to University leadership, managers, campus support units, Faculties, departments, research groups, appropriate staff through appropriate media, of developments and projects; also communicates on any related events that have the potential to directly or indirectly impact normal services

  • 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

  • Liaises with other departments campus-wide in providing technical support and guidance (e.g., IST)

Student supervision

  • Assists with coaching, training and co-op student development to assure student growth and development

  • Provides input into regular performance reviews with direct report(s), and supports achievement of performance goals

  • Assists with making decisions on the hiring of the incumbent's direct report(s), in consultation with the Managers, Institutional Analysis and Planning

Institutional Analysts may specialize in one of the following areas of work within the IAP office

  • Budget and Resource Planning
    • Budget modelling: develops, maintains, and refines institutional resource allocation models and associated business processes. Works with other stakeholders to prepare the annual institutional budget
    • Financial viability analyses: develops financial viability models and prepares associated analyses in support of overall academic program approval processes
  • Policy and Enrolment Planning
    • Policy analysis: evaluation of government policy objectives, directions, and developments in order to assess the potential impacts of policy changes (e.g. tuition frameworks, strategic mandate agreements, and government funding formula changes). Support to the development and revision of internal policies stemming from government directives and requirements
    • Enrolment planning: Support to enrolment planning and forecasting initiatives in relation to both short and long range planning efforts, revenue projections, and resource allocation decisions.  Support to the broader program approval processes, including MAESD approval processes for new academic programs


  • Bachelors degree in Statistics, Economics, Computer Science, Social Science Research, or a combination of equivalent experience and education
  • 3+ years of demonstrated experience with mathematical, statistical and analytical methods, such as regression analysis and significance testing working with large and complex data sets

  • 2+ years of project management experience

  • Superior data management, manipulation, interpretation and analysis skills

  • Excellent written and verbal skills for procedural documentation and demonstrated experience with report writing

  • Ability to work independently and as part of a team

  • Ability to manage large workloads and prioritize competing deadlines

  • Taking initiative and be proactive

  • Working knowledge of a variety of reporting and data visualization tools, such as Tableau or Power BI

  • Knowledge of Sharepoint and other web development applications

  • Ability to use MS SQL Service (SSIS,SSRS and SSAS) is an asset

  • Knowledge of SPSS,SAS, Python, R or other statistical analysis or data transformation tools

  • Ability to apply, identify and use a combination of quantitative and qualitative research methods

Equity Statement

The University of Waterloo is committed to implementing the Calls to Action framed by the Truth and Reconciliation Commission. We acknowledge that we live and work on the traditional territory of the Neutral, Anishinaabeg and Haudenosaunee peoples. The University of Waterloo is situated on the Haldimand Tract, the land granted to the Six Nations that includes six miles on each side of the Grand River.


The University values the diverse and intersectional identities of its students, faculty, and staff. The University regards equity and diversity as an integral part of academic excellence and is committed to accessibility for all employees. The University of Waterloo seeks applicants who embrace our values of equity, anti-racism and inclusion.  As such, we encourage applications from candidates who have been historically disadvantaged and marginalized, including applicants who identify as First Nations, Métis and/or Inuit/Inuk, Black, racialized, a person with a disability, women and/or 2SLGBTQ+.


All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.


The University of Waterloo is committed to accessibility for persons with disabilities. If you have any application, interview, or workplace accommodation requests, please contact Human Resources at or 519-888-4567, ext. 45935.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed