Remote Data Warehouse QA Engineer—SQL/BigQuery

ZENITH INFOTEK LLC; North Carolina; On-site; USD 110,000 - 140,000; Part time

Benefits offered by this job

Flexible work from home options

Job summary

ZENITH INFOTEK LLC in the United States (Remote) is seeking an experienced Data Warehouse Test Engineer to validate complex data pipelines using SQL, BigQuery and Python. You will design and execute tests for data quality, reconciliations, and API integrations in a fast-paced banking environment.

The role emphasizes QA across deposits, accounts, transactions, AML/KYC, fraud and compliance, with emphasis on regression and integration testing.

Qualifications

• 5+ years of QA/Test Engineering experience in data systems.
• Strong experience with functional, regression, integration and negative testing.
• Experience testing AI/ML, LLM, NL-to-SQL systems is a plus.
• REST API testing using Postman, pytest or similar tools.
• Advanced SQL and BigQuery Standard SQL.
• Experience with CTEs, Window Functions, Joins, Date Functions, STRUCT/ARRAY and complex queries.
• Solid Data Warehouse and Data Quality Testing experience.
• Data reconciliation and validation experience.
• Strong Python scripting/automation skills.
• Clear and detailed defect reporting.

Skills

QA/Test Engineering

Functional Testing

Regression Testing

Integration Testing

Negative Testing

API Testing

SQL

BigQuery

Python scripting

Data Warehouse Testing

Data Quality Testing

Data Reconciliation

Defect Reporting

Banking Domain Knowledge

Deposits

Accounts

Transactions

AML/KYC

Fraud

Compliance

Analytical Skills

Tools

Postman

pytest

SQLAlchemy

BigQuery SDK

Cloud Run

Job description

ZENITH INFOTEK LLC in the United States (Remote) is seeking an experienced Data Warehouse Test Engineer to validate complex data pipelines using SQL, BigQuery and Python. You will design and execute tests for data quality, reconciliations, and API integrations in a fast-paced banking environment.

The role emphasizes QA across deposits, accounts, transactions, AML/KYC, fraud and compliance, with emphasis on regression and integration testing.