Job Description

Assignment: RQ07817 - Software Developer - Senior
Job Title: Cognos Developer
Requisition (SS): RQ07817
Start Date: 2024-10-01
End Date: 2025-03-31
Client: Children, Youth & Social Services Cluster
Office Location: 5700 Yonge Street, Toronto
Organization: Children, Youth & Social Services Cluster
Ministry: Ministry of Children, Community and Social Services
# Business Days: 123.00
Note: Please note this role is part of a Hybrid Work Arrangement and resource(s) will be required to work at a minimum of 2-3 days per week at 5700 Yonge St.
Must haves:

• 7-10 years of experience as a Senior Cognos Developer in a public sector environment or large (greater than 1000 users) business and I&IT transformation project(s).
• Hands-on experience writing Cognos and SQL
• Experience in large scale implementations
• Technical expertise to enhance, configure, customize and integrate case management system with external or related applications
• Experience in conducting requirements elicitation, fit-gap, design, and development phases in large Cognos implementations
• Ability to advise and provide technical recommendations on infrastructure, reporting and interfaces

Description

• At minimum, the Software Developer- Senior will have the responsibilities set out below:
• Provides subject matter expertise and hands-on engagement for all relevant systems including identifying and creating technical solutions design, development, and deployment for specified technology.
• Responsible for the complete end-to-end development of applications and database in both traditional and cloud deployments.
• Create functional and technical designs
• Refine and clarify designs during software development and implementation. Code and unit test code, provide subject matter expertise in supporting System Integration Testing and Use Acceptance Testing.
• Support deployment in production. Conduct Root Cause Analysis of production issues.
• Create all functional and technical design documents

General Skills:

• Experience with Cognos V11.2
• Experience in creating and documenting the technical design, development and delivery of specified technology solutions including: reports, interfaces, conversions, extensions and customizations for High Availability environments.
• Demonstrated experience in the creation and update of technical design specifications to satisfy project requirements
• Experienced in providing estimations of project delivery based on business requirements
• Experience designing, developing and testing data conversion programs and processes to ensure accurate data migrations
• Experience and knowledge of specified technology enterprise architecture methodologies and tools
• Experience developing or customizing reports, interfaces, customizations, application extensions, workflows and procedures
• Knowledge of specified technology Application Framework and Application Development Framework
• Experience with UI integration (embedding external application in specified technology, exposing specified technology in External application)
• Experience developing integrated test scenarios, identifying test data, executing test scenarios as part of system integration testing (COTS and custom), troubleshooting and resolving issues identified and documenting test results.
• Experience with Stakeholder management
• Knowledge of Open UI Concepts-PM, PR, Manifest File and Mapping files
• Experienced in design and development for large scale Information Technology (IT) solutions and providing guidance to development teams
• Experienced in developing JEE solutions, including JEE design patterns
• Proficient in analyzing and designing changes to existing software solutions
• Complete knowledge of SDLC methodologies e.g. Agile development
• Proficient in RDBMS design concepts

Desirable Skills:

• Experience creating Unix scripts
• Experience with Database and SQL
• Experience in using Gitlab for version control
• Proven experience in facilitating discussions, negotiations, conflict resolution
• Strong communicating skills in effectively communicating with client, management and team, making presentation and reporting outcomes
• Experience in designing and developing Web Services
• Experienced in AIX, UML and XML
• Experienced in design, develop, test, optimize and support complex stored procedures, functions, triggers and other database objects with ability to solve complex production issues

Experience and Skill Set Requirements

• Please note this role is part of a Hybrid Work Arrangement and resource(s) will be required to work at a minimum of 2-3 days per week at 5700 Yonge St.
• 7-10 years of experience as a Senior Cognos Developer in a public sector environment or large (greater than 1000 users) business and I&IT transformation project(s).
• Hands-on experience writing Cognos and SQL
• Experience in large scale implementations
• Technical expertise to enhance, configure, customize and integrate case management system with external or related applications
• Experience in conducting requirements elicitation, fit-gap, design, and development phases in large Cognos implementations
• Ability to advise and provide technical recommendations on infrastructure, reporting and interfaces

Selection Criteria
Application design and development experience - 50

• Hands-on experience with Cognos. Provide end to end solution design, development and unit testing along with recommendations to achieve business outcomes in alignment with business requirements, Cluster reference architecture and Ministry specific objectives
• Collaborate with stakeholders to understand business goals and support delivery outcomes
• Develop code following the SA development standards, architectural governance principles and design patterns in the development of end-to-end solutions

Methodology, testing and troubleshooting - 30

• Excellent analytical, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
• Experience working in agile development environment
• Ability to provide user and system documentation as required
• Contribute to the effective management of risks and issues associated with Solution designs
• Collaborate with cross-functional and distributed teams, including designers, developers, architects, project managers, and QA
• Promotes industry standards and best practices with the product teams.
• Perform thorough code reviews including unit tests and ensure high quality of the software.
• Fix defects and support developers, and end users

Planning, Documentation and communication - 20

• Prepare work plans with CYSSC Managers, report and adjust completion status, report issues and risks in a timely manner
• Write technical documentation that supports and thoroughly explains the architecture
• Deliver knowledge transfer sessions to the team on the work completed