Senior Data QA Engineer - Snowflake/dbt Validation

Cloud Analytics Technologies, LLC; Sunnyvale (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

Cloud Analytics Technologies, LLC in Sunnyvale, CA seeks a Senior Data QA/Tester to validate data pipelines and transformations built on Snowflake and dbt. You will ensure data accuracy, completeness, reliability, and overall quality across complex data workflows.

The ideal candidate has hands-on experience with SQL-based testing, dbt testing frameworks, and automation. Knowledge of Fivetran ingestion validation is a plus, with a primary focus on Snowflake transformations.

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 to ensure accuracy, completeness, reliability, and quality.
• Develop and run SQL-based tests and dbt framework tests for Snowflake pipelines.
• Build automated data testing frameworks using Python and SQL and maintain reusable test suites.

Skills

SQL testing

dbt testing

Data validation

Python

Git workflows

Automation

Complex SQL

Snowflake

Tools

Snowflake

dbt

Fivetran

Job description

Cloud Analytics Technologies, LLC in Sunnyvale, CA seeks a Senior Data QA/Tester to validate data pipelines and transformations built on Snowflake and dbt. You will ensure data accuracy, completeness, reliability, and overall quality across complex data workflows.

The ideal candidate has hands-on experience with SQL-based testing, dbt testing frameworks, and automation. Knowledge of Fivetran ingestion validation is a plus, with a primary focus on Snowflake transformations.