Tailor your resume to this job

One click makes a copy of your resume for this role, scores it against the posting, and proposes edits line by line. Your default resume is never changed.

Job match score for this posting

Edits you accept or skip, no invented facts

Download it when it reads right: TXT free, PDF with Premium

Create a cover letter for this job

Upload your resume and we draft a letter for this exact role, tailored to what it asks for.

Tailored to this role

Based on your resume

Fully editable

Job Title: Data Warehouse Test Engineer
Location: Dearborn, MI (Remote)

Required Skills:

· Test Engineering: 5+ years designing and executing functional, regression, integration, and negative test suites. Experience with AI/ML system testing, or conversational AI testing strongly preferred.

· API Testing: REST API testing using tools such as Postman, pytest, or equivalent. Experience validating JSON schemas, HTTP error codes, and streaming responses (SSE).

· SQL / Big Query: Advanced SQL authoring in Big Query Standard SQL; window functions, CTEs, date arithmetic, SAFE functions, STRUCT/ARRAY handling. Must be able to independently write complex validation queries against a multi-table star schema.

· Defect Documentation: Ability to write precise, reproducible defect reports that include expected SQL, actual SQL, expected result set, and actual result set.

· Bank Domain Knowledge: Understanding of retail/commercial bank operations: deposits, accounts, transactions, AML, KYC, fraud, compliance. Ability to interpret bank KPIs and business rules without extensive handholding.

· Critical Thinking & Business Analysis: Ability to read a business question, understand the intended meaning, independently determine the correct SQL answer, and validate whether an AI system answered correctly, not just syntactically but semantically.

Preferred Skills:

· Experience testing LLM-based or NL-to-SQL systems (Cortex, Looker, ThoughtSpot, or similar)

· Familiarity with GCP services: BigQuery, Cloud Run, Firestore, Dataplex, IAP

· Python scripting for test automation (pytest, SQLAlchemy, google-cloud-bigquery SDK)

· SCD2 / data warehousing concepts (bitemporal tables, slowly changing dimensions)

· Regulatory knowledge: GLBA, FCRA, BSA/AML, BCBS 239, SOX data quality

· Experience with data quality testing and data reconciliation

· Knowledge Graph or ontology concepts

Automotive finance domain knowledge

This is a remote position.

ZENITH INFOTEK LLC

Employees 51-200 employees Industry IT Services and IT Consulting

View More Jobs From ZENITH INFOTEK LLC

ZENITH INFOTEK LLC

Data Warehouse Test Engineer

Tailor your resume to this job

Create a cover letter for this job

Automatically Apply to the Best Remote Jobs

Similar Jobs

Senior Expert Gameplay Engineer

Principal Software Engineer - AI Frameworks

Lead Information Security Engineer - Red Team

HCM Cloud Scrum Master

Sr. Principal Security, Risk, and OT Solution Architect

Senior Architect - Data Governance Platforms

ZENITH INFOTEK LLC

Data Warehouse Test Engineer

Tailor your resume to this job

Create a cover letter for this job

Automatically Apply to the Best Remote Jobs

Similar Jobs

Senior Expert Gameplay Engineer

Principal Software Engineer - AI Frameworks

Lead Information Security Engineer - Red Team

HCM Cloud Scrum Master

Sr. Principal Security, Risk, and OT Solution Architect

Senior Architect - Data Governance Platforms

Personalize your Remote Job Search in 3 Easy Steps!