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 transfer to HSC staff.SkillsExperience and Skill Set RequirementsPublic Sector ExperienceExperience with Public Sector processes around incident and change management. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices,



and ability to produce technical documentation that comply with industry standard practices5 pointsTechnical SkillsExperience in designing and developing Data Marts or Data Warehouses on a wide-range of data repositories (relational and multi-dimensional data stores)Experience in Framework Manager modelling, database design/data model design, point-in-time architecture, and dimensional model (5+ years)Excellent requirements analysis skillsDemonstrated experience in working with Power Designer Tool to design logical and physical models, generating scripts and applying model changes in variousIn-depth knowledge and experience with Cognos report development, testing and server management in Cognos Analytics and Administration v12.XKnowledge of Power BI and TableauKnowledge of BI architecture patterns, best practices, processes, and artefactsExperience with Agile/scrum and waterfall methodologies, using tools such as JIRA and ConfluenceCloud Experience (Azure, AWS)40 pointsCore Skills and ExperienceIn-depth knowledge and experience with Cognos report development, testing in Cognos Analytics v12.X (5+ years)Experience in overall administration, configuration, deployment, security, and maintenance for the Cognos environmentExperience in Oracle 19 or higher and Redshift including writing complex SQL queries and materialized viewsExperience in Cognos and database performance and tuning skillsProven critical thinking, analytical and problem solving skillsExcellent verbal and written communication skills.Strong communications skills to engage with all stakeholders.Proven track record for building strong working relationships.Excellent customer service skills, including tact and diplomacy to ensure client needs are managed effectivelyA motivated, adaptable, creative team player with perseverance, excellent multi-tasking abilities and a proven track record for meeting strict deadlines.50 points5 pointsMUST HAVES:In-depth knowledge and experience with Cognos report development, testing and server management in Cognos Analytics and Administration v12.XExperience in Oracle 19 or higher and Redshift including writing complex SQL queries and materialized views

📌 Rq08738 - Software Developer - Senior (Toronto)
🏢 Rubicon Path
📍 Toronto