Who We Are
PLATO is Canada’s largest Indigenous-owned software testing and technology services company. For nearly 30 years, our expert teams have helped our clients deliver reliable products that users enjoy interacting with.
Our 100% Canada‑based team brings deep experience in QA, software testing, and IT services, along with a shared commitment to collaboration, mentorship, and continuous improvement. We’re a team that shows up for each other, whether that’s tackling complex client challenges or helping colleagues grow through coaching and knowledge‑sharing.
As Canada’s largest Indigenous‑owned software testing company, we’re proud of our roots and our mission to build a stronger, more inclusive technology workforce. At the same time, we warmly welcome applicants of all backgrounds and experiences who are passionate about quality, teamwork, and making an impact.
** Please note: A current secret level Government of Canada Security Clearance is required at the time of application.
Position start date Dec 2026
This role could be done on a permanent or contract basis. Permanent employees located near a PLATO office location will be hybrid.
Job Summary
The SQL/Reconciliation Quality Engineer ensures the accuracy, completeness, and integrity of data across enterprise platforms. This role serves as a key quality assurance resource for data migration, conversion, and transformation initiatives, providing independent validation of data outcomes and supporting confidence in business and reporting data used for operational and strategic decision-making.
Responsibilities
Performs detailed source-to-target reconciliation across legacy systems, ingestion layers, and reporting stores to ensure data accuracy, completeness, and integrity.
Develops SQL and Python-based validation processes to support data migration, conversion, and transformation initiatives through comprehensive analysis, testing, and exception reporting.
Develop and execute validation routines for record counts, financial and business totals, duplicates, null values, referential integrity, and transformation accuracy.
Conduct data profiling and anomaly analysis to identify, investigate, and resolve data quality issues.
Perform aggregate and record-level comparisons to validate migration and conversion results.
Validate transformation rules and data movement processes.
Optimize queries and analyze large-volume datasets to support reconciliation activities.
Generate reconciliation evidence, document results, and report exceptions.
Partner with data, testing, and business teams to support successful implementation and data quality outcomes.
Requirements
Advanced SQL expertise.
Experience with source-to-target reconciliation, migration validation, and data quality testing.
Strong understanding of data profiling, anomaly analysis, duplicate testing, referential integrity testing, and transformation-rule verification.
Experience performing large-volume data analysis and reconciliation.
Proficiency with SQL Server or Azure SQL and Databricks SQL.
Proficiency with Python, including Pandas and/or PySpark.
Experience working with Azure Data Lake Storage (ADLS) and Delta Lake.
Experience using Azure DevOps.
Advanced Excel skills for controlled reconciliation analysis and reporting.
Strong analytical, problem-solving, and documentation skills.
Work With Us
At PLATO, we believe that great work happens when people feel supported, connected, and challenged in the right ways. You’ll be part of a collaborative environment where experienced professionals share knowledge, mentor others, and contribute to solving complex, real‑world client projects.
We are committed to inclusive hiring practices and encourage applications from individuals of all backgrounds, including women, persons with disabilities, visible minorities, and Indigenous peoples. If you require accommodation at any stage of the recruitment process, we’re here to support you.
PLATO respectfully acknowledges that we operate on treaty territories, unceded First Nations and Inuit territories, and within Métis homelands. We honour the long history of these lands and actively work toward reconciliation between Indigenous and non‑Indigenous peoples on Turtle Island.
