About the job RQ08738 - Software Developer - SeniorResponsibilities:Prepare a detailed BI user requirement document and applicable documentation.Prepare the database design/structure document based on the requirementDesign and build the dimensional data model for Data Warehouse and Data MartConvert 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 structure for BI objectsCreate use cases for each of the requirementDesign, build, test predefined reportsCreate reports using Cognos Analytics V12.XTest, Debug and resolve BI reporting issuesDocument test cases to ensure expected functionality test is completedDeploy reports using COGNOS Framework ManagerDevelop SQL,
PLSQL and Redshift SQL process and procedures to implement complex logicAssist with SQL tuning and optimization activities related to the Cognos reportsHelp to optimize the SQL, PL/SQL and Redshift SQL process for optimal report performancePrepare scripts and documentation for the data preparation process and regular performance check & monitoringSupport user testing and system implementation.Train SMEs or conduct demos on Ad hoc reportingAny other enhance requests and deliverables, such as Ontario Health region alignment in Cognos, as assigned by the Project/Resource ManagerKnowledge