Data Warehouse Test Engineer

Job overview

The Data Warehouse Test Engineer role is onsite in Dearborn, MI. Compensation is not specified. The position focuses on testing data warehouse and AI-enabled systems, with bank-domain knowledge relevant to interpreting business rules and KPIs. The role exists to verify that systems return correct, reliable results—not merely syntactically valid responses. Through functional, regression, integration, API, and data validation testing, the engineer helps identify defects and assess whether system outputs match business intent.

What you'll do

• Design and execute functional, regression, integration, and negative test suites
• test REST APIs and validate JSON schemas, HTTP error codes, and streaming responses
• write complex BigQuery Standard SQL validation queries against multi-table star schemas
• document reproducible defects with expected and actual SQL and result sets
• interpret banking operations, KPIs, and business rules to validate system answers semantically.

What we're looking for

Skills & competencies

data warehouse test engineer

software testing

bigquery

sql

rest api testing

ai/ml testing

conversational ai

data quality

banking domain

dearborn mi

yantran

Work arrangement

• Weekend coverage required

Why this role

AI/ML or conversational AI testing is strongly preferred. Preferred experience includes LLM or natural-language-to-SQL systems, GCP services, Python test automation, data warehousing, regulatory requirements, and data quality testing.

About the employer

Yantran LLC is hiring for this role. Industry: Computer Systems Design Services. Sector: 54.