RQ10810 Software Developer Senior

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

Experience and Skill Set Requirements:

Skill Set Requirements:

Public Sector Experience:

• Experience working with federal/provincial/broader public-sector healthcare providers
  
• Knowledge of the provincial immunization system and OPS large complex IT Health related projects or equivalent
  
• Experience with integration of Clinical IT Systems such as Client and Provider Registries
  
• Knowledge of OPS 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 OPS Unified I&IT Project Methodology OPS Enterprise Architecture and OPS Gating process and OPS Standard Systems Development Methodologies.
  

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.
  

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.
  

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