Overview About Ru3ch Interactive

Mission of the project is to build one inclusive BI platform to generate intelligent insights that are accessible and efficient to all (FQ & markets) based on standardized data and a common, flexible architecture across Mercedes-Benz Mobility. Implementation of a Metadata-Driven Data Management Framework. Data from the source systems are ingested by Azure Data Factory Pipelines, stored in Azure Data Lake and transformed in Databricks Notebooks using a medallion (multi-hop) architecture. The framework is built in a generic and flexible way so it can be reused for all use cases - 45 markets and FQ. It's open for market specific non-standard requirements not forcing other markets to adjust their solution / implementation. The framework is configured by metadata that specifies how many layers the ETL process will have, which data will be ingested, how the data will be transformed, which data will be exported etc. Based on these metadata it automatizes creation of ingestion, transformation and export instructions to speed up market onboarding. The framework also supports data validation and can stop ETL process, trigger a workflow and wait for an approval to continue. Our company augmented the client's team by providing one resource (Michal Rutrich) who served as a technical architect and a lead data engineer.