Detailed Project Description
Primagaz (later Norbro) was undergoing a change in ownership and a subsequent shift in platform and structure, requiring the migration of the data warehouse—including reporting—away from the previous solution and into a new setup. I worked as a freelance Data Warehouse developer in a hybrid model (on-site in Køge) with close interfaces to IT and Finance, where I first drove the migration and subsequently stabilized and optimized the relocated solution, while ensuring knowledge transfer by training a successor so that the solution could be maintained without being dependent on a single individual.
The ownership change (Primagaz, later Norbro) triggered a need to move the data warehouse and reporting to a new platform and structure, while ensuring the solution remained operationally stable afterward. The objective was twofold: first, a controlled migration without losing oversight in finance and reporting, and second, the stabilization and optimization of the moved solution to ensure it was robust enough for operations, handover, and subsequent support.
The migration involved both platform and logic: the database itself was moved, and existing SSIS jobs were converted to stored procedures because the SSIS environment was based on an old, unsupported version that could not be migrated one-to-one. Python jobs were also moved to stored procedures, partly to reduce complexity and partly because the solution was simpler to maintain when transformation logic was centralized within the database. Simultaneously, the Power BI setup and reports were moved to a new location on PowerBI.com—including the semantic layers—and necessary corrections were made to models and logic where issues arose after the move.
Following the migration, the next focus was ensuring the relocated solution was stable and predictable in operation. This involved reviewing and correcting parts of the model and transformation logic that were not behaving correctly in the new structure, while ensuring that load processes and dependencies could be executed reproducibly. An actual DSA (separate load area) was also established so that daytime re-executions would not affect production. In parallel, documentation was built up so that errors could be diagnosed and handled without needing to reopen the project, allowing support to run as a controlled track thereafter.
The conclusion of the task revolved around making the solution transferable and supportable in practice. I developed technical documentation and a practical runbook that made it possible to understand the flow, dependencies, and typical error scenarios (business documentation had already been established by the previous developer). I trained a successor in the solution and operations, ensuring a genuine continuation rather than just a "good luck." After the full period, I continued with physical support 2 to 3 days per month, and from February 2026 as on-call support when needed, typically in the evenings.
Norbro Energi (formerly Primagaz) is a Danish-Swedish supplier of LPG, providing both cylinder and tank gas to commercial and private customers. The company operates in Denmark and Sweden, with its headquarters in Køge (DK) and local offices in Odense (DK) and Stenungsund (SE). Norbro is part of the Treville & Co. group and has approximately 60 employees.
Product-wise, LPG typically covers both delivery methods (cylinders vs. tanks) and the practical setup at the customer's site, where tank gas is often linked to fixed installations, continuous supply, and dimensioning based on consumption, while cylinder gas is more flexible and used for heating, catering, industry, and agriculture. For commercial customers, it is essentially about supply and operational reliability, integrated into a daily routine with planning, service, and access to delivery and consumption information, while private customers typically encounter it as a combination of heating and practical gas usage.
In connection with the divestment and rebranding in 2025, the company was renamed from Primagaz and repositioned with a greater emphasis on flexibility and a more local profile in the market. Focus areas in the customer interface are typically supply security, digital accessibility, and customer service, as these are the parameters that in practice determine whether customers perceive the delivery as stable and easy to work with.