Job Description

Description

NOTE

Assignment Type:

This position is currently listed as "Hybrid" and

consultants will be required to work onsite at the work location 3 days a week and 2 days from home.

The details of this arrangement will be confirmed with the Hiring Manager.

Extension/Amendment Attestation:

Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on March 31, 2026. HSC may exercise its option(s) to extend a SOW beyond March 31, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW.



============================================

Responsibilities:

Perform functional and non-functional system testing of the Health Data Utility (HDU) Provide ongoing testing for the routine and incident management of HDU Test bug fixes in reporting as per defects found by business and as per HDU IRC project Create complete system testing documentation and artefacts, including test plans, test cases, test scripts, automated test scripts, test results reports, defect logs Transform functional, business, and system knowledge into effective test case planning and execution. Create test data according to the test plan; analyze testing results and retesting until expected results are obtained; perform reviews with users and ensures client acceptability levels are met (e.g. participating in walk throughs); recommend changes to ensure acceptable testing results; retest all criteria in a live environment and recommend user sign off for implementation. Work closely with developers, architects, product owners, and others in establishing effective test plans based on feature documentation. Apply QA and technical expertise and engage other expertise to track and resolve testing and production issues and other IT related problems with quality deficiencies and maintain client service integrity. SKILLS

EXPERIENCE REQUIREMENTS

PUBLIC SECTOR EXPERIENCE





5+ YEARS OF EXPERIENCE WORKING WITH

FEDERAL/PROVINCIAL/BROADER PUBLIC-SECTOR HEALTHCARE PROVIDERS


?KNOWLEDGE OF PUBLIC SECTOR ENTERPRISE

ARCHITECTURE ARTIFACTS (OR SIMILAR), PROCESSES AND PRACTICES, AND ABILITY TO

PRODUCE TECHNICAL DOCUMENTATION THAT COMPLY WITH INDUSTRY STANDARD PRACTICES


?IN-DEPTH KNOWLEDGE OF INDUSTRY STANDARD

SUCH AS PROJECT MANAGEMENT INSTITUTE (PMI) AND PUBLIC SECTOR I&IT PROJECT

MANAGEMENT METHODOLOGIES.


?KNOWLEDGE AND EXPERIENCE WITH PUBLIC

SECTOR HEALTH RELATED PROJECTS


?KNOWLEDGE AND UNDERSTANDING OF MINISTRY

POLICY AND IT PROJECT APPROVAL PROCESSES AND REQUIREMENTS PUBLIC SECTOR

EXPERIENCE ADOPTING AND ADHERING TO PUBLIC SECTOR UNIFIED I&IT PROJECT

METHODOLOGY, PUBLIC SECTOR ENTERPRISE ARCHITECTURE AND PUBLIC SECTOR GATING

PROCESS, AND OPS STANDARD SYSTEMS DEVELOPMENT METHODOLOGIES


?EXPERIENCE WITH LARGE COMPLEX IT

HEALTH-RELATED PROJECTS.


5

POINTS




QA AND SYSTEMS TESTING KNOWLEDGE AND EXPERIENCE




7+ YEARS OF EXPERIENCE IN

THE FOLLOWING:


AS A LEAD SYSTEMS TESTING/QA SPECIALIST FOR

VARIOUS STREAMS OF WORK, PROVIDING GUIDANCE AND OVERSIGHT TO JUNIOR TESTERS,

AND PLANNING, ORGANIZING AND IMPLEMENTING TESTING EFFORTS (INCLUDES

PREPARATION OF TEST PLANS AND COORDINATION OF TEST EXECUTION)


KNOWLEDGE AND UNDERSTANDING OF TESTING

METHODS IN AN OBJECT-ORIENTED ENVIRONMENT


ALL STAGES OF SYSTEM TESTING, INCLUDING

STRATEGY, SELECTION OF TESTING TOOLS, TEST PLANNING, PREPARING TEST CASES AND

TEST DATA, MANUAL AND AUTOMATED TEST EXECUTION AND DEFECT LOGGING AND

TRACKING


EXPERIENCE WITH A VARIETY OF TESTING

SYSTEMS, INCLUDING CLINICAL SYSTEMS TESTING, MISSION CRITICAL SYSTEMS

TESTING, AND TESTING HIGH VOLUME TRANSACTIONAL SYSTEMS IN HIGHLY AVAILABLE

ENVIRONMENTS


KNOWLEDGE AND EXPERIENCE OF STRUCTURED

METHODOLOGIES FOR THE DEVELOPMENT, DESIGN, IMPLEMENTATION, MAINTENANCE OF

APPLICATIONS


PERFORMING FUNCTIONAL AND NON-FUNCTIONAL

SYSTEM TESTING OF THE FOLLOWING: COMMERCIAL OFF-THE-SHELF (COTS) SOLUTIONS

INCLUDING TESTING OF PATCHES, NEW RELEASES, ACCEPTANCE TESTING OF ENHANCEMENT

REQUEST FUNCTIONALITY FOR MODULES OF THE PRODUCT AND OTHER ENHANCEMENTS, AND

