Job #:

9940

Division:

Information Technology Services

Vacancy Type:

Full-time Permanent

Affiliation:

Union: CUPE 79

Contract Length:

Grade:

TCHC 7

of Vacancies:

1

Salary/Hourly Range:

42.71 - 46.82

Hiring range/wage:

42.71

Work Details (Days/hours):

Monday to Friday, 35 hours/week

Posted Date:

9/22/25

Existing or New:

New

Deadline to Apply:

10/6/25

What we offer

In addition to competitive wages and a rewarding career where you can truly make a difference, we offer a comprehensive compensation package that meets the various needs of our diverse employees, including:

• Three Weeks paid annual vacation days, increasing with years of service;
• Defined benefit pension plan with OMERS, includes 100-per-cent employer matching;
• Health and dental benefits;
• Employee and family assistance program;
• Maternity and parental leave top up (93% of base salary);
• Training and development programs including tuition reimbursement of $1500 per calendar year.
• Fitness membership discount;

This job offers the opportunity to work from home as part of a hybrid work arrangement. This arrangement will allow you to work some days at a TCHC work location and the rest of the time from home. The amount of time required to work at a TCHC work location is flexible, while considering operational and service delivery requirements.

Make a difference

Reporting to the Manager of Business Intelligence within the ITS department of TCHC, the Quality Assurance Data Specialist supports both existing business software systems and develops new ones, as authorized by client business groups through ITS management. This position is involved in all areas of BI systems development, from business concept to implementation, and will assist the BI team to build out the new BI corporate analytics, reporting, and dashboards using Power BI. The Quality Assurance Data Specialist will provide data quality assurance as well as BI validation.

What you'll do

• Analyze systems requirements, use cases, architecture and design documents to gain overall understanding of the new solution to determine the appropriate level of Quality Assurance testing required.
• Develop Test Plans and Test Cases, Test Scripts, Requirement Traceability Matrix (RTM).
• Configure Test Environments and create Test Data.
• Perform thorough and accurate testing and provide approvals during Data Warehouse development, integration, release, regression and maintenance phases to ensure that software deliverables meet functional and design specifications and requirements.
• Execute black/white/integration testing, exploratory/heuristic, end-to-end, and any other testing approaches necessary to ensure effective test coverage.
• Analyze test results and document defects as part of the defect-tracking framework.
• Analyze issues reported through incident and problem management workflows, determine root causes, and provide detailed reports. Provide enhancement suggestions to development team;
• Remain up to date with testing technologies/methodologies, QA industry standards, principles and practices.
• Partner with management to enhance quality and process standards to ensure on-time, efficient and high-quality QA results
• Responsible for reviewing statistics to help TCHC make better business decisions.
• Collect statistical analyses of data.
• Design data administrative policy;
• Create test cases and execute them.
• Deliver daily defect reports with up-to-date information.
• Validate resolved issue/defects.
• Create and maintain up to date test results.
• Support business resources in data validation activities, if needed.

What you'll need

• University degree in computer science or a relevant technical discipline.
• 7 years’ experience performing data quality assurance work in data warehouse environment
• 5 years of proven experience in developing QA test scripts in data warehouse environment with execution and analysis
• 7 years of experience in data warehousing, analytics, ETL and dimension modeling

Preferred experience:

• 5 years of experience in data management, data migration, data cleansing and synchronization
• 5 years of experience in working with business clients directly by consulting with them to gather requirements to deliver projects
• 3 – 5 years of experience with master data management
• 3 – 5 years of experience working with validation of CDC data using CDC framework
• 5+ years of experience with IDE tools such as Visual Studio, Eclipse or Jupyter Notebook
• Experience working with various forms of data infrastructure including SQL Server, Hive, Impala and column-oriented databases such as Cassandra, MongoDB etc.
• ITIL certification

What’s next

Once you apply, we’ll review your resume and contact you if your skills and experience match the qualifications for the role. If you are selected to move forward, the process will include one or more interviews and/or assessments and reference checks.

Candidates for unionized positions must score a minimum of 70% to pass any interview or assessment and be considered for the next stage of the recruitment process. Successful candidates will be determined based on score and where applicable, union seniority. Not all candidates who score 70% or higher will automatically proceed to the next stage of the recruitment process as this will be dependent on the number of candidates and number of available roles.