Retail Etl Pipeline Medallion

This builds a three-tier medallion architecture ETL pipeline for retail data using PySpark and SQL Server. You get Bronze for raw CSV ingestion, Silver for cleansing and deduplication, and Gold for business metrics like inventory shrinkage and sales aggregations. The included SQL scripts handle the full flow from bulk inserts through stored procedures that calculate things like expected stock versus actual and supplier rebate tiers. It's overkill for small shops but solid if you're consolidating multi-branch inventory and sales data and need proper data quality layers. The shrinkage calculation logic is particularly well thought out, joining stock levels against sales to find discrepancies.

Install to Claude Code

npx -y skills add aradotso/data-skills --skill retail-etl-pipeline-medallion --agent claude-code