Jobs
>
Kitchener

    Cognos Report Specialist - Waterloo, Canada - Wilfrid Laurier University

    Wilfrid Laurier University
    Wilfrid Laurier University Waterloo, Canada

    3 weeks ago

    Default job background
    Description
    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 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. Please refer to the attached for details.

    Hours of Work: This is a full time continuing position. The normal hours of work are 8:30 am to 4:30 pm, Monday to Friday. Flexibility in hours will be required, including evening and/or weekend work due to periods of high volume. When possible, the manager will adjust the work schedule so that no more than 35 hours are worked in a week.

    Compensation:

    Position Grade: E

    Rate of pay: $ $42.17 with an annual step progression on anniversary date up to $45.59

    Considerations for new hire step placements include, qualifications and length/depth of required experience, relevant market rates for similar jobs, internal equity, and estimated learning curve in starting the job.

    Job Evaluation Factor Scores

    WLUSA/WLU Job Evaluation Factors

    Score

    Education

    4

    Experience 3

    Interpersonal Skills

    3.5

    Applied Reasoning and

    Analytical Skills

    5

    Co-ordination and Planning

    3

    Accountability for Others

    1

    Impact of Decisions

    3

    Mental Effort

    4

    Level of Physical Effort

    3

    Working Environment

    1

    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.

    Equity, diversity and creating a culture of inclusion are part of Laurier's core values and central to the Laurier Strategy. 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 minority sexual 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. Candidates from other equity deserving groups who would like to learn more about equity and inclusive programing at Laurier are welcomed to contact Equity & Accessibility. 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. Contact information can be found at

    Should you be interested in learning more about this opportunity, please visit for additional information and the online application system. All applications must be submitted online. Please note, a resume and cover letter will be required in electronic form.

  • Wilfrid Laurier University

    Cognos Report Specialist

    2 weeks ago

    Wilfrid Laurier University Waterloo, Canada

    **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, Institu ...

  • Sun Life

    Incident Reporting Centre Specialist

    2 weeks ago

    Sun Life Waterloo, Canada

    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 inspir ...

  • Definity Financial Corporation

    Data & Reporting Specialist New

    2 weeks ago

    Definity Financial Corporation Waterloo, Canada

    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 in ...

  • Communitech Technology Association

    Reporting Specialist, Strategic Initiatives

    1 day ago

    Communitech Technology Association Kitchener, Canada

    **Reporting Specialist, Strategic Initiatives** · Full Time Contract position with benefits until March 31, 2026 · **Communitech helps founders start, grow and succeed** · At Communitech, we're all about the "F" word. Founders.We were built by tech founders who saw the need for a ...

  • Home Hardware Stores Limited

    Analytics Reporting Specialist

    4 days ago

    Home Hardware Stores Limited St. Jacobs, Canada

    Home Hardware has an exciting opportunity available for an · **Analytics Reporting Specialist **to join our Strategy and Management team. Reporting to the Manager, Analytics, you will support the team in the design and development of analytical solutions, focused on data visualiz ...

  • Ontario Universities' Application Centre

    Data Reporting Specialist

    1 week ago

    Ontario Universities' Application Centre Guelph, Canada

    The OUAC values equity, diversity and inclusion and believes that every person has a right to equal treatment. We are strengthened by diverse backgrounds, perspectives and experiences. We have equitable and accessible employment practices, based on the principles specified in Ont ...

  • The Food Bank of Waterloo Region

    Communications Specialist

    3 weeks ago

    The Food Bank of Waterloo Region Kitchener, Canada

    **Communications Specialist** · Do you believe everyone should have access to healthy food, and that food can be a powerful tool for connecting people and building better health and a stronger community? Are you looking at making a difference with a well-respected non-profit orga ...

  • University of Waterloo

    Digital Community and Media Specialist

    2 weeks ago

    University of Waterloo Waterloo, Canada

    Overview: · **Term: 1 year** · The Digital Community and Media Specialist will report to the Manager, Strategic Digital Experience and be responsible for the day-to-day management and coordination of the Co-operative and Experiential Education social media accounts and paid digit ...

  • Huntington Society of Canada

    Development Specialist

    3 weeks ago

    Huntington Society of Canada Waterloo, Canada

    **DEVELOPMENT SPECIALIST** · **Position: Development Specialist** · **Reports to: National Director of Development** · **Department: Development** · **Location: Waterloo, ON (National Office)** · **Status: Permanent, Full Time** · **Purpose**: · The Development Specialist is resp ...

  • Huntington Society of Canada

    Fundraising & Grants Specialist

    2 weeks ago

    Huntington Society of Canada Waterloo, Canada

    **FUNDRAISING & GRANTS SPECIALIST** · **Position: Fundraising & Grants Specialist** · **Reports to: National Director of Development** · **Department: Development** · **Location: Waterloo, ON (National Office)** · **Status: Permanent, Full Time** · **Purpose**: · The Fundraising ...

  • University of Waterloo

    Marketing Specialist

    1 week ago

    University of Waterloo Waterloo, Canada

    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 monito ...

  • MEDA

    Communications Specialist

    3 weeks ago

    MEDA Waterloo, Canada

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

  • University of Waterloo

    Marketing Specialist

    2 weeks ago

    University of Waterloo Waterloo, Canada

    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 monito ...

  • Manulife

    Service Specialist

    2 weeks ago

    Manulife Waterloo, Canada

    **_Are you looking for a supportive, collaborative workplace with great teams and inspiring leaders? You've come to the right place. We're looking for ambitious people who share our values and want to make every day better for people around the world. If this sounds like you, and ...

  • University of Waterloo

    Specialist, Integrated Communications

    3 weeks ago

    University of Waterloo Waterloo, Canada

    Overview: · The Specialist, Integrated Communications will be part of a fast-paced team of integrated communications professionals. They will play a key role in the development of multimedia content for the University's websites and a suite of central institutional print and digi ...

  • University of Waterloo

    Vision Rehabilitation Specialist, High Technology

    2 weeks ago

    University of Waterloo Waterloo, Canada

    Overview: · **Term: 1 Year** · The Vision Rehabilitation Specialist, High Technology is responsible for assessing patients for adaptive technologies for the blind and visually impaired, determines the patient's eligibility for government funding towards the purchase of technology ...

  • Ateeca

    Canadian Payroll Specialist

    3 weeks ago

    Ateeca Waterloo, Canada

    **Job Title: Canadian Payroll Specialist** · **Location: Hybrid (Tues - Thurs in office) Waterloo or Richmond Hill** · **Duration: 12 months** · **Sr Payroll Specialist** · The SR Payroll Specialist is responsible for the timely and accurate processing of payroll for entities wit ...

  • University of Waterloo

    Undergraduate Recruitment Co-ordinator

    2 weeks ago

    University of Waterloo Waterloo, Canada

    Overview: · **Term: 14 months.** · The Undergraduate Recruitment Co-ordinator is accountable to the Associate Deans: Undergraduate Students implementing the portion of the Faculty's marketing and recruitment plan, which includes relationship building, event logistics, enhanced cu ...

  • University of Waterloo

    Specialist (Video), Integrated Communications

    3 weeks ago

    University of Waterloo Waterloo, Canada

    Overview: · The Specialist, Integrated Communications will be part of a fast-paced team of integrated communications professionals. They will play a key role in the development of multimedia content for the University's websites and a suite of central institutional print and digi ...

  • Teledyne DALSA Digital Imaging (Waterloo)

    Technical Leader

    3 weeks ago

    Teledyne DALSA Digital Imaging (Waterloo) Waterloo, Canada

    **Company Overview**: · - Our Company is built on employee mutual commitment and respect, enthusiasm and progress.Teledyne Digital Imaging is a subsidiary of Teledyne Technologies Inc., a U.S. publicly listed enterprise, and specializes in the manufacture, design, research and de ...