REGRESSION TESTING FOR IMPLEMENTATION; IN HOUSE WEB APPLICATIONS; HL7-FHIR

BASED WEBSERVICES (RESTFUL/JSON/XML); APPLICATION PROGRAMMING INTERFACES

(API); REPORTING SOLUTIONS; INTEGRATION COMPONENTS, EXTENSIONS, AND

ENHANCEMENTS


CREATING COMPLETE SYSTEM TESTING

DOCUMENTATION AND ARTEFACTS SUCH AS: TEST STRATEGIES, TEST PLANS, TEST USE

CASES, TEST SCRIPTS


DEVELOP AUTOMATED TEST SCRIPTS (USING TOOLS

SUCH AS SELENIUM FRAMEWORK)


API TESTING TOOLS TO QUERY AND TEST

INTERFACES AT THE MESSAGING LAYER


WEB SERVICE QUERIES USING TOOLS SUCH AS

RATIONAL CLEARQUEST, SOAP-UI, POSTMAN OR VIA PROGRAMMING LANGUAGES


KNOWLEDGE AND EXPERIENCE WITH INFORMATION

RETRIEVAL PACKAGES, AND DATA QUERIES AND AD-HOC QUERIES (USING SQL) AND OTHER

QUERY LANGUAGES


PERFORMING ACCESSIBILITY TESTING TO

WEBSITES, WEB CONTENT AND MOBILE APPLICATIONS TO CONFORM TO THE WORLD WIDE

WEB CONSORTIUM WEB CONTENT ACCESSIBILITY GUIDELINES (WCAG) 2.0


TOOLS TO SUPPORT WEB ACCESSIBILITY TESTING

IN SUPPORT OF AODA LEGISLATION


TEST RESULTS REPORTS, INCLUDING PERFORMANCE

AND SECURITY TESTING RESULTS, FOR USE IN DEFECT REVIEWS WITH CLIENTS,

PARTNERS AND PROJECT TEAM


BUSINESS INTELLIGENCE (BI) SOLUTION TO PLAN,

PREPARE, AND EXECUTE TESTING OF BI SOLUTION, INCLUDING DATA SETUP/INTEGRATION

AND VALIDATING DATA IN THE BI SOLUTION ACCESSED THROUGH PREDEFINED ANALYTICAL

REPORTS, AD-HOC REPORTING TOOLS AND DASHBOARDS TO ENSURE ACCURACY,

COMPLETENESS, AND DATA INTEGRITY OF THE SOLUTION


VALIDATING SUCCESSFUL DEPLOYMENT OF

RELEASES IN PRODUCTION ENVIRONMENTS, PREPARING REPORTS ON TESTING RESULTS


PERFORMING BUSINESS SCENARIOS AND

CROSS-SYSTEM INTEGRATION TESTING


REVIEWING AND PROVIDING INPUT TO TECHNICAL

AND BUSINESS REQUIREMENTS FROM A TESTING PERSPECTIVE, INCLUDING BUSINESS

INTELLIGENCE SOLUTIONS


EXECUTING AUTOMATED TESTS SCRIPTS


KNOWLEDGE AND EXPERIENCE WORKING IN

TRADITIONAL AND AGILE TEAMS USING STANDARD AND DEVOPS PROCESSES AND TOOLS


KNOWLEDGE AND EXPERIENCE USING AT LEAST ONE

PROGRAMMING LANGUAGE


KNOWLEDGE AND EXPERIENCE WITH ALL PHASES OF

THE SYSTEMS DEVELOPMENT LIFE CYCLE (SDLC)


REVIEWING BUSINESS AND TECHNICAL

DOCUMENTATION FROM A TESTING PERSPECTIVE TO IDENTIFY ISSUES EARLY IN THE SDLC


KNOWLEDGE AND

UNDERSTANDING OF INFORMATION MANAGEMENT PRINCIPLES, CONCEPTS, POLICIES AND

PRACTICES.

5+ YEARS DEMONSTRATED

EXPERIENCE IN PERFORMING SYSTEMS TESTING AND QUALITY ASSURANCE ON:


SCALABLE MEDALLION DATA LAKEHOUSE

ARCHITECTURES.


DATA INGESTION, TRANSFORMATION, AND

CURATION USING DELTA LAKE AND DATABRICKS.


INTEGRATING STRUCTURED AND UNSTRUCTURED

DATA SOURCES INTO STAR/SNOWFLAKE SCHEMAS.


COMPLEX ETL/ELT PIPELINES USING AZURE DATA

FACTORY (ADF), DATABRICKS (PYSPARK, SQL, DELTA LIVE TABLES), AND DBT.


ORCHESTRATED WORKFLOWS AND JOB SCHEDULING

IN AZURE ENVIRONMENTS.


RELATIONAL (SQL SERVER, SYNAPSE,

POSTGRESQL) AND DIMENSIONAL MODELING.


ADVANCED SQL QUERY OPTIMIZATION, INDEXING,

PARTITIONING, AND DATA REPLICATION STRATEGIES.


APACHE SPARK, DELTA LAKE, AND DISTRIBUTED

