QA Automation Engineer

Job Title: QA Automation Engineer Location: Job Type: Full-time

We are looking for a detail-oriented and innovative QA Automation Engineer to design, develop, and execute automated testing solutions and comprehensive test plans for Source Systems and Business Data Products. The ideal candidate will have strong expertise in validating the integrity, accuracy, and consistency of enterprise data across multiple business domains.
This role is responsible for ensuring the quality of data processed through ETL pipelines and data modeling scripts across platforms such as Oracle, SQL Server, and Snowflake. The QA Automation Engineer will collaborate closely with data engineering, QA, and business teams to support scalable, reliable, and high-quality data delivery across the organization.

Design and Develop Automated Data Quality Tests:
Build reusable automated tests to validate data ingestion, transformations, and loading across Oracle, SQL Server, and Snowflake.
Verify data integrity, completeness, schema conformity, and business logic through all layers — from raw landing zone to curated data products.
Ensure End-to-End Data Pipeline Validation:
Automate testing for ETL/ELT processes, including data staging, cleansing, fact and dimension population, and final consumption layers.
Monitor transformations and data flows across platforms (Oracle → Snowflake, SQL Server → Snowflake, etc.).
Leverage Snowflake-Specific Testing Capabilities:
Utilize Snowflake's native SQL features (e.g., streams, tasks, time travel, variant types) in test development.
Automate regression and functional testing for Snowflake data models, stored procedures, and materialized views.
Extend or integrate automation frameworks compatible with Oracle, SQL Server, and Snowflake.
Apply data validation tools to verify transformation accuracy.
Track execution, report defects, and ensure traceability across automated and manual test cases.
Collaborate Across Data Engineering and Modeling Teams:
Work with data engineers, modelers, and analysts to define test criteria for ingestion jobs, business logic, and reporting outputs.
Support CI/CD and Test Automation in Production Pipelines:
Integrate automated tests into CI/CD workflows.
Validate data integrity during production releases, schema updates, and migrations.
Develop Monitoring and Alerting for Data Quality:
Create dashboards or automated reports for monitoring data quality trends.
Document test strategies, data quality standards, and platform-specific practices.

Bachelor’s or Master’s degree in computer science, Data Engineering, or a related field.
~ Experience:
~3 to 5 years of experience in QA automation, with a strong focus on testing data pipelines, ETL/ELT processes, and data quality validation across platforms such as Oracle, SQL Server, and Snowflake.
~ Proven experience in leading small teams or mentoring junior engineers.
~ Strong expertise in QA practices for data platforms, including designing automated quality frameworks, validating data pipelines, and risk-based testing.
~ Proficiency in automated testing strategies, TestRail for test management, Snowflake QA automation features, and scripting/CI/CD tools to maintain system accuracy and efficiency.
~ Opportunity to work on challenging and innovative projects.
Competitive salary and benefits package.
A chance to make a significant impact by shaping the future of data-driven solutions.

Logic Pursuits provides companies with innovative technology solutions for everyday business problems. Our passion is to help clients become intelligent, information-driven organizations, where fact-based decision-making is embedded into daily operations, which leads to better processes and outcomes. Our team combines strategic consulting services with growth-enabling technologies to evaluate risk, manage data, and leverage AI and automated processes more effectively. With deep, big four consulting experience in business transformation and efficient processes, Logic Pursuits is a game-changer in any operations strategy.

---