Automation Engineer - API/Data/SQL

PLATO; United States; Hybrid; USD 120,000 - 180,000; Full time

Job summary

PLATO is seeking a senior test automation engineer to build automated checks ensuring API, data pipeline, transformation, and database reliability.

You will create reusable test frameworks in Python, verify data and interface behavior, and integrate test runs with delivery pipelines to provide clear quality evidence for teams.

The role supports remote work with hybrid options for those near an office, and requires strong Python, SQL, and data testing experience.

Qualifications

• At least five years of test automation experience, ideally on enterprise data integration work.
• At least five years building reusable automation frameworks with advanced Python.
• Strong experience with Python, Pytest, Playwright, Requests or HTTPX, SQL, and Pandas or PySpark.
• Familiarity with Postman/Newman, Azure DevOps Repos and Pipelines, Azure Data Factory, and Databricks.
• Knowledge of Kafka or Event Hub, JFrog Artifactory, and Allure or a similar reporting tool.
• Current Government of Canada Secret clearance at the time of application.

Responsibilities

• Automate validation for APIs, ETL pipelines, data transformations, database reconciliation, and regression scenarios.
• Develop reusable automation frameworks in Python and perform SQL-based checks.
• Verify schemas, interface contracts, and batch or event-driven data flows.
• Integrate tests into CI/CD pipelines and follow Git branching and code review practices.
• Create logging, reporting, and execution evidence for test results.

Skills

Test automation

Python

Pytest

Playwright

SQL

Pandas/PySpark

API testing

CI/CD

Azure DevOps

Databricks

Tools

Postman/Newman

Azure DevOps Repos & Pipelines

Azure Data Factory

Databricks

Kafka

JFrog Artifactory

Allure

Job description

Role overview

Build automated checks that help keep APIs, data pipelines, transformations, and databases reliable. You’ll create reusable test frameworks, verify data and interface behavior, and connect test runs to delivery pipelines so teams can review quality evidence and results.

Responsibilities

• Automate validation for APIs, ETL pipelines, data transformations, database reconciliation, and regression scenarios.


• Develop reusable automation frameworks in Python and perform SQL-based checks.


• Verify schemas, interface contracts, and batch or event-driven data flows.


• Integrate tests into CI/CD pipelines and follow Git branching and code review practices.


• Create logging, reporting, and execution evidence for test results.

Requirements

• At least five years of test automation experience, ideally on enterprise data integration work.


• At least five years building reusable automation frameworks with advanced Python.


• Strong experience with Python, Pytest, Playwright, Requests or HTTPX, SQL, and Pandas or PySpark.


• Familiarity with Postman/Newman, Azure DevOps Repos and Pipelines, Azure Data Factory, and Databricks.


• Knowledge of Kafka or Event Hub, JFrog Artifactory, and Allure or a similar reporting tool.


• Current Government of Canada Secret clearance at the time of application.

Benefits and work setup

The role can be performed remotely. Candidates located near an office are expected to work in a hybrid arrangement.