QA Engineer (Data) -#3040 (Remote)

CES is a company with over 26 years of experience in delivering software product development and quality engineering services. They are seeking a QA Engineer (Data) to ensure data quality and integrity across their enterprise HCM data platform by designing and executing test strategies for data pipelines and transformations.

Responsibilities:

• Design and execute data validation test cases for ETL/ELT pipelines from source (SQL Server) to target (Snowflake)
• Validate data transformations across medallion architecture layers (Bronze → Silver → Gold)
• Perform source-to-target reconciliation testing including record counts, aggregations, and data accuracy checks
• Test CT (Change Tracking) and incremental load scenarios for data completeness and correctness
• Validate SCD Type 1 and Type 2 implementations for historical data tracking
• Test Row-Level Security (RLS) implementations to ensure proper data access controls per persona
• Create and maintain SQL-based test scripts for automated data validation
• Perform regression testing when pipeline changes are deployed
• Validate data quality rules including null checks, referential integrity, duplicate detection, and business rule validations
• Test data lineage and ensure traceability from source to reporting layer
• Document test cases, test results, and defects in tracking tools
• Collaborate with data engineers to identify root causes and verify bug fixes
• Support UAT by preparing test data and validating business scenarios

Requirements:

• SQL: Strong SQL skills for writing complex queries, data comparison scripts, and validation logic (joins, aggregations, window functions, CTEs)
• Data Warehouse Concepts: Understanding of dimensional modeling, fact/dimension tables, star schema, and slowly changing dimensions
• ETL/ELT Testing: 2+ years of experience testing data pipelines, transformations, and data loads
• Data Quality Testing: Experience with source-to-target validation, data profiling, and reconciliation
• Snowflake: 1+ years hands-on experience querying and validating data in Snowflake
• Test Documentation: Experience creating test plans, test cases, and defect reports
• Test automation frameworks for data validation (Python, Great Expectations, dbt tests)
• Experience with CDC/Change Tracking based data ingestion testing
• BI Testing: Basic validation of reports/dashboards (Tableau)
• Git: Version control for test scripts
• Jira/Azure DevOps: Defect tracking and test management
• Performance testing for data pipelines