data-reconciliation-exceptions

What problem does it solve?

This Skill ensures data integrity by reconciling different data sources, identifying discrepancies, and generating detailed exception reports to prevent silent failures in data pipelines.

Core Features & Use Cases

• Data Source Reconciliation: Matches records across datasets using stable identifiers like Pay Numbers and driver document numbers.
• Exception Reporting: Produces clear reports detailing mismatches, missing records, duplicates, and invalid entries with explicit reasons.
• 'No Silent Failure' Checks: Implements validation gates to halt processes when data quality thresholds are not met.
• Use Case: Automatically reconcile weekly payroll exports with compliance registers, flagging any records that do not join and providing reasons for the non-match.

Quick Start

Reconcile the payroll export and compliance register, producing an exceptions report with reasons for non-joins.