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
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)
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
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
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 firstname.lastname@example.org or 519-888-4567, ext. 45935.