About the job RQ08950 - Software Developer - Senior
Description

NOTE

Assignment Type: This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home, or as per schedule agreed to with the Hiring Manager.

Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW.

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 recent 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⁢ 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 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

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

#J-18808-Ljbffr

📌 Software Developer - Senior (Ontario)
🏢 Rubicon Path
📍 Ontario