Cognos Report Specialist - Waterloo, Canada - Wilfrid Laurier University
Description
Date:
Apr 8, 2024
Location:
Waterloo, CA
Company:
Wilfrid Laurier University
Department:
Institutional Research
Job Type:
Continuing
Full-time/Part-time: Full Time (>=1249 hrs/year)
Campus:
Waterloo
Reports to:
Reporting Manager, Institutional Research and Planning
Employee Group:
WLUSA
Application Deadline:05/10/2024
Requisition ID:6910
Wilfrid Laurier University is a leading multi-campus university that excels at educating with purpose.
Through its exceptional employees, students, researchers, leaders, and educators, Laurier has built a reputation as a world-class institution known for its rich student experience, academic excellence, and global impact.
With a commitment to Indigenization and commitment to equity, diversity, inclusion, Laurier's thriving community has a place for everyone.
Laurier has more than 19,000 students and 2,100 faculty and staff across campuses in Waterloo and Brantford, as well locations in Kitchener and Milton.
The university is committed to providing an inclusive workplace, a flexible work policy and employing a workforce that is reflective of local and national demographics.
Our locations are situated on the traditional territories of the Neutral, Anishnawbe, and Haudenosaunee peoples.We recognize the unique heritages of Indigenous peoples and support their intentions to preserve and express their distinctive Indigenous cultures, histories, and knowledge through academic programming and co-curricular activities.
Laurier's Centre for Indigegogy is one example of how Laurier honours Indigenous knowledge.Position 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 Development
- Build 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).
- Serve as a secondary point of contact for support and issue resolution for CognosAnalytics 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.
- Posting/publishing reports on internal webpages
Qualifications:
Education:
- Degree in Computer Science or equivalent.
Technical Skills
- Experience with building Dashboards and Reports using Power BI
- 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 1
- Expertise in creating models using Cognos Framework Manager;
- Experience writing SQL queries to val
More jobs from Wilfrid Laurier University
-
PS410 BR: History of Psychology
Brantford, Canada - 3 days ago
-
Special Constable
Waterloo, Canada - 4 days ago
-
Student Support and Admissions Assistant
Waterloo, Canada - 4 days ago
-
DMJN332BR - Photography and Digital Imaging II (Winter 2025)
Brantford, Canada - 1 week ago
-
SY419A, Migration, Globalization
Waterloo, Canada - 2 days ago
-
HR/LY323 BR
Brantford, Canada - 1 week ago