Senior Data & Integration Developer

MUST HAVES:

• 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.
• Develop coding testing and debugging to support existing extensions/tools such as IRT De-Dup OIA Immunization Forecaster and PR Upload
• Conduct technical analysis preparation of detailed programming specifications program design writing and/or generating code and conduct unit tests
• Translate technical specifications for sustainment and upgrade into working tested applications
• Undertake proof of technology with test data to simulate application load and performance tuning related applications
• Provide software expertise in various computing platforms operating systems database technology communication protocols middleware and gateways
• Provide impact analysis effort estimate and solution design/development for supported solutions due to DHIR solution upgrades software upgrades or any new requirements (e.g. Panorama 4.4 upgrades PHU merge and more)
• Provide application programming support for incident management application functionality sustainment performance tuning and technical documentation
• Work with Quality Assurance (QA) to code test and debug extensions/tools integration services
• Maintain Development environments and continue continuous Integration (CI) practice
• Improve the quality and accuracy of the data collected for the approximately 34 PHUs and 2282 PHU users
• Ensure availability of the DHIR extensions/tools for use by all Ontarians.

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

• 10 years of experience with:
• Design and development of Oracle(12c) for OLAP and OLTP applications including PL/SQL Oracle stored procedure packages functions triggers ref cursors dynamic SQLs DBMS packages etc.
• Demonstrated ability to create normalized database schemas utilizing data modeling discipline. Understanding of normalization de-normalization and the difference between the two. Ability to create schemas for both OLTP and OLAP databases.
• Advanced SQL skills optimized database queries and data architecture database design database modeling
• Data Warehouse design and development Database performance tuning Automation
• Unix/Linux Shell Scripting
• Informatica for data extraction transformation and loading initial setup and other data management purposes
• Cognos report design and development Framework manager Query Studio Reports Studio creation of dashboards etc. Other reporting tools would also be an asset particularly Crystal Reports and Business Objects
• Knowledge of Java JSON XML API calls HL7/FHIR Restful web services
• Knowledge of the provincial immunization system.

Core Skills and Experience - 20 points

• 10 years of experience with:
• 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
• 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
• Technical analysis program code detailed programming and reports specifications program design writing and/or generating code and conducting tests
• Developing and maintaining system design models technical documentation and specifications
• 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
• Developing medical and clinical based systems
• Web performance optimization
• Various computing platforms operating systems database technology communication protocols middleware and gateways
• Conducting technical analysis trouble-shooting 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 DEVOPS methodologies and technologies
• Knowledge and experience with leading-edge technologies design criteria including usability security and privacy for web and mobile applications.

General Skills - 30 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 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.