BI Expert for CM Calculation (m/f/d)

An organization is looking for an experienced BI expert to take over the complete design and implementation of a BI stack for multilevel contribution margin accounting. The data source is the ERP system Abas, and the task includes data extraction, transformation and the reporting frontend. Tool decisions will be made in close coordination with project management and the company.

The goal of the project is to develop an automated solution for calculating and presenting contribution margins (CMI–IV) based on variable and fixed cost blocks as well as a cost center/cost object logic. The solution should be able to update regularly without manual intervention and include comprehensive documentation and knowledge transfer to internal users.

• Analysis of the Abas data structure (tables, fields, export options via API, ODBC or Abas native interfaces)
• Definition and documentation of technical requirements together with controlling, IT and project management
• Selection, justification and setup of the appropriate BI tool stack (ETL, data model, reporting)
• Development of multilevel contribution margin accounting (CMI–IV) according to the existing concept
• Mapping of variable and fixed cost blocks, including cost center/cost object logic from Abas in different perspectives and hierarchy levels
• Setup of automated, regular data update logics without manual intervention
• Documentation of the entire solution and knowledge transfer to internal users

• Solid experience with BI tools and ETL processes
• Knowledge in data extraction and analysis from ERP systems, ideally Abas
• Experience in developing contribution margin accounting and cost logics
• Ability to independently design and implement technical solutions
• Very good German skills, English skills are an advantage
• Strong communication skills and teamwork for coordination with various stakeholders