Automation Engineer - API/Data/SQL

PLATO; Calgary; Remote; CAD 90,000 - 130,000; Full time

Job summary

PLATO is Canada’s largest Indigenous-owned software testing and technology services company, offering remote work with hybrid options near PLATO offices. The role focuses on designing and implementing automated validation solutions for APIs, data pipelines, and regression testing to support data quality and platform reliability.

The candidate will build reusable automation frameworks using Python, perform SQL-based validation, and integrate tests with CI/CD pipelines, while adhering to best

Qualifications

• Minimum 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 Python development.
• Proficient with Python, Pytest, Playwright and SQL-based validation.

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.

Skills

Automation testing

Python scripting

Data validation

SQL querying

Tools

Python

Pytest

Playwright

HTTP clients

SQL

Postman

Azure DevOps

Azure Data Factory

Databricks

Kafka

Artifactory

Allure

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.