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 is seeking a Senior Data QA/Tester to validate data pipelines and transformation frameworks built on Snowflake and dbt. You will ensure data accuracy, completeness, and reliability for data engineering outputs.

The ideal candidate has 10+ years in data testing, strong SQL, dbt testing experience, and hands-on Python automation; familiarity with Fivetran ingestion validation is a plus. This 13-month+ extension role requires US work authorization.

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 structures and workflows.
• Snowflake experience with data validation, reconciliation, and large datasets.
• Experience building automated data testing frameworks using Python and SQL.
• Hands-on experience with Git workflows, version control, and code reviews.

Responsibilities

• Validate data pipelines and transformation frameworks built on Snowflake and dbt.
• Ensure accuracy, completeness, reliability, and quality of data pipelines.
• Develop and maintain automated data tests and validation queries.
• Collaborate with data engineering teams to improve data quality.

Skills

SQL

dbt testing

Python

Data validation

Git workflows

Automation

Tools

Snowflake

dbt

Fivetran

Git

Job description

Job Overview

• Job ID: J53700
• Job Title: Senior Data QA / Tester
• Location: Sunnyvale, CA
• Duration: 13 Months + Extension
• Domain Exposure: Insurance
• Work Authorization: US Citizen,Green Card,OPT-EAD,CPT,H-1B,H4-EAD,L2-EAD,GC-EAD
• Client: To Be Discussed Later
• Employment Type: W-2, 1099, C2C

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.

Equal Opportunity Employer

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.