Senior Data QA / Tester

Valiant Technologies LLC; Sunnyvale (CA); On-site; USD 140,000 - 180,000; Full time

Job summary

Valiant Technologies LLC in Sunnyvale, CA is seeking a Senior Data QA / Tester to validate modern data pipelines and transformation frameworks built on Snowflake and dbt. The role focuses on ensuring data accuracy, completeness, reliability, and quality across all transformations, collaborating with data engineering teams.

The ideal candidate brings deep SQL-based testing expertise, hands-on dbt testing, and experience building automated data testing frameworks in Python.

Qualifications

• 10+ years of experience in Data Testing / Data QA / Data Engineering Validation roles.
• Strong SQL expertise with experience writing complex validation queries.
• Hands-on experience testing dbt-based transformations, including schema tests, custom tests, models, snapshots, and transformation validation.
• Understanding of dbt project structure and workflows.
• Strong Snowflake experience, including data validation, reconciliation, micro-partitions, incremental loads, query behavior, and large-scale datasets.
• Experience building automated data testing frameworks using Python and SQL.
• Hands-on experience with Git workflows, version control, pull requests, and code reviews.

Responsibilities

• Validate data pipelines and transformations built on Snowflake and dbt.
• Ensure accuracy, completeness, reliability, and quality of data transformations.
• Collaborate with data engineering teams to validate ingestion, transforms, and data quality.

Skills

Data QA

SQL

dbt testing

Python

Git

Snowflake

Data validation

Tools

dbt

Snowflake

Fivetran

Job description

• We are seeking a Senior Data QA / Tester with strong hands-on experience in validating modern data pipelines and transformation frameworks built on Snowflake and dbt.
• This role is responsible for ensuring the accuracy, completeness, reliability, and quality of data pipelines and transformations developed by data engineering teams.
• The ideal candidate brings deep experience in data validation, SQL-based testing, dbt testing frameworks, and automation.
• Experience with Fivetran-based ingestion validation is a plus, but the primary focus is testing Snowflake and dbt-based transformations.

Required Qualifications:

• 10+ years of experience in Data Testing / Data QA / Data Engineering Validation roles.
• Strong SQL expertise with experience writing complex validation queries.
• Hands-on experience testing dbt-based transformations, including schema tests, custom tests, models, snapshots, and transformation validation.
• Understanding of dbt project structure and workflows.
• Strong Snowflake experience, including data validation, reconciliation, micro-partitions, incremental loads, query behavior, and large-scale datasets.
• Experience building automated data testing frameworks using Python and SQL.
• Hands-on experience with Git workflows, version control, pull requests, and code reviews.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.