{"schemaVersion":"jobsearcher.job.v1","id":"a54f5dccded91ca5ef96d5af","url":"https://jobsearcher.com/jobs/a54f5dccded91ca5ef96d5af","canonicalUrl":"https://jobsearcher.com/jobs/a54f5dccded91ca5ef96d5af","title":"Data Warehouse Test Engineer","description":"Data Warehouse Test EngineerLocation: Dearborn, MI (Onsite)\r\nRequired Skills:\r\nTest Engineering: 5+ years designing and executing functional, regression, integration, and negative test suites.\r\nExperience with AI/ML system testing or conversational AI testing strongly preferred.\r\nAPI Testing: REST API testing using tools such as Postman, pytest, or equivalent. Experience validating JSON schemas, HTTP error codes, and streaming responses (SSE).\r\nSQL / 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.\r\nDefect Documentation: Ability to write precise, reproducible defect reports that include expected SQL, actual SQL, expected result set, and actual result set.\r\nBank 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.\r\nCritical 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.\r\nPreferred Skills:\r\nExperience testing LLM-based or NL-to-SQL systems (Cortex, Looker, ThoughtSpot, or similar)\r\nFamiliarity with GCP services: BigQuery, Cloud Run, Firestore, Dataplex, IAP\r\nPython scripting for test automation (pytest, SQLAlchemy, google-cloud-bigquery SDK)\r\nSCD2 / data warehousing concepts (bitemporal tables, slowly changing dimensions)\r\nRegulatory knowledge: GLBA, FCRA, BSA/AML, Client 239, SOX data quality\r\nExperience with data quality testing and data reconciliation\r\nKnowledge Graph or ontology concepts\r\nAutomotive finance domain knowledge\r\nThe pay range for this role is ***- *** per annum including any bonuses or variable pay. *** also offers benefits like medical, vision, dental, life, disability insurance and paid time off (including holidays, parental leave, and sick leave, as required by law).\r\n*** is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin, or disability. All applicants will be evaluated solely on the basis of their ability, competence, and performance of the essential functions of their positions with or without reasonable accommodations. Reasonable accommodations also are available in the hiring process for applicants with disabilities.","company":"Yantran","rawCompany":"yantran","city":"Dearborn","state":"MI","isRemote":false,"isActive":false,"createdAt":"2026-08-07T01:30:38.259Z","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 EngineerLocation: Dearborn, MI (Onsite)\r\nRequired Skills:\r\nTest Engineering: 5+ years designing and executing functional, regression, integration, and negative test suites.\r\nExperience with AI/ML system testing or conversational AI testing strongly preferred.\r\nAPI Testing: REST API testing using tools such as Postman, pytest, or equivalent. Experience validating JSON schemas, HTTP error codes, and streaming responses (SSE).\r\nSQL / 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.\r\nDefect Documentation: Ability to write precise, reproducible defect reports that include expected SQL, actual SQL, expected result set, and actual result set.\r\nBank 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.\r\nCritical 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.\r\nPreferred Skills:\r\nExperience testing LLM-based or NL-to-SQL systems (Cortex, Looker, ThoughtSpot, or similar)\r\nFamiliarity with GCP services: BigQuery, Cloud Run, Firestore, Dataplex, IAP\r\nPython scripting for test automation (pytest, SQLAlchemy, google-cloud-bigquery SDK)\r\nSCD2 / data warehousing concepts (bitemporal tables, slowly changing dimensions)\r\nRegulatory knowledge: GLBA, FCRA, BSA/AML, Client 239, SOX data quality\r\nExperience with data quality testing and data reconciliation\r\nKnowledge Graph or ontology concepts\r\nAutomotive finance domain knowledge\r\nThe pay range for this role is ***- *** per annum including any bonuses or variable pay. *** also offers benefits like medical, vision, dental, life, disability insurance and paid time off (including holidays, parental leave, and sick leave, as required by law).\r\n*** is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin, or disability. All applicants will be evaluated solely on the basis of their ability, competence, and performance of the essential functions of their positions with or without reasonable accommodations. Reasonable accommodations also are available in the hiring process for applicants with disabilities.","datePosted":"2026-08-07T01:30:38.259Z","dateModified":"2026-08-07T01:30:38.259Z","hiringOrganization":{"@type":"Organization","name":"Yantran","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Dearborn","addressRegion":"MI","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"a54f5dccded91ca5ef96d5af"},"url":"https://jobsearcher.com/jobs/a54f5dccded91ca5ef96d5af"}}