Lead Architect Data Basis, Planning and Management Reporting

Project overview

Lead Architect Data Basis, Planning and Management Reporting - Immediate - 12 Months

Target State

A group-wide control on a central SQL database, with clear system roles, traceable financial and KPI logics, and approved, versioned data statuses for management and investors (data room capable).

Role

• Overall technical responsibility for data, planning, and reporting architecture and for end-to-end integration
• Central technical point of contact for CFO and project management; functional authority remains with the client
• Coordinates other experts: Customizing for Corporate Planner and Power BI, Data Engineering, source system specialists

Responsibilities

Must-Haves

Desirable

Framework

Please send me by 05.11.26…

Are you open to new challenges in an agile and dedicated team? Then send me your CV as a Word document to [contact removed] .

We operate as a recruitment consultancy. None of the technical terms mentioned should be discriminatory regarding age or experience. We confirm that we welcome all applications from candidates of all ages and experiences.

• Source assessment and data object catalog: proALPHA, BIOS, a management system for sales and QM, Excel sales data, time tracking/BDE (Tisoware), minimum data set of the foreign location
• Setup of the central SQL database: transfer, harmonization, historization, data quality, reconciliation against closing values
• Further development of the existing Corporate Planner model: cost centers, individual documents, consolidation functions (currency, IC reconciliation, eliminations, adjustments, journal, release workflow)
• Management Reporting in Power BI: Actual, previous year, budget, forecast; Adjusted EBITDA bridge, cash, NWC, Net Debt
• Commercial data: clearly separate order intake, framework and call-off stock as well as forecast, historize them as of the reporting date, and make them traceable with a movement bridge
• Operation On-Premise, authorizations, tests, documentation, operational handover, and know-how transfer
• Demonstrable lead role in building data warehouses on SQL Server in the mid-market
• Deep experience with Corporate Planner (planning, consolidation) and with semantic models in Power BI
• Data extraction from manufacturing ERP systems, ideally proALPHA
• Finance understanding: GKV and UKV, consolidation, EBITDA bridge, reconciliation
• Experience in managing external specialists
• German fluent (negotiation level)
• Experience with BIOS and with time tracking or BDE (Tisoware)
• Reporting in the PE environment, preparation of data rooms
• Access to own Data Engineers and Corporate Planner Customizers
• English for the foreign location
• Start immediately
• Implementation in waves: clarity of start, data core, early usable results, expansion, stabilization
• Duration 12+ months
• Hybrid, with on-site appointments at locations in Eastern and Southern Germany
• CV and project list with concrete references for Corporate Planner, Power BI, SQL DWH, and ERP integration
• Availability and scope
• Daily rate and engagement model
• Also, which supplementary resources (Data Engineer, CP Customizer) can be brought along

Project details

• Start: ab sofort
• Duration: 12 Monate
• Remote: hybrid
• Location: Köln, Deutschland, DE
• Languages: German