The client relied on 200+ hardcoded SSIS packages to ingest data from suppliers and POS systems. Onboarding a new supplier took 2 weeks of developer time. Data latency was high (T+48 hours), meaning store managers received 'Spoilage Reports' after items had already expired. They needed a scalable, automated solution to democratize data access and reduce operational overhead.

We implemented a 'Metadata-Driven Ingestion Framework'. Instead of creating a pipeline for each source, we built a reusable 'Master Pipeline' in ADF that reads configuration (Source System, Schedule, Schema) from a SQL Control Table. This dynamic approach allows the client to onboard new data sources by simply inserting a row into a table—zero code required. We modeled a Star Schema in Synapse and built a Power BI 'Store Manager Dashboard' for real-time inventory tracking.