· Architected and delivered an end-to-end Data Warehouse on Microsoft Fabric using Medallion Architecture (Bronze, Silver, Gold); gathered business requirements and translated them into logical and physical data models.
· Built Fabric solutions across Lakehouse, Warehouse, Data Pipelines and Dataflows Gen2, surfacing curated data through Power BI semantic models with governance and lineage controls.
· Developed T-SQL stored procedures, functions, views and parameterised queries to transform and serve Gold-layer datasets for reporting.
· Ran a Databricks proof-of-concept (Delta Lake, Data Lake, Workflows, Python notebooks) to benchmark a lakehouse warehouse against the Fabric build.
· Source control and CI/CD using Git integration for Fabric workspaces
· Fabric Deployment Pipelines to promote content across Dev, Test and Production stages
· Variable Libraries for environment-specific configuration and parameterisation across pipelines and notebooks
· Fabric Notebooks (Python, PySpark, Spark SQL), OneLake shortcuts, Semantic Models and Co-Pilot
· Git repository integration with Claude for faster development, code generation and early error detection