Back to search
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.
