RQ10703 Business Intelligence Specialist Senior

Toronto - Canada

Monthly Salary: Not Disclosed

Experience Required: 7-10years

Posted on: 18 hours ago

Vacancies: 1 Vacancy

Job Summary

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
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.

Requirements

Experience and Skill Set Requirements:

Must Haves:

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)
Experience in AWS Cloud technologies specifically AWS Redshift

Skill Set Requirements:

Public Sector Experience:

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

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

Core skills database and domain knowledge:

Experience relational databases including writing complex SQL and database specific programming languages (e.g PL/SQL T-SQL) scripts.
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

General Skills:

Demonstrated leadership and people management 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.

Required Skills:

Experience and Skill Set Requirements: Must Haves: 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) Experience in AWS Cloud technologies specifically AWS Redshift Skill Set Requirements: Public Sector Experience: Experience working in the Public Sector and familiarity with I&IT project management processes 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 -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 Core skills database and domain knowledge: Experience relational databases including writing complex SQL and database specific programming languages (e.g PL/SQL T-SQL) scripts. 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 General Skills: Demonstrated leadership and people management 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.

Responsibilities:Document the new requirements and complete analysis and design documentConvert the user requirements into business model for Cognos BIConvert the business model into Framework Manager ModelsBuild the security model for the BI implementationCreate metadata user groups and folder stru...