We are looking for a QA Data Automation Engineer to join our Data Team in a dynamic and challenging role, providing critical test coverage for Orca’s data pipelines, reporting layers, and analytics solutions.
In this role, you will be responsible for validating data integrity end-to-end — from raw ingestion and transformation layers to dashboards and downstream consumers. You will design and maintain automated tests to ensure accurate, reliable, and scalable data systems.
Key Responsibilities
- Develop and maintain automated QA tests for data pipelines, transformations, and data products.
- Perform and execute manual QA testing such as functional, regression, and sanity testing of applications, dashboards, and backend systems.
- Validate data flow across the system, including: ingestion, transformations, reports/dashboards.
- Perform data quality testing (completeness, consistency, accuracy, timeliness, schema validation).
- Write and execute SQL-based tests to validate logic, joins, aggregations, metrics, and anomalies.
- Build automation frameworks and validation scripts using Python.
- Work closely with Data Engineers and Analytics/BI stakeholders to define test coverage and acceptance criteria.
- Investigate failures and data issues, providing clear RCA and actionable bug reports.
- Document test plans, test scenarios, expected results, and automation coverage.
- Track issues in Jira, including reproducible steps and supporting evidence.
- Continuously improve QA processes for better monitoring, reliability, and faster releases.