RQ08950 - Software Developer - Senior

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.

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.

Technical Skills

10+ years of experience with:

• 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.

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.

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 tuning, Automation.