← Back to Projects

Zeiss Master Data Product

Enterprise ETL pipeline powering master data consistency across 7 business units and 15 countries at Carl Zeiss AG.

Databricks dbt Unity Catalog Python CI/CD

Overview

Enterprise-grade ETL pipeline powering the Zeiss Master Data product, ensuring data consistency and availability across 7 business units and 15 countries. The product became a core data layer adopted by over 30 internal customers.

Key Features

  • ETL pipeline built with Databricks and Unity Catalog for scalable, governed data ingestion
  • dbt-based data transformations with reusable macros and schema-level tests for reliability
  • CI/CD pipeline for automatic deployment of schema changes to Unity Catalog
  • Databricks pipeline orchestrating end-to-end data ingestion and dbt transformation tasks

Impact

Generated €850,000 in revenue and acquired over 30 internal customers by delivering reliable, consistent master data across the organization.