Data Warehouse Test Engineer | BigQuery & ETL QA

Logic Era Inc.; Dearborn, Northern (MI, KY); Hybrid; USD 85,000 - 120,000; Full time

Job summary

Logic Era Inc. seeks a data quality and testing engineer to design and execute end-to-end ETL tests for bank data warehouse solutions across Bronze to OBT layers, ensuring data completeness, accuracy, and referential integrity.

Strong SQL/BigQuery validation and test automation experience are required. You will validate Gold-layer transformations, conduct data reconciliation, and support AML/transaction scenarios while implementing AI-assisted testing automation to improve coverage and

Qualifications

• Bachelor’s degree in Information Systems or Computer Science.
• 2–3 years of testing/ETL experience.
• Experience with SQL/BigQuery validation and data warehouse testing.

Responsibilities

• Develop and execute comprehensive test strategies for Bank Data Warehouse solutions across Bronze, Silver, Gold, OBT, and reporting layers.
• Execute ETL and data warehouse testing for data completeness, accuracy, timeliness, and referential integrity.
• Develop complex BigQuery SQL validation scripts using joins, CTEs, window functions, date functions, and aggregations.

Skills

Agil

Jira

Azure DevOps

PMP

CSM

Education

Bachelor’s degree in Information Systems or Computer Science

Job description

Logic Era Inc. seeks a data quality and testing engineer to design and execute end-to-end ETL tests for bank data warehouse solutions across Bronze to OBT layers, ensuring data completeness, accuracy, and referential integrity.

Strong SQL/BigQuery validation and test automation experience are required. You will validate Gold-layer transformations, conduct data reconciliation, and support AML/transaction scenarios while implementing AI-assisted testing automation to improve coverage and