Anglian Water Services
Built a comprehensive enterprise data platform using Microsoft Fabric and Databricks, controlling 250+ data products with automated ETL/ELT architecture and Delta-Parquet format in OneLake.
Anglian Water needed a unified data platform to manage data from hundreds of operational systems across eastern England. Legacy systems were siloed, reporting was manual, and data quality was inconsistent across 250+ data products serving different business units.
Designed and implemented a Microsoft Fabric-based data platform with Databricks as the compute engine. Implemented central storage in OneLake using Delta-Parquet format for both raw and transformed data. Built Curated and Gold layers using a customizable Microsoft framework with automated ETL/ELT architecture.
Mapped 250+ data sources across operational systems, identified quality gaps, and defined target medallion architecture.
Implemented central storage in OneLake with Delta-Parquet format. Designed Landing, Curated, and Gold layer structure.
Built automated ETL/ELT pipelines with Azure Data Factory and Databricks notebooks. Framework approach for 250+ products.
Built Curated and Gold layers using customizable Microsoft framework. Delivered Power BI dashboards integrated with Fabric.
CI/CD pipelines with Azure DevOps. Automated testing, data lineage tracking, and governance with Microsoft Purview.
Mapped 250+ data sources across operational systems, identified quality gaps, and defined target medallion architecture.
Implemented central storage in OneLake with Delta-Parquet format. Designed Landing, Curated, and Gold layer structure.
Built automated ETL/ELT pipelines with Azure Data Factory and Databricks notebooks. Framework approach for 250+ products.
Built Curated and Gold layers using customizable Microsoft framework. Delivered Power BI dashboards integrated with Fabric.
CI/CD pipelines with Azure DevOps. Automated testing, data lineage tracking, and governance with Microsoft Purview.
All data products controlled through a single framework
Automated validation at every pipeline stage
From days to hours for complex operational reports
Optimized compute and storage architecture
“CODES AI delivered an exceptional data platform that has transformed how we manage our operations. Their expertise in data engineering is truly world-class.”
James Whitfield
IT Director, Anglian Water Services
Let's discuss how we can deliver the same results for your business. Free consultation, no commitment.