Senior Software Developer

Job Description:

Responsibilities:

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

Experience and Skill Set Requirements:
Public Sector Experience - 5 points:

• 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 - 50 points:

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