Senior BI Developer

• Please refer to the Experience and Skillset Requirements

Description

• NOTE
  • Assignment Type: This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.
  • Extension/Amendment Attestation:
  • Extensions are permitted only to the extent of unused contract days and/or remaining contract funds. No additional funds will be added beyond the maximum contract value including any extension options set out in the original SOW.
  • HSC may exercise its option to extend the SOW beyond October 5 2027 provided that the Master Service Agreement is extended. Any such extension shall be on the same terms conditions and covenants as those contained in the SOW.
• 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.

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

• 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 - 30 points

• 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 - 15 points

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