Data Engineering · Fabric2024

Automated Data Quality Framework

A reusable PySpark data-quality accelerator for schema extraction, validation, threshold monitoring, and alerting across lakehouse pipelines.

PySparkMicrosoft FabricDelta LakeDQM
Project summary

Impact

−90%

manual data-quality checks reduced through reusable validation patterns

Hiring signal

What this proves

Data engineering scale, reusable framework design, observability, config-driven validation, and production reliability.

My role

Ownership

Developer · PySpark logic, Fabric implementation, schema extraction, rule generation, validation framework, and monitoring patterns

Status

Enterprise data-quality framework · source available

Source or architecture details are available where applicable.

The problem

What needed to change

Data-quality checks were manual, repetitive, and difficult to scale across large tables and multiple pipelines. Teams required a reusable framework for schema validation, rule enforcement, anomaly detection, reconciliation, and alerting without implementing bespoke checks for every dataset.

My approach

How I built it

The framework uses Python and PySpark on Microsoft Fabric to inspect schemas dynamically, resolve configuration-driven rules, execute distributed validations, persist results, and enforce quality gates across Bronze, Silver, and Gold layers.

Architecture judgment

Why this design

Data-quality management must scale with the lakehouse. Schema-derived checks expand baseline coverage as new tables are introduced, while configuration-driven rules keep thresholds, ownership, and policy changes explicit and reviewable.

Architecture

High-level system design

The complete execution path, service boundaries, data stores, security controls, validation stages, and operational telemetry.

Implementation

Key components

  • Dynamic schema extraction
  • Config-driven rule generation
  • Null, duplicate, drift, key, and type checks
  • Reconciliation and threshold anomaly checks
  • Result persistence and traceability
  • Pipeline failure and SLA monitoring

Technology

Tech stack

Data

PySparkMicrosoft FabricDelta LakeLakehouseDQM

Languages

PythonSQL

Ops

Azure MonitorAzure DevOpsGit

Interactive trace

See the workflow run

automated DQM · PySpark lakehouse validation execution trace

Run the trace to see the main workflow stages.