Swickard ADF

About the Project

Production Azure Data Factory implementation for Swickard Auto Group. Built end-to-end data pipelines processing vendor feeds and CSV data through Bronze/Silver/Gold medallion architecture with Data Vault 2.0 patterns. Includes 27+ business entities, Azure Functions for ETL, and comprehensive CI/CD pipelines.

Key Highlights

• •Designed Bronze/Silver/Gold medallion architecture for enterprise data warehouse
• •Built 2 Azure Function Apps for SFTP and CSV processing
• •Implemented Data Vault 2.0 patterns for Silver layer modeling
• •Created dimensional star schema for Gold layer analytics
• •Established Git-connected CI/CD workflow with automated PR reviews