Senior Cognos Specialist

Contract Rate: $85–95/hr
Experience: 10+ years
Location: Toronto, North York - 5 days a week On-site
Preferably to start immediately
Contract Duration: Dec - March 31, 2026 (with an option to extend for additional 6 months)

---

Must-Haves

• In-depth knowledge and experience with Cognos report development in Cognos Analytics v12.x, including reporting, dashboarding, embedded JavaScript, and embedded SQL.

Role Description

• Translate user requirements into Cognos BI business models and Framework Manager models.
• Design and implement BI security models, metadata, user groups, and folder structures.
• Develop and optimize Cognos reports and dashboards on Cloud Pak for Data and AWS Redshift.
• Test, debug, and re-engineer reports; document test cases for functionality validation.
• Create and tune SQL/PLSQL processes for complex logic and performance optimization.
• Prepare scripts and documentation for data preparation, performance checks, and monitoring.
• Support UAT, deployment, and provide training or demos for self-service BI reporting.
• Deliver knowledge transfer and detailed documentation to HSC staff as per project requirements.

---

Experience and Skill Set Requirements

Public Sector Experience (5%)

• Experience working in the Public Sector and familiarity with I&IT project management processes.

Technical Skills (50%)

• Design and development of Data Marts or Data Warehouses on relational and multi-dimensional data stores.
• Cognos Analytics reporting; modeling with Framework Manager, Dynamic Cube Designer, Data Module, Dataset, SDK; implementing point-in-time architecture.
• Excellent requirements analysis skills.
• Experience with Power Designer Tool to design logical and physical models, generate scripts, and apply model changes.
• In-depth experience with Cognos report development and administration v12.x.
• Knowledge of BI architecture patterns, best practices, processes, and artefacts.
• Experience developing Cognos reports in the IBM Cloud Pak for Data environment.

Core Skills, Database and Domain Knowledge (35%)

• Experience with Oracle 19+, including writing complex SQL/PLSQL queries and materialized views.
• Experience with AWS Cloud technologies, specifically AWS Redshift.
• Database performance tuning skills.
• Cognos testing skills (reporting, dashboarding, embedded JavaScript, embedded SQL).
• Familiarity with Agile/Scrum and Waterfall methodologies; tools like JIRA and Confluence.

General Skills (10%)

• Proven troubleshooting and critical thinking skills.
• Strong interpersonal skills; ability to work with stakeholders to interpret business requirements and technical implications.
• Ability to present technical solutions to clients, technical staff, and senior management.
• Motivated, flexible, detail-oriented, creative team player with excellent organization, multitasking abilities, and a proven track record for meeting strict deadlines.

We appreciate the time and effort all applicants invest in their submissions. Please note that only candidates shortlisted for this role will be contacted directly. However, your profile will remain under consideration for future opportunities that align with your experience and career goals. All qualified applicants will receive fair consideration for employment. We welcome individuals of all backgrounds, experiences, and identities including those who identify as women, members of racialized groups, Indigenous Peoples, persons with disabilities, and 2SLGBTQIA+ communities. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions. Our human recruiters review all applications and always make the final hiring decision. On occasion, we also use AI-assisted tools to help review applications.