Senior Data QA / Tester

Machine Learning Technologies, LLC; Sunnyvale (CA); On-site; USD 140,000 - 190,000; Full time

Job summary

Machine Learning Technologies, LLC in Sunnyvale, CA seeks a Senior Data QA/Tester to validate data pipelines and transformations built on Snowflake and dbt. The role emphasizes data accuracy, completeness, reliability, and quality across pipelines developed by data engineering teams.

The ideal candidate has deep experience in data validation, SQL-based testing, dbt testing frameworks, and automation. Experience with Fivetran ingestion validation is a plus, but primary focus remains Snowflake/dbt

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, models, and snapshots.
• Understanding of dbt project structure and workflows.
• Strong Snowflake experience, including data validation and large-scale datasets.

Responsibilities

• Validate data pipelines and transformations built by data engineering teams.
• Develop automated data testing frameworks using Python and SQL.
• Perform ingestion validation (Fivetran) as a plus, with focus on Snowflake/dbt workflows.
• Collaborate with data engineers to ensure data quality across pipelines.

Skills

SQL

Python

Data validation

Tools

dbt

Snowflake

Fivetran

Git

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.