Role Business Intelligence Specialist

Location - 5700 Yonge Street, 10th Floor, Toronto, ON (Hybrid)

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.

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
  "#L!-CEIPAL"