Automation Engineer - API/Data/SQL

Ottawa, ON
Hybrid
Posted Sep 23, 2026
1 position

$90,000–$110,000 / year

Opens an external site

Employment type: Full-time
Experience level: Senior · 5+ years
Posting language: English
Working hours: 40 hours per week

Job summary

Design and implement automated validation solutions for APIs, data pipelines, and database reconciliation. Integrate test suites with CI/CD pipelines and produce execution evidence and reporting to ensure platform reliability.

Job details

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. JOB SUMMARY Design and implement automated validation solutions for APIs, data pipelines, transformations, database reconciliation, and regression testing. Build reusable automation frameworks, integrate test suites with CI/CD pipelines, and produce execution evidence and reporting to support data quality and platform reliability. This job can be done fully remotely, however if the candidate is located near a PLATO office location hybrid work will be required. Current Government of Canada Secret clearance is required at the time of application. RESPONSIBILITIES * Develop automated validation for APIs, ETL/data pipelines, transformations, database reconciliation, and regression testing. * Build reusable automation frameworks using advanced Python development. * Perform SQL-based validation and reconciliation. * Validate schemas, contracts, and batch/event-driven interfaces. * Create automated reporting and logging solutions. * Integrate automated tests with CI/CD pipelines. * Follow Git branching and code review best practices. * Produce test execution evidence and reports. REQUIREMENTS * Minimum of 5 years of test automation experience, preferably in an enterprise level data integration project. * 5+ years of experience in building and implementing reusable automation frameworks using advanced Python development. * Advanced knowledge of the following technologies: * Python, Pytest, Playwright. * Requests or HTTPX. * Pandas or PySpark. * SQL. * Postman/Newman. * Azure DevOps Repos and Pipelines. * Microsoft Azure including: Azure Data Factory and Databricks. * Kafka/Event Hub. * JFrog Artifactory. * Allure or equivalent reporting tool. 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.

What you’ll do

Requirements

Requires a minimum of 5 years of test automation experience, specifically in building reusable frameworks using advanced Python. Candidates must possess advanced knowledge of SQL, Azure technologies, and modern testing tools like Pytest and Playwright.