Automation Engineer - API/Data/SQL
- Ottawa, ON, Canada
- 407 2 St SW, Calgary, AB, T2P 2Y3, Canada
- Sault Ste. Marie, ON, Canada
- 1090 Homer St, Vancouver, BC, V6B 2W9, Canada
- Prince Albert, SK, Canada
- Regina, SK, Canada
- Gatineau, QC, Canada
- BC, Canada
- Winnipeg, MB, Canada
- Fredericton, NB, Canada
- Toronto, ON, Canada
- Halifax, NS, Canada
$90,000 to $110,000 CAD / year · Full-time
Applications open in a new tab.
Job details
- Pay
- $90,000 to $110,000 CAD / year
- Job type
- Full-time
- Posting language
- English
- Posted
Original job description
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 Reliability clearance (or higher) 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.
More about this job
Responsibilities
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.
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.
Skills
- Python
- Pytest
- Playwright
- SQL
- API Testing
- Data Pipelines
- ETL
- Azure DevOps
- Azure Data Factory
- Databricks
- Kafka
- Event Hub
- Git
- Postman
- Newman
- Automation Frameworks
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
- Engineering
Keywords
- Automation Engineer
- API
- Data Pipelines
- SQL
- Python
- Pytest
- Playwright
- ETL
- Database Reconciliation
- Regression Testing
- CI/CD
- Azure DevOps
- Azure Data Factory
- Databricks
- Kafka
- Event Hub
- Git
- Postman
- Newman
- JFrog Artifactory
- Allure
- Software Testing
- Quality Assurance
- Data Quality
- Schema Validation