Cognos Report Specialist

2 weeks ago

Waterloo, Canada Wilfrid Laurier University Full time

**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).

Cognos Analytics Administrator Back-Up
- 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.

Other
- 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 12
- Expertise in creating models using Cognos Framework Manager;
- Experience writing SQL queries to val

  • Reporting and Analytics Specialist

    5 days ago

    Waterloo, Canada CarePartners Full time

    Who We Are: CarePartners is one of Ontario’s largest accredited home health care providers, providing nursing, personal support, therapy and rehabilitation support services for patients of all ages. We care for approximately 72,000 patients each year in homes, schools, clinics, workplaces and retirement homes, through our 24 locations and 22 nursing...

  • Reporting and Analytics Specialist

    2 days ago

    Waterloo, Canada CarePartners Full time

    Who We Are CarePartners is one of Ontario’s largest accredited home health care providers, providing nursing, personal support, therapy and rehabilitation support services for patients of all ages. We care for approximately 72,000 patients each year in homes, schools, clinics, workplaces and retirement homes, through our 24 locations and 22 nursing...

  • Reporting and Analytics Specialist

    2 days ago

    Waterloo, Canada CarePartners Full time

    Who We Are CarePartners is one of Ontario’s largest accredited home health care providers, providing nursing, personal support, therapy and rehabilitation support services for patients of all ages. We care for approximately 72,000 patients each year in homes, schools, clinics, workplaces and retirement homes, through our 24 locations and 22 nursing...

  • Data & Reporting Specialist New

    2 weeks ago

    Waterloo, Canada Definity Financial Corporation Full time

    Job ID : 7395 Category : Human Resources Brand : Definity Regular/Temporary : Regular Fulltime/Parttime : Full Time Location : Waterloo, Canada Posting Range : $55,800 - $102,800 Definity is the parent company to some of Canada’s most long-standing and innovative insurance brands, including Economical Insurance, Sonnet Insurance, Family Insurance...

  • Incident Reporting Centre Specialist

    2 weeks ago

    Waterloo, Canada Sun Life Full time

    You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll...

  • Specialist, Site Performance

    1 week ago

    Waterloo, Canada Sun Life Full time

    You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll...

  • Reporting Specialist

    7 days ago

    Waterloo, Canada Prime Hires Full time

    Our client is a top financial institution with significant North American holdings. They have operations across most major verticals, including institutional & corporate, wealth management, private client, commercial banking, treasury, and retail banking.Key Responsibilities:Perform data gathering and entry tasks accurately and timely according to team...

  • Reporting Specialist

    6 days ago

    Waterloo, Canada Prime Hires Full time

    Our client is a top financial institution with significant North American holdings. They have operations across most major verticals, including institutional & corporate, wealth management, private client, commercial banking, treasury, and retail banking. Key Responsibilities: Perform data gathering and entry tasks accurately and timely according to team...

  • Reporting Specialist

    6 days ago

    Waterloo, Canada Prime Hires Full time

    Our client is a top financial institution with significant North American holdings. They have operations across most major verticals, including institutional & corporate, wealth management, private client, commercial banking, treasury, and retail banking.Key Responsibilities:Perform data gathering and entry tasks accurately and timely according to team...

  • Reporting Specialist

    6 days ago

    Waterloo, Canada Prime Hires Full time

    Our client is a top financial institution with significant North American holdings. They have operations across most major verticals, including institutional & corporate, wealth management, private client, commercial banking, treasury, and retail banking. Key Responsibilities: Perform data gatherin

  • Reporting Specialist

    7 days ago

    Waterloo, Ontario, Ontario, Canada Prime Hires Full time

    Our client is a top financial institution with significant North American holdings. They have operations across most major verticals, including institutional & corporate, wealth management, private client, commercial banking, treasury, and retail banking.Key Responsibilities:Perform data gathering and entry tasks accurately and timely according to team...

  • Manager, External Reporting and Capital Management

    1 day ago

    Waterloo, Canada Manulife Full time

    We are a leading financial services provider committed to making decisions easier and lives better for our customers and colleagues around the world. From our environmental initiatives to our community investments, we lead with values throughout our business. To help us stand out, we help you step up, because when colleagues are healthy, respected and...

  • Procurement Specialist

    2 months ago

    Waterloo, Canada Home and Community Care Support Services Full time

    **Job Description**: **POSITION TITLE**: Procurement Specialist *** **REPORTS TO**: Director, Corporate Procurement & Contracts **POSITION STATUS**: Permanent, Full-Time **DIVISION / DEPARTMENT**: Procurement **LOCATION**:Waterloo Wellington (WW) Region or Hamilton Niagara Haldimand Brant (HNHB) Region **COMPETITION NUMBER**:23-A-005 **POSTING...

  • Communications Specialist

    3 weeks ago

    Waterloo, Canada MEDA Full time

    **Position Summary** Reporting to the Director, Corporate and Creative Communications, the Communications Specialist will support MEDA’s external communication strategy by writing and co-creating content for digital channels, positioning MEDA as a leader in economic development in the areas of agri-food market systems and impact investment in countries in...

  • Marketing Specialist

    2 months ago

    Waterloo, Canada University of Waterloo Full time

    Overview: The Marketing Specialist is responsible for the research, development, coordination and promotion of marketing efforts for a defined area within the Waterloo Undergraduate Student Association (WUSA). The incumbent is responsible for developing, implementing and monitoring strategic marketing initiatives designed to maximize awareness of their...

  • HRis Specialist

    2 weeks ago

    Waterloo, Canada Karis Disability Services Full time

    **Permanent, Full Time** **HRIS (UKG/Kronos) Specialist** **40 hours/week** **Waterloo Office** The Human Resources Information System Specialist supports Karis Disability Services with a functional Human Resources Information System (HRIS), providing expertise and training regarding data entry, problem-solving, and policies and procedures. They provide...

  • Equity Specialist

    2 months ago

    Waterloo, Canada University of Waterloo Full time

    Overview: **Term: 1 year.** Reporting to the Director of Equity, the Equity Specialist is a member of the Equity Office responsible for planning, implementing and monitoring equity initiatives. The Specialist provides campus members support and guidance on navigating University procedures. The Specialist manages initiatives in line with the Office of...

  • Equity Specialist

    2 days ago

    Waterloo, Canada University of Waterloo Full time

    Overview: **Term: 1 year** Reporting to the Director of Equity, the Equity Specialist is a member of the Equity Office responsible for planning, implementing and monitoring equity initiatives. The Specialist provides campus members support and guidance on navigating University procedures. The Specialist manages initiatives in line with the Office of Equity,...

  • Information Specialist

    2 months ago

    Waterloo, Canada Wilfrid Laurier University Full time

    **Date**:Jan 16, 2023 **Location**: Waterloo, CA **Company**:Wilfrid Laurier University **Department**: Enrolment Services **Job Type**: Continuing **Full-time/Part-time**: Full Time (>=1249 hrs/year) **Campus**: Waterloo **Reports to**:Assitant Registrar-Registrar Services **Employee Group**: WLUSA **Application Deadline**:January 29,...

  • Business Analyst Intern

    1 month ago

    Waterloo, Canada Robertson & Company Ltd. Full time

    Business Analyst Intern Duration: 4 months FULL TIME internship Hybrid work schedule (Tuesday, Wednesday, and Thursday onsite) Flexible Working hours (8:00 am - 4:00 pm EST, 9:00 am - 5:00 pm EST) Preferable students enrolled in the following programs: Mathematics, Computer Science, Business Analytics, Commerce, Business Management, Dual Program Math and...