Apply now

First seen by our source: last month

RQ08739 - Business Intelligence Specialist - Senior

@ Rubicon Path

Toronto, Ontario

5+ years experience
Apply now
SIGNALS

Overview

Rubicon Path is hiring a senior Business Intelligence Specialist for a public sector project. The role designs and builds Cognos Analytics reports and models on AWS Redshift and Cloud Pak for Data, and supports testing, optimization and knowledge transfer. Experience with Cognos Analytics v12.x and AWS Redshift is a must-have.

Responsibilities:

  • Develop Cognos reports and models on Cloud Pak for Data and AWS Redshift
  • Build Framework Manager models, security model and metadata
  • Develop and optimize SQL and PL/SQL processes for report performance
  • Support UAT, deployment and knowledge transfer to HSC staff

Requirements summary:

  • 5+ years Cognos Analytics reporting and modeling experience
  • In-depth Cognos Analytics and Administration v12.x knowledge
  • Experience with AWS Redshift
  • Oracle 19+ with complex SQL/PL/SQL and materialized views
  • Public sector experience and I&IT project management familiarity

Tools & skills

Source and dates

Source type not verified · manatal

Employer posting date
Not provided
First seen by our source
2026-10-15
Source record updated
2026-10-15

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SenioritySenior
DepartmentData & analytics
Experience5+ years
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish

Summary and details written by AI from the posting; the employer’s posting is the authority.

Rubicon Path

FieldValue
Open jobs on Jobsy578
Job description

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

Similar jobs

  • Analyste, conformité TI (télétravail)/ IT Compliance Analyst II (Remote)

    Toronto, ON
    Full Time

    TA US Quintiles Laboratories

    Planifier, coordonner, exécuter, documenter et clôturer les revues périodiques des applications validées conformément aux procédures de qualité et de conformité; Agir à titre de principal point de contact TI pour les…

    Regulatory compliance, Quality assurance, Inspection, Documentation, Process improvement, Computer science

  • Senior Account Executive, Brand

    Toronto, ON
    $55k–$70k/yrHybridFull Time

    Zeno Canada

    3+ YOE3+ years of experience in public relations, communications or related fields, preferably within an agency environment; Experience securing earned media coverage through pitching, media outreach and content development;…

    Client relationship management, Research, Project management, Team leadership, Collaboration, Delegate activities

  • Payroll Systems & Automation Specialist

    Toronto, ON
    Full Time

    Opendoor

    We’ve built an end-to-end online experience that has already helped thousands of people and we’re just getting started; This role requires solid, hands-on AI experience; Payroll or equity experience is a plus, but it…

    Payroll, Reporting, Workflow, Problem solving, Troubleshooting, Attention to detail

  • Support Engineer, Cloud

    York, ON +1
    Full Time

    Sun Life of Canada - Corporate

    2+ YOESun Life needs candidates with a bachelor's degree in computer science and engineering or equivalent experience, at least 2 years working with big data on AWS, and 2 years with SQL, Python and ETL tools such as Informatica. Experience with DevOps tools like Jenkins, Ansible and CI/CD pipelines is also required.

    AWS, Glue, Redshift, Lambda, EC2, S3

  • AVP, Omni-Channel Enablement , Group Retirement Services

    Toronto, ON
    Full Time

    Sun Life Assurance Company of Canada

    Sun Life needs senior leaders with experience turning strategy into measurable outcomes, leading transformation or contact-centre enablement, and improving member journeys across digital and human channels. A business, related or equivalent degree is required, and an MBA, CPA or CFA is preferred.

    CSC, Process improvement, Coaching, Project management, Organisational resilience, Record keeping

    Bilingual Financial Service Consultant- Insurance/Conseiller(ère) bilingue en services financier- assurance

    Montréal, QC +3
    Full Time

    Sun Life Assurance Company of Canada

    2+ YOECandidates need an active LLQP/PQAP life insurance licence, at least two years of sales or service experience, and strong bilingual French and English skills. Strong phone rapport, probing questions and closing skills are essential.

    Bilingualism, Relationship building, Sales, Quality assurance, Communication skills, Adapt to change

    Product Owner, Retail Client Journey (Web)

    Waterloo, ON +1
    Full Time

    Sun Life Assurance Company of Canada

    5+ YOECandidates need 5+ years in product ownership or digital delivery, ideally in financial services. Hands-on agile experience with backlogs, user stories and ceremonies, and knowledge of retail insurance or wealth products, are required.

    Regulatory compliance, Research, Change management, Sell insurance, Stakeholder management, Collaboration

    Insurance and Wealth Associate, Prospr by Sun Life

    Toronto, ON +1
    Full Time

    Sun Life Assurance Company of Canada

    Candidates need strong verbal and written communication skills, call centre or telephone service experience, and knowledge of financial services. Relationship building, problem solving and comfort with digital tools are also required.

    Salesforce.com, Prospr platform

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.