COMPUTING FRAMEWORKS IN AZURE DATABRICKS.


PARQUET, ORC, AND JSON FORMATS FOR

OPTIMIZED STORAGE AND RETRIEVAL.


AZURE DATA LAKE STORAGE (ADLS), AZURE

SYNAPSE ANALYTICS, AZURE SQL, EVENT HUBS, AND AZURE FUNCTIONS.


STRONG UNDERSTANDING OF CLOUD SECURITY,

RBAC, AND DATA GOVERNANCE.


PYTHON (PYSPARK), SQL, AND POWERSHELL FOR

DATA ENGINEERING WORKFLOWS.


CI/CD AUTOMATION (AZURE DEVOPS, GITHUB

ACTIONS) FOR DATA PIPELINES.


DATA LINEAGE, CATALOGING, METADATA

MANAGEMENT, AND DATA QUALITY FRAMEWORKS.


UNITY CATALOG FOR MANAGING PERMISSIONS IN

DATABRICKS ENVIRONMENTS.


POWER BI (DAX, DATA MODELING, PERFORMANCE

TUNING).


INTEGRATING POWER BI WITH AZURE SYNAPSE AND

DATABRICKS SQL WAREHOUSES.


FAMILIARITY WITH MLFLOW, AUTOML, AND

EMBEDDING AI-DRIVEN INSIGHTS INTO DATA PIPELINES.


60 POINTS




LOGGING, TRACKING AND DEFECT REPORTING




10+ YEARS OF EXPERIENCE WITH:


?IDENTIFYING AND DOCUMENTING ISSUES

AND RISKS


?CREATING AND MAINTAINING DEFECT LOGS AND

DEFECT SUMMARY REPORTS (USING TOOLS SUCH AS AZURE DEVOPS, JIRA OR CONFLUENCE, TEST RAIL)


?UPDATING TASKS AND PROJECT STATUS


?PARTICIPATING IN QA AND CROSS FUNCTIONAL

TEAM MEETINGS


?PRIORITIZING TEST EXECUTION BASED ON

BUSINESS PRIORITY, DEFECT PATTERNS, AND AVAILABLE TESTING TIME


?DEALING CREATIVELY WITH PROBLEMS STEMMING

FROM SHARED RESOURCES, SUCH AS TEST ENVIRONMENTS AND TEST DATA


ACTIVELY PARTICIPATING IN WALKTHROUGHS AND

TRIAGE SESSIONS.


25 POINTS

GENERAL SKILLS

PROVEN TECHNICAL LEADERSHIP SKILLS, WITH

ABILITY TO IDENTIFY AREAS FOR IMPROVEMENT, AND RECOMMEND SOLUTIONS


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.


10 POINTS





SUPPLIER COMMENTS

CLOSING DATE - 2025-03-13, 4:30 P.M.

MAXIMUM NUMBER OF SUBMISSIONS - ONE (1)

HYBRID - CANDIDATE MUST BE ABLE TO WORK 3 DAYS ONSITE AND 2 DAYS REMOTE

MUST HAVES -



7+ YEARS OF EXPERIENCE IN THE FOLLOWING:
ALL STAGES OF SYSTEM TESTING, INCLUDING STRATEGY, SELECTION OF TESTING TOOLS, TEST PLANNING, PREPARING TEST CASES AND TEST DATA, MANUAL AND AUTOMATED TEST EXECUTION AND DEFECT LOGGING AND TRACKING

CREATING COMPLETE SYSTEM TESTING DOCUMENTATION AND ARTEFACTS SUCH AS: TEST STRATEGIES, TEST PLANS, TEST USE CASES, TEST SCRIPTS

DEVELOP AUTOMATED TEST SCRIPTS (USING TOOLS SUCH AS SELENIUM FRAMEWORK)

PERFORMING ACCESSIBILITY TESTING TO CONFORM TO (WCAG) 2.0

TEST RESULTS REPORTS, INCLUDING PERFORMANCE AND SECURITY TESTING RESULTS

VALIDATING SUCCESSFUL DEPLOYMENT OF RELEASES IN PRODUCTION ENVIRONMENTS, PREPARING REPORTS ON TESTING RESULTS

DATA INGESTION, TRANSFORMATION, AND CURATION USING DELTA LAKE AND DATABRICKS.

COMPLEX ETL/ELT PIPELINES USING AZURE DATA FACTORY (ADF), DATABRICKS (PYSPARK, SQL, DELTA LIVE TABLES), AND DBT.

APACHE SPARK, DELTA LAKE, AND DISTRIBUTED COMPUTING FRAMEWORKS IN AZURE DATABRICKS.

AZURE DATA LAKE STORAGE (ADLS), AZURE SYNAPSE ANALYTICS, AZURE SQL, EVENT HUBS, AND AZURE FUNCTIONS.

CI/CD AUTOMATION (AZURE DEVOPS, GITHUB ACTIONS) FOR DATA PIPELINES.

* DATA LINEAGE, CATALOGING, METADATA MANAGEMENT, AND DATA QUALITY FRAMEWORKS.