Report Specialist
Job in
Waterloo, Kitchener, Ontario, Canada
Listing for:
Wilfrid Laurier University
Full Time
position
Listed on 2025-12-30
Job specializations:
-
IT/Tech
Data Analyst, Database Administrator, Data Engineer
Job Description & How to Apply Below
Location: WaterlooPosition Summary
The Office for Institutional Research & Planning at Laurier provides information, analysis, evidence and insight in support of the University’s overarching mission and goals.
The incumbent will work with colleagues in the Institutional Research & Planning Office to interpret and deliver the university’s data requirements. They will work with the University’s Banner Relational Database, using SQL, Cognos Analytics, Microsoft BI and other similar reporting tools to extract and organize data that delivers these requirements.
This position has a university-wide mandate and will be based at the Waterloo campus.
Accountabilities
The individual in this position will be responsible for:
Report DevelopmentBuild new reports, dashboards and queries in Cognos.For each report, responsibilities will include Design, development and customization of each report utilizing creative solutions and best practice approaches including visuals, interactivity and reusable/flexible reporting options Extensive testing of each report with individuals who will access the reports to ensure it meets their needs Extracting, compiling and calculating data from a single or a range of data source(s).Proactively communicate and collaborate with individuals who will access the reports to review data/reporting needs and functional requirements to explore report options and optimal report development. Sometimes needs will be clear regarding what type of report and calculations will be needed but particularly for new reports, the requests may require extensive conversations before, during and after development of each report.Test and analyze data to provide reports to a wide variety ofindividuals and departments.Maintain accuracy of data and troubleshoot any discrepancies in reports.Build familiarity with the structure of Banner (our relational database management system).Cognos Analytics Administrator Back-Up
Serve as a secondary point of contact for support and issue resolution for Cognos Analytics in production.Monitor, analyze, troubleshoot and /or tune Cognos Analytics hardware and software performance or deployment issues when required, in production.Understand and possibly adjust design and development specifications, metadata and documentation.Oversee and manage security access rights to Cognos reports, dashboards and queries.Build and adjust data models as needed.Work collaboratively with team members in Institutional Research & Planning and other teams to develop the models to meet the analytic needs of various units in Laurier.Provide training to users as needed.Any additional tasks as needed related to Cognos report, dashboard and query development or administration.Other
Posting/publishing reports on internal webpagesQualifications
Education:
Degree in Computer Science or equivalent.Technical Skills
Knowledge of relational database management systems, preferably Oracle based and/or MS SQL;Experience with Banner or other higher education ERP software packages;Expertise in designing, maintaining and sharing data reports, cubes and dashboards in Cognos Analytics 11 or 12Expertise in creating models using Cognos Framework Manager;Experience writing SQL queries to validate reports, researching data in tables and generating SQL reports in instances where Cognos is inappropriate;Strong Excel skills and strong working knowledge of Microsoft Windows environment.Other Experience
3 years of relevant work experience;Excellent interpersonal, verbal and written communication skills;Experience working with individuals to design and develop correct and well-performing Cognos reports, dashboards and queries in a timely and easy to use manner;Ability to troubleshoot query issues during report development using a methodical approach;Ability to translate business requirements into a data model in order to communicate with others for the creation of reports;Good understanding of the technical architecture and functionality of a data warehouse, data marts, operational data stores and various data models;Ability to work in a multi-disciplinary team environment.This position has been deemed eligible for educational equivalencies.
Hours…
Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
Search for further Jobs Here:
