Microsoft Fabric · Automated analytics
Automated analytics platform
My role Lead Data Engineer
About the project
The project replaced manual analytics based on Excel and disconnected processes with an automated Microsoft Fabric platform. Data from three SQL endpoints—including an ERP system and an internal warehouse—was ingested in batches and transformed through a medallion architecture.
Outcome: An automated data platform supplying curated Warehouse data to automatically refreshed Power BI reports, with operational monitoring and failure alerts built in.
My contribution
- Translated the business requirements into technical requirements and designed the complete Fabric architecture.
- Built the batch-ingestion pipelines and medallion layers: a bronze Lakehouse followed by silver and gold Warehouses.