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

A company is looking for an experienced BI expert to take on the full design and implementation of a BI stack for a multi-stage contribution margin calculation. The data source is the ERP system Abas, and the task includes data extraction, transformation, and the reporting front end. Tool decisions will be made in close coordination with the project lead and the company.

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

• Analysis of the Abas data structure (tables, fields, export options via API, ODBC, or Abas-specific interfaces)
• Definition and documentation of the 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 a multi-stage contribution margin calculation (CMI–IV) based on the existing concept
• Mapping of variable and fixed cost blocks incl. cost center / cost object logic from Abas in different views and hierarchy levels
• Setup of automated, regular data refresh logic without manual intervention
• Documentation of the overall solution and knowledge transfer to internal users

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