Cognos Report Developer II

Job Information
Author pmnationtalk
Date September 26, 2019
Type Full Time
Company Wilfrid Laurier University
Salary $34.17 - $40.22 - Per Hour
Location Waterloo, ON
Category Research / Development
Client Wilfrid Laurier University
Contact Information
Apply Now!

Cognos Report Developer II

Posting ID : 11261
Apply By : 10/6/2019
Position Title : Cognos Report Developer II
Department : Institutional Research and Planning
Job Type : Full-time, Continuing
Campus : Waterloo
Reports To : Reporting Manager
Position Summary :

Wilfrid Laurier University is a leading multi-campus, university known for academic excellence and a culture that inspires lives of leadership and purpose. Laurier has a distinct commitment to teaching, research, experiential learning, sustainability and scholarship, which combine to address critical challenges in society, business, the economy and the environment – globally and in the communities we serve. At Laurier’s heart is its strong student focus, which results in exceptional levels of student satisfaction and a deep sense of community that lives on through the university’s highly engaged alumni.

Laurier takes pride in building meaningful relationships with colleagues and students. The Laurier community supports one another, encourages collaboration and teamwork and respects work/life balance, all while recognizing the importance of a challenging, rewarding and inspiring career. Laurier has more than 19,000 students and 2,100 faculty and staff across campuses in Waterloo and Brantford, as well as locations in Kitchener and Toronto.

Diversity is one of Laurier’s core values. The university is committed to providing an inclusive workplace 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.

We currently have an opportunity to join the Laurier community as a Cognos Report Developer II.
The Office for Institutional Research and 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 and Planning Office to interpret and deliver the university’s data requirements.   They will work with the University’s Banner Relational Database, using Cognos BI tools, SQL 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. The normal hours of work are 8:30 am to 4:30 pm, Monday to Friday.  Flexibility in hours will be required occasionally, including evening and/or weekend work due to the need to meet demand during peak periods or to perform work on the system during off hours.  When possible, the manager will adjust the work schedule so that no more than 35 hours are worked in a week.

Accountabilities :

The individual in this position will be responsible for:

Report Development

    • Build new reports and dashboards for end users in Cognos. Rewrite and transition reports and dashboards made in other formats (Cognos 7 or 10, SQL, etc) to Cognos (11) Analytics. Some reports will require redesign, refinement and/or enhancement; other reports may be transitioned as is.
    • 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 end users to ensure it meets end user needs
    • Extracting, compiling and calculating data from a single or a range of data source(s).
    • Proactively communicate and collaborate with end users 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 of end users.
    • Maintain accuracy of data and troubleshoot any discrepancies in reports.
    • Build familiarity with the structure of Banner (our relational database management system).

Cognos Business Intelligence Administrator Back-Up

    • Serve as a secondary point of contact for support and issue resolution for Cognos BI during implementation and in production.
    • Monitor, analyze, troubleshoot and /or tune Cognos BI hardware and software performance or deployment issues when required, both during implementation and in production.
    • Understand and possibly adjust design and development specifications, metadata and documentation.
    • Oversee and manage security access rights to Cognos reports.
    • Build and adjust Business Intelligence models as needed.
    • Work collaboratively with team members in Institutional Research and Planning and other teams to develop the Business Intelligence model 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 development or BI administration.
Qualifications : 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 10 or 11;
    • Expertise 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 BI is inappropriate;
    • Strong Excel skills and strong working knowledge of Microsoft Windows environment.

Other Experience

    • 3-5 years of relevant work experience;
    • Experience working with end users to design and develop correct and well-performing Cognos reports and dashboards in a timely and user-friendly 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 the reports;
    • Good understanding of the technical architecture and functionality of a data warehouse, data marts, operational data stores and various data models;
    • Excellent interpersonal, verbal and written communication skills;
    • Ability to work in a multi-disciplinary team environment.
Grade : WLUSA-08
Salary : $34.17 – $40.22
Salary Notes : This is a full-time, continuing position. The anticipated start date for this position is October 15, 2019. This position is eligible for educational equivalencies:
Please Note :

This position is represented by the WLU Staff Association bargaining unit

Please submit a cover letter and resume.

Wilfrid Laurier University endeavors to fill positions with qualified candidates who have a combination of education, experience, skills and abilities to successfully perform the duties of the position while demonstrating Laurier’s Employee Success Factors.

Diversity and creating a culture of inclusion is a key pillar of Wilfrid Laurier University’s Strategic Academic Plan and is one of Laurier’s core values. Laurier is committed to increasing the diversity of faculty and staff and welcomes applications from candidates who identify as Indigenous, racialized, having disabilities, and from persons of any sexual identities and gender identities. Indigenous candidates who would like to learn more about equity and inclusive programing at Laurier are welcomed to contact the Office of Indigenous Initiatives at Candidates from other equity seeking groups who would like to learn more about equity and inclusive programing at Laurier are welcomed to contact Equity and Accessibility at We have strived to make our application process accessible however if you require any assistance applying for a position or would like this job posting in an alternative format, please contact Human Resources at 519-884-1970 ext.2007 or

Send To Friend Email Print Story

NationTalk Partners & Sponsors Learn More