Back to results

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

Report this job