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 selfservice 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 userdefined 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 publicsector 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 leadingedge 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 decisionmaking 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 detailoriented and creative team player with perseverance excellent organization and multitasking 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.