Data QA Engineer

ClearGrid Debt Collection LLC; Dubai; On-site; AED 150,000 - 230,000; Full time

Job summary

ClearGrid in the UAE is seeking a data quality/analytics engineer focused on QA across data pipelines and BI reports. You will validate lender files, ensure accurate reconciliation between MongoDB, telephony, and BigQuery, and safeguard dashboards before client delivery.

Strong SQL, Python, and dbt expertise are essential for this role. You will own test coverage, monitor schema drift, and drive the data incident process to prevent misstatements in reports and metrics used by lenders and

Qualifications

• 2+ years in data quality, analytics engineering, BI QA, or a data analyst role with quality ownership.
• Strong SQL with CTEs, window functions, and awareness of query cost. BigQuery/GoogleSQL preferred.
• Python for validation scripts and automation (pandas or equivalent).
• Git-based workflow: branches, PRs, code review.
• Investigative temperament with the ability to identify exact records, joins, and timezones.
• Clear written communication to explain data problems to non-technical stakeholders.

Responsibilities

• Test coverage in dbt across staging, intermediate and mart layers with business-rule tests.
• Source-to-warehouse reconciliation between MongoDB, telephony, files and BigQuery.
• Freshness, volume and schema-drift monitoring on critical tables with ownership definitions.
• Inbound client file QA — validating lender account files before journeys.
• Report and dashboard QA — ensure Tableau dashboards align with warehouse data and filters.
• Pre-release QA of new dbt models and metric definitions.
• Data incident process — detection, triage, stakeholder comms, root cause and fix.

Skills

SQL

BigQuery/GoogleSQL

Python

Git

Investigation

Communication

Education

Bachelor's degree in CS/Engineering/Analytics

Tools

dbt

Tableau/Looker/BI tools

Git-based workflows

Prefect or Airflow

MongoDB/JSON handling

Job description

About ClearGrid

ClearGrid is revolutionizing the debt resolution industry with cutting-edge AI and advanced analytics. We leverage real-time data, machine learning, and automation to optimize debt recovery for financial institutions. As we scale our technology platform, we are building high-performance, resilient systems to support our next phase of hyper-growth.

Why this role exists

ClearGrid runs collections journeys across AI voice, human agents, SMS, WhatsApp and email for lenders in the UAE and KSA. Every decision — who we call, when we call them, what a promise-to-pay is worth, what we invoice a client — sits on top of data that moves from MongoDB and telephony providers into BigQuery, through dbt, and out into Tableau dashboards, Streamlit apps and client-facing reports. When that data is wrong, the consequences are not cosmetic: we call a borrower who has already paid, we mis-state a lender's recovery rate in a QBR, or we bill against the wrong call window. This role exists to stop that happening — and to catch it fast when it does.

What you'll own

• Test coverage in dbt across staging, intermediate and mart layers — not just not_null and unique, but business-rule tests that encode how collections actually works (DPD bucket transitions, PTP date logic, disposition hierarchies, currency and amount sanity checks).
• Source-to-warehouse reconciliation between MongoDB, telephony systems, client files and BigQuery: row counts, per-lender counts, per-lender-per-DPD-bucket counts, and orphan/drift detection.
• Freshness, volume and schema-drift monitoring on critical tables, with clear ownership of what "broken" means for each.
• Inbound client file QA — validating lender account files (fields, formats, phone numbers, names, dates, encodings) before they ever reach a journey.
• Report and dashboard QA — every Tableau dashboard and client report gets checked before it ships. Do the headline numbers reconcile to the warehouse? Do the filters, date ranges and parameters change the figures the way they should? Do totals hold when you slice by lender, by campaign, by DPD bucket? Are nulls being silently dropped from a denominator? Does the same metric agree across two dashboards that both claim to show it?
• Pre-release QA of new dbt models and metric definitions before anything downstream is built on them.
• The data incident process — detection, triage, stakeholder comms, root cause, and the fix that stops

the repeat.

What we're looking for

Must Haves:

• 2+ years in data quality, analytics engineering, BI QA, or a data analyst role with heavy quality ownership.
• Strong SQL — CTEs, window functions, incremental patterns, and awareness of query cost. BigQuery/GoogleSQL preferred; any warehouse dialect considered.
• Python for validation scripts and automation (pandas or equivalent).
• Git-based workflow: branches, PRs, code review.
• An investigative temperament. You are not satisfied by "the numbers changed" — you want to know
• which record, which join, which timezone.
• Clear written communication. Much of the job is explaining a data problem to someone who doesn't
• want to hear about it.

Nice to have

• Collections, lending, or fintech domain knowledge — DPD buckets, roll rates, PTP, recovery rate, settlement.
• Prefect (or Airflow) orchestration.
• MongoDB and semi-structured/JSON data handling.
• Streamlit, or any BI tool (Tableau, Power BI, Looker) — as a user, not necessarily a builder.
• Data quality frameworks: dbt-expectations, Elementary, Great Expectations, or similar.