CRM, BILLING AND TRANSACTIONAL DATA IN ONE SINGLE POINT OF TRUTH

heidelpay Logo

challenge mountain achievement
Challenge
Integrating data from various sources and providing business users with consistent reports as well as access to raw data.
solution puzzle
Solution
Implementation of a sustainable data warehouse (integrating CRM, billing and transactional data) in 6 months and with only two engineers.
benefits boost up
Benefits
Time-efficiency, significant reduction of cost for development, standardization and auto-generated data lineage/documentation.

About Heidelpay

heidelpay is a leading payment service provider for online merchants and marketplaces. Based in Heidelberg, Germany, the fast-growing company provides services for more than 25.000 customers spread over 160 countries worldwide.

WHAT HEIDELPAY SAYS ABOUT US

heidelpay Logo

„Thanks to biGENiUS we created a productive DWH ready for reporting, in 6 months and with only two engineers. In this time, we could focus on the business logic, biGENiUS managed the technical implementation.“

Mirjam Cohrs
Data Architect, heidelpay GmbH
challenge mountain achievement

CHALLENGE

heidelpay is a leading payment service provider for online merchants and marketplaces. Based in Heidelberg, Germany, the fast-growing company provides services for more than 25.000 customers spread over 160 countries worldwide. The task of the new engineering team was to integrate available data coming from various sources and locations, provide business users with consistent management reports, and also allow them access to the raw data.

Starting in a green field, the small development team of two launched an ambitious project of building a new agile and sustainable data warehouse, which was to integrate CRM, billing and transactional data in one single point of truth. But how could two data engineers master the technical implementation in close coordination with the business units? And how could high-quality results and lifecycle management be provided in such a complex system, supporting more than 200 payment workflows and 30 webshop systems?

SOLUTION

Facing these challenges, the DWH team of heidelpay searched for answers in automation. After evaluating various technologies and tools on the market, heidelpay decided to build an automated data warehouse using biGENiUS. Within only six months, the small team of two successfully delivered a productive comprehensive data warehouse solution. The technical implementation was completed in less than 8 weeks, which allowed the data engineers to work closely with controlling and focus on defining and implementing a consistent business logic.

solution puzzle
benefits boost up

BENEFITS

Using biGENiUS in the implementation, the DWH team of heidelpay succeeded to implement a data warehouse solution faster than expected. Along with time-efficiency, another major benefit was the significant reduction of cost for development. Furthermore, biGENiUS ensured the necessary standardization in the development, which naturally improved traceability in the change management and long-term ease in the maintenance of the data warehouse. Last but not least, the team was equipped with auto-generated data lineage and documentation at each release cycle without any additional effort.


TECHNOLOGIES & PRODUCTS

  • Oracle Database, Tableau