RQ08739 - Business Intelligence Specialist - Senior

Rubicon Path; Canada; On-site; CAD 95,000 - 150,000; Full time

Job summary

Rubicon Path is seeking a Cognos BI analyst to document requirements, design BI models, and build reports on Cloud Pak for Data and AWS Redshift.

You will create metadata, security models, deploy reports, optimize SQL, and train SMEs for self-serve BI reporting. This role emphasizes Cognos Analytics, Framework Manager, Transformer, and Cloud Pak for Data deployment capabilities.

Qualifications

• 5+ years in Cognos Analytics reporting and BI modeling.
• Proficient with Framework Manager, Transformer and Dynamic Cube Designer.
• Experience with Cognos in IBM Cloud Pak for Data environment.
• Strong SQL/PLSQL and data warehousing knowledge.

Responsibilities

• Document the new requirements and complete analysis and design document.
• Convert 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 processes to implement complex logic.
• Assist with SQL tuning and optimization activities related to the Cognos reports.
• Help 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.

Skills

Cognos Analytics

Framework Manager

Transformer

Dynamic Cube Designer

Cloud Pak for Data

SQL/PLSQL

AWS Redshift

Life Cycle Manager

Tools

Data Module

Dataset

SDK

Power Designer

JIRA

Confluence

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