{"schemaVersion":"jobsearcher.job.v1","id":"671fc3eb7e2a87c00c699ace","url":"https://jobsearcher.com/jobs/671fc3eb7e2a87c00c699ace","canonicalUrl":"https://jobsearcher.com/jobs/671fc3eb7e2a87c00c699ace","title":"Data Warehouse Test Engineer","description":"Data Warehouse Test Engineer at Dearborn, MI (Onsite) (Tech M)Job Title: Data Warehouse Test EngineerLocation: Dearborn, MI (Onsite)Required SkillsTest 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 / BigQuery: Advanced SQL authoring in BigQuery 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 hand-holding.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 SkillsExperience testing LLM-based or NL-to-SQL systems (Cortex, Looker, ThoughtSpot, or similar)Familiarity with Google Cloud Platform services: BigQuery, Cloud Run, Firestore, Dataplex, IAPPython 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 qualityExperience with data quality testing and data reconciliationKnowledge Graph or ontology conceptsAutomotive finance domain knowledge","company":"Transcend It Solutions","rawCompany":"transcend it solutions","city":"Dearborn","state":"MI","isRemote":false,"isActive":false,"createdAt":"2026-08-07T08:58:44.477Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1253.00","title":"Software Quality Assurance Analysts and Testers","slug":"software-quality-assurance-analysts-and-testers"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Data Warehouse Test Engineer","description":"Data Warehouse Test Engineer at Dearborn, MI (Onsite) (Tech M)Job Title: Data Warehouse Test EngineerLocation: Dearborn, MI (Onsite)Required SkillsTest 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 / BigQuery: Advanced SQL authoring in BigQuery 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 hand-holding.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 SkillsExperience testing LLM-based or NL-to-SQL systems (Cortex, Looker, ThoughtSpot, or similar)Familiarity with Google Cloud Platform services: BigQuery, Cloud Run, Firestore, Dataplex, IAPPython 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 qualityExperience with data quality testing and data reconciliationKnowledge Graph or ontology conceptsAutomotive finance domain knowledge","datePosted":"2026-08-07T08:58:44.477Z","dateModified":"2026-08-07T08:58:44.477Z","hiringOrganization":{"@type":"Organization","name":"Transcend It Solutions","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Dearborn","addressRegion":"MI","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"671fc3eb7e2a87c00c699ace"},"url":"https://jobsearcher.com/jobs/671fc3eb7e2a87c00c699ace"}}