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.
  

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