Engineering KPI Trust​ - Enercity AG

1

2

3

4

5

Source Systems

Staging Data Lake

Enterprise Warehouse

Information Delivery

Data Consumption

Azure Data Lake Iceberg

Snowflake Data Vault

Snowflake Marts

ERP

Internal apps

LAKE NETZ

NETZ

NETZ

Embedded workflows

CRM

Power BI

LAKE AG

AG

AG

Managed reporting

Customer support

API

LAKE CROSS

CROSS

CROSS

Other systems

Application interfacing

Python dbt

dbt

datavault4dbt

Python on k8s

datavault4dbt

Catalog & Lineage

OpenMetadata Ownership Discoverability

Code & Delivery

GitHub Enterprise Issue Management CI/CD

At the foundation of the platform, data is ingested into dedicated staging environments built on Azure Data Lake and Apache Iceberg. Separate data lake environments are maintained for the dif- ferent subsidiaries and shared service areas, allowing data to be collected, stored, and processed while respecting organizational boundaries. Scalable processing capabilities based on Python and Kubernetes provide a flexible foundation for integrating and preparing enterprise data. An enterprise data warehouse (EDW) built with Data Vault methodology serves as the foundation of the platform. The EDW resides on Snowflake and is implemented using dbt Platform and dat- avault4dbt - a package created by Scalefree to streamline and automate Data Vault implementation. This layer provides a scalable, auditable, and historically traceable repository for enterprise infor- mation. Separate warehouse structures for the individual subsidiaries and shared domains ensure that data ownership and access controls can be implemented consistently while still enabling controlled shar- ing of approved information. The Data Vault methodology also supports long-term maintainability and simplifies the integration of new business areas and future acquisitions. Above the warehouse layer, business-, and use-case-oriented information marts are created to pro- vide data products tailored to analytical and reporting requirements. This separation between en- terprise-wide storage and consumption-ready models ensures that business logic is implemented once and reused consistently across multiple use cases. As a result, analytical applications, opera- tional reporting, and management dashboards can rely on a common and trusted data foundation. The platform supports multiple consumption channels, including reporting solutions, internal appli- cations, embedded workflows, and API-based integrations. This enables business users and techni- cal consumers to access governed data products through the tools most appropriate for their needs while maintaining consistent KPI definitions and standardized reporting across the organization.

Enercity AG Success Story - Engineering KPI Trust - Share Reliable Data in a Regulated Industry​

5/12

Powered by