Title Software Developer - Senior
Office location - Toronto, ON
Rate - $85/HR
CRJMC Required
Duration 1st May 2025- 2nd April, 2026

Submission Last Date 14th April, 2025, 9:30am

Description

Responsibilities:

Software Developer (Cognos PEAR)

• Provide subject matter expertise to develop, test, support and maintain 40+ Standard Panorama Enhanced Analytic Reports and transform and present data to support analytics
• Provide and support PEAR business model to enable self-service reports which is a critical functionality for PHUs, OCMOHPH, PHO and OGP
• Develop and support PEAR to be AODA compliant
• Develop and support Cognos upgrades
• Develop and enhance PEAR by adding more new data scopes, new reports or other new features
• Provide Business intelligence and data analytics, data warehouse design, dimensional data modeling, relational data modeling development and support
• Provide impact analysis, effort estimate and solution design/development for PEAR due to DHIR solution upgrades, software upgrades or any new requirements (e.g. Panorama 4.4.x upgrades, PHU merge and more)
• Support Cognos administration and package creation
• Conduct research and assessment of options for technical design issues
• Contributing to design/development project plans, including work breakdown and resources estimates
• Provide Cognos report design, development and testing, Framework manager, Query Studio, Reports Studio, creation of dashboards, etc.
• Conduct technical analysis, troubleshooting, and issue resolutions for production operational support of PEAR reports, PEAR business models and other components and utilities
• Provide end users support for their user-defined reports if required
• Resolving and implementing critical fixes and changes in PEAR as per defects found by business and as per Panorama critical changes
• Conduct routine and incident management
• Perform performance tuning as well as audit and ad hoc reporting per business requests
• Maintain Development environments and continue continuous Integration (CI) practice
• Translate technical systems specifications into working, tested applications
• Conduct technical analysis, preparation of detailed programming specifications, program design, writing and/or generating code, and conduct unit tests
• Provide software expertise in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways.

Skills

Experience and Skill Set Requirements

Public Sector Experience

• Experience working with federal/provincial/broader public-sector healthcare providers
• Knowledge of the provincial immunization system and Public Sector large complex IT Health related projects or equivalent
• Experience with integration of Clinical IT Systems such as Client and Provider Registries
• Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices
• Knowledge of industry standard such as Project Management Institute (PMI)
• Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process and Public Sector Standard Systems Development Methodologies.

5 points

Technical Skills

• 10+ years of experience with:
• Cognos 11.x report design, development and testing, Framework manager, Query Studio, Reports Studio, creation of dashboards, map/location etc.
• Cognos AODA compliant
• Cognos administration and package creation
• Other Reporting tools, particularly Crystal Reports and Business Objects and PowerBI would be an asset
• Business intelligence and data analytics, data warehouse design, modeling, development and support
• Informatica for data extraction, transformation, and loading, initial setup and other ETL experience management and support, such as troubleshooting, performance tuning, failover and recovery
• Oracle RDBMs(19c), SQL, PL/SQL, JSON, XML, Unix/Linux shell scripting, optimized database queries, data architecture, data design, modeling and mapping
• Database and Cognos performance turning, Automation
• Experience with version control system SVN or GitLab
• Working knowledge of issue tracking system Jira
• Enhanced CI/CD experience and DevOps methodologies and technologies an asset
• Develop and support application monitoring using Elastic/Logstash/Kibana or Sematext
• Knowledge of Java, JSON, XML, API calls, HL7/FHIR, Restful web services
• Knowledge of the provincial immunization systems.

50 points

Core Skills, Knowledge and Experience

• 10+ years of experience with:
• Provide Business intelligence and data analytics, data warehouse design, dimensional data modeling, relational data modeling development and support
• Support Cognos administration and package creation
• Conduct research and assessment of options for technical design issues
• Contributing to design/development project plans, including work breakdown and resources estimates
• Maintaining development environments and continue continuous Integration (CI) practice
• Working with business analysts to translate the business requirements and functional specifications into an application design appropriate to meet the business and operational/IT needs
• Working with technical systems specifications and translating them into working, tested applications for large, complex, mission critical applications
• Work with Quality Assurance (QA) to code, test, and debug extensions/tools integration services
• Analysis, design and development work on complex, multi-tier web-based applications, micro-services architecture, mobile, and off-the-shelf solutions
• Proven technical leadership skills with ability to identify areas for improvement, and recommend solutions
• Designing, developing and implementing applications that work across modern browsers and various platforms, and mobile devices
• Using and applying extensive knowledge of User Interface (UI) design principles across a variety of applications, platforms and devices
• Conducting technical analysis, program code, detailed programming reports and specifications, program design, writing and/or generating code, and conducting tests
• Developing and maintaining system design models, technical documentation and specifications
• Maintaining development environments and adopt continuous Integration (CI) practice
• Conducting technical evaluation and assessment of options for technical design issues, application figuration aspects and integration capabilities, related tools and utilities, gap analysis of integration components to technical requirements/specifications/documentation
• Providing impact analysis, effort estimate and solution design/development for solution/software upgrades or based on any new business requirements
• Undertaking proof of technology with test data to simulate application load and performance tuning related applications
• Providing software expertise in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways
• Providing application programming support for incident management, application functionality sustainment, performance tuning and technical documentation
• Developing and maintaining system design models, technical documentation and specifications
• Developing medical and clinical based systems
• Web performance optimization
• Various computing platforms, operating systems, database technology, communication protocols, middleware and gateways
• Conducting technical analysis, troubleshooting, and issue resolutions for production operational support of reports, and other components and utilities
• Knowledge of recognized accessibility laws, regulations, and standards (e.g., W3C, WCAG) or other specific accessibility standards, and experience in usability, accessibility and compliance testing
• Ensuring compliance with architecture framework and system standards, and Agile Development Methodology
• Project management practices, and ability to contribute to design/development project plans, including work breakdown, resource estimates, and status reports
• Experience with Software Development Lifecycle (SDLC)
• Continuous Integration (CI) practice and enhanced Ci/CD experience and DevOps methodologies and technologies an asset
• Knowledge and experience with leading-edge technologies, design criteria including usability, security, and privacy for web and mobile applications.

30 points

General Skills

• Demonstrated strong leadership and people management skills
• Exceptional analytical, problem solving and decision-making skills
• Demonstrated strong interpersonal, verbal and written communication, and presentation skills
• Proven troubleshooting and critical thinking experience
• Demonstrated ability to apply strong listening skills to facilitate issue resolution
• Effective consulting skills to engage with all stakeholders with proven track record for building strong working relationships
• Excellent customer service skills, including tact and diplomacy to ensure client needs are managed effectively
• 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.

15 points

MUST HAVES:

10+ years of experience with:

• Cognos 11.x report design, development and testing, Framework manager, Query Studio, Reports Studio, creation of dashboards, map/location etc.
• Cognos AODA compliant
• Cognos administration and package creation
• Business intelligence and data analytics, data warehouse design, modeling, development and support
• Informatica for data extraction, transformation, and loading, initial setup and other ETL experience management and support, such as troubleshooting, performance tuning, failover and recovery
• Oracle RDBMs(19c), SQL, PL/SQL, JSON, XML, Unix/Linux shell scripting, optimized database queries, data architecture, data design, modeling and mapping
• Database and Cognos performance turning, Automation