Job Description

Each site currently operates on different ERP systems (Microsoft Business Central, NAV 2018, SAP ECC 5), leading to fragmented financial and customer data. The long-term goal is to centralise data using a Microsoft Fabric-based data warehouse, but first, we need a clear understanding of our existing capabilities, gaps, and business needs.

This 3-month contract will focus on:

• Assessing how data is currently structured and used across different sites.
• Identifying key challenges in financial and operational reporting.
• Building a proof of concept (POC) using Power BI, SQL, and Power Automate.
• Providing strategic recommendations for data integration and governance.

• Map out how financial and customer data is stored and used across sites.
• Engage with finance, IT, and operational teams to understand key reporting pain points.
• Identify data inconsistencies, manual processes, and reporting inefficiencies.

• Use Power BI to demonstrate how consolidated reporting could work.
• Apply SQL to extract and standardise key data sets from different ERPs.
• Explore Power Automate to reduce manual data handling.

• Define what data needs to be centralised for better financial and operational visibility.
• Recommend an approach for transitioning towards a centralised Microsoft Fabric data warehouse.
• Develop a roadmap for data governance and integration best practices.

• Proven experience in data integration, strategy, or business intelligence consulting.
• Strong Power BI and SQL skills for prototyping reporting improvements.
• Experience with ERP systems (Business Central, NAV, SAP) and understanding how financial data is structured.
• Knowledge of data warehousing principles (Microsoft Fabric experience is a plus).
• Strong business engagement skills able to speak with finance, IT, and operations teams to understand reporting needs.

• A data strategist who can assess existing systems and recommend a path forward.
• Someone with experience consolidating data across multiple ERPs.