JobsCompaniesTalents

Loading job…

AApplyPick

Remote job catalog with tools to tailor your resume and cover letter to each role.

[email protected]

Explore

Remote jobs
Companies
Blog

Company

About
Help & support

Legal

Privacy Policy
Terms of Service
Listings are aggregated from public job boards and career pages.

© 2026 ApplyPick. All rights reserved.

RQ08739 - Business Intelligence Specialist - Senior at Rubicon Path · ApplyPick

Jobs
/
Rubicon Path
/
RQ08739 - Business Intelligence Specialist - Senior

RP

RQ08739 - Business Intelligence Specialist - Senior

Rubicon PathCanada only

Apply now

Opens the original posting on Himalayas.

Apply now Source: Himalayas

Apply on the original site

Companies in this catalog do not charge applicants. Never send money to apply.

Responsibilities:

Document the new requirements and complete analysis and design document
Convert the user requirements into business model for Cognos BI
Convert the business model into Framework Manager Models
Build the security model for the BI implementation
Create metadata, user groups and folder structure for BI objects
Develop reports in Cognos on Cloud Pak for Data and AWS Redshift database
Test, debug, re-engineer standard reports and dashboards in Cognos on AWS

Support converted Dynamic Cubes functionality in DMR or Transformer Cubes without any loss in performance

Document test cases to ensure expected functionality of the reports

Deploy reports using Cognos Framework Manager

Develop SQL and PLSQL process and procedures to implement complex logic.
Assist with SQL tuning and optimization activities related to the Cognos reports.
Help to optimize the SQL and PL/SQL process for optimal report performance.
Prepare scripts and documentation for the data preparation process and regular performance checks & monitoring.
Support user acceptance testing and system implementation.
Train SMEs or conduct demos on self-serve BI reporting.

Report development for Intellihealth expansion

Any other deliverables as assigned by the Project/Resource Manager.
Knowledge transfer to HSC staff in the form of a detailed guide or as per project requirements.
SkillsExperience and Skill Set Requirements

Public Sector Experience

Experience working in the Public Sector and familiarity with I&IT project management processes
5 points

Technical Skills

Experience in design and development of Data Marts or Data Warehouses on a wide range of data repositories (relational and multi-dimensional data stores)

Experience in Cognos Analytics reporting; modeling with Framework Manager, Transformer, Dynamic Cube Designer, Data Module, Dataset, SDK; implementing point-in-time architecture; testing with Life Cycle Manager (5+ years)

Excellent requirements analysis skills
Demonstrated experience in working with Power Designer Tool to design logical and physical models, generating scripts and applying model changes.
In-depth knowledge and experience with Cognos report development in Cognos Analytics and Administration v12.x (reporting, dashboarding, embedded JavaScript, embedded SQL)
Knowledge of BI architecture patterns, best practices, processes, and artefacts
Experience developing Cognos reports in the IBM Cloud Pak for Data environment
50 points
Core skills, database and domain knowledge
Experience in Oracle 19 or higher including writing complex SQL/PL SQL queries and materialized views.
Experience in AWS Cloud technologies, specifically AWS Redshift
Experience in database performance and tuning skills
Experience in Cognos migration and testing skills (reporting, dashboarding, embedded JavaScript, embedded SQL)
Experience with Agile/scrum and waterfall methodologies, using tools such as JIRA and Confluence
35 points

General Skills

Proven troubleshooting and critical thinking skills
Strong interpersonal skills with ability to work with client stakeholders to understand, interpret business requirements and its technical implications.
Demonstrated ability to present technical solutions to client stakeholders, technical staff and to senior management.

A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.

10 points

MUST HAVES:

In-depth knowledge and experience with Cognos report development in Cognos Analytics and Administration v12.x (reporting, dashboarding, embedded JavaScript, embedded SQL) Experience in AWS Cloud technologies, specifically AWS Redshift Originally posted on Himalayas

Apply now

Opens the original posting on Himalayas.

Apply now Source: Himalayas

Apply now

Opens the original posting on Himalayas.

Apply now Source: Himalayas

About the job

Apply before: Dec 12, 2026
Posted on: Oct 13, 2026
Job type: Full Time
Experience level: Senior
Location requirements: Canada
Hiring timezones: UTC-8 to UTC-3:30
Job categories: Data Science
Skills: BI Developer Business Intelligence Analyst Business Intelligence Developer Business Intelligence Specialist Senior BI Analyst Senior Business Intelligence

Similar searches

Senior Data Science jobs
Full Time Data Science jobs
Jobs in Canada

About Rubicon Path

RP

Rubicon Path

Company profile