Jobs in Canada

25+ jobs

Group jobs by employerEmail me new jobs Save this search

Added 1 min ago
A
Product Specialist
ABB
Montreal, QC
- Full-time
The work model is hybrid with minimum 3 days per week at the office
Added 1 hour ago
SS
RQ00781 – Software Developer – Full Stack – Senior
SM Software Solutions Inc.
Toronto, ON
- On-site
Hours: 7.25 hours per day, 5 days per week
Added 1 hour ago
P
Spécialiste de l’implantation et de l’habilitation / Implementation and Enablement Specialist
Planned
Montréal, QC
- Full-time
- On-site
Added 1 hour ago
PS
Junior Project Manager
Paydar Solutions
Montreal, QC
- Full-time
Paydar Solutions is a Montréal-based industrial consulting firm. We manage projects for major food & beverage, pharmaceutical and packaging manufacturers: new production line installations…
Added 1 hour ago
NM
Product Specialist
NCS Multistage LLC
Calgary, AB
- Full-time
Bachelor’s degree in engineering or equivalent determination by hiring manager.
Added 2 hours ago
WE
Mechanical Engineer-in-Training
Williams Engineering Canada Inc
Vancouver, BC
- Full-time
…create, and encourage diverse perspectives, to provide innovative solutions across the busiest cities and the most remote regions of Western and Northern Canada. We recognize that our…
Added 2 hours ago
Intermediate Mechanical Engineer
Williams Engineering Canada Inc
Calgary, AB
…create, and encourage diverse perspectives, to provide innovative solutions across the busiest cities and the most remote regions of Western and Northern Canada. We recognize that our…
Added 2 hours ago
T1
Gas Lift Design and Sales Engineer
Tier 1 Energy Holdings LLC
Calgary, AB
- Full-time
JOB SUMMARY: The Gas Lift Design and Sales Engineer will be responsible for optimization of wells with existing equipment, developing, designing, and recommending gas lift solutions to meet…
Added 2 hours ago
WE
Intermediate Building Science Engineer
Williams Engineering Canada Inc
Calgary, AB
- Full-time
Must have valid class 5 drivers license
Added 2 hours ago
WE
Building Science Engineer-in-Training
Williams Engineering Canada Inc
Calgary, AB
- Full-time
Must have valid class 5 drivers license
Added 2 hours ago
WE
Senior Mechanical Engineer
Williams Engineering Canada Inc
Abbotsford, BC
- Full-time
…create, and encourage diverse perspectives, to provide innovative solutions across the busiest cities and the most remote regions of Western and Northern Canada. We recognize that our…
Added 2 hours ago
WE
Intermediate/Senior Building Science Engineer
Williams Engineering Canada Inc
Edmonton, AB
- Full-time
Must have valid class 5 drivers license
Added 2 hours ago
Intermediate Mechanical Technologist
Williams Engineering Canada Inc
Edmonton, AB
…create, and encourage diverse perspectives, to provide innovative solutions across the busiest cities and the most remote regions of Western and Northern Canada. We recognize that our…
Added 2 hours ago
BG
Service Technician
BV GLAZING
Burnaby, BC
- $65,000 to $75,000 CAD / year
…From Toronto to Texas, we are vertically integrated to design, engineer, manufacture and install the complete building envelope with today’s most ambitious developers. Serving both…
Added 3 hours ago
S
Product Manager
SiftMed
St. John's, NL
- Full-time
SiftMed is hiring a Product Manager to join our product team and report to the VP, Product Management. Our PMs lead projects rather than owning fixed product areas. A single project often…
Added 3 hours ago
PA
Systems Engineering Manager
PROVINCIAL AEROSPACE LTD
Halifax, NS · Vaughan, ON · Ottawa, ON · St. John's, NL
- Full-time
As a leader within PAL Aerospace's Systems Engineering organization, the Systems Engineering Manager plays a critical role in the development of advanced Intelligence, Surveillance, and…
Added 3 hours ago
NC
Engineering Supervisor
Nasittuq Corporation
Ottawa, ON
- Full-time
Present engineering recommendations and project solutions during technical review meetings and customer briefings.
Added 5 hours ago
CA
Product Specialist
CATBL ABB Electrification Canada Inc.
Montréal, QC · Saint-Laurent, QC
- Full-time
The work model is hybrid with minimum 3 days per week at the office
Added 9 hours ago
LM
ADMINISTRATIVE SITE ASSISTANT - LONDON SITE
Laframboise Mechanical Electrical Ltd
London, ON
- Contract
Live our Core Values: We believe in maintaining high standards, fostering a safe and diverse work environment, and applying innovative solutions to every project.
Added 9 hours ago
LG
ADMINISTRATIVE SITE ASSISTANT - LONDON SITE
Laframboise Groupe
London, ON
- Contract
Live our Core Values: We believe in maintaining high standards, fostering a safe and diverse work environment, and applying innovative solutions to every project.
Added 12 hours ago
H
Project Manager - Bridges and Structures
HDR
Toronto, ON · Burlington, ON · Richmond Hill, ON
- Full-time
…infrastructure or pioneering next-generation transportation solutions, your contributions will help define the future of mobility. This isn’t just a job, it’s a chance to lead progress,…
Added 12 hours ago
H
Construction Contract Administrator - Field Operations
HDR
Calgary, AB
- Full-time
Must have a fundamental understanding of contracts and familiarity with codes and laws governing construction · Must possess the ability to read and interpret construction drawings and specifications and identify discrepancies or conflicts within documents
Added 12 hours ago
A
Structural Engineer
Actalent
Calgary, AB
- $70 to $80 CAD / hour
- Contract
Support the Engineering Manager and Lead Structural Engineer in delivering projects on time, within scope, and within budget.
Added 12 hours ago
S
Director, Regional Product Management
ServiceNow
Toronto, ON
- Full-time
- Hybrid
It all started when engineer Fred Luddy wrote code that automated a tedious task for his coworker, Phyllis. She cried tears of joy. That moment inspired Fred to build a company that could…
Added 12 hours ago
RC
project engineer in building controls
Randstad Canada
Laval, QC
- $95,000 to $115,000 CAD / year
- Full-time
…you like to play a key role in creating world-class climate solutions? Are you looking for an environment where your technical expertise will be fully valued as a project…

Rubicon Path

RQ08739 - Business Intelligence Specialist - Senior

Toronto, ON, Canada

Apply on careers-page.com About employer

Applications open in a new tab.

Job details

Posting language: English

Original 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

Apply on careers-page.com About employer

More about this job

Responsibilities

The Business Intelligence Specialist at Rubicon Path will gather requirements, build Cognos models and reports, and tune the SQL behind them. The role also trains staff and hands the work over to the client team.

Requirements

Candidates need senior experience with Cognos Analytics v12.x reporting and administration, plus AWS Redshift and Oracle SQL/PL/SQL. Public sector project experience and Agile or waterfall delivery skills are also expected.

Skills

Cognos Analytics
Cognos Framework Manager
Cognos Transformer
Cognos Dynamic Cube Designer
Cognos Data Modules
Cognos SDK
Cognos Life Cycle Manager
IBM Cloud Pak for Data
AWS Redshift
AWS
Oracle 19
SQL
PL/SQL
Materialized views
SQL performance tuning
PowerDesigner
Data warehouse design
Data mart design
Requirements analysis
Report development
Dashboard development
Embedded JavaScript
Embedded SQL
Metadata management
Security model design

Keywords

Business Intelligence
BI Specialist
Cognos Analytics
Cognos 12
Framework Manager
Transformer
Dynamic Cubes
AWS Redshift
AWS
Oracle 19
PL/SQL
SQL tuning
IBM Cloud Pak for Data
Data Warehouse
Data Mart
PowerDesigner
Agile
Scrum
Waterfall
JIRA

Seniority

Senior

Tools

Cognos Analytics
Framework Manager
Transformer
Dynamic Cube Designer
Cloud Pak for Data
AWS Redshift
Oracle
JIRA
Confluence

Languages

English

Report this job

Work requirements

Jobs in Canada