Power BI Consultant – ERP Data Connection

We are looking for an experienced Power BI consultant to help set up the foundations of a Power BI reporting environment.

This project is focused purely on data setup and modelling — not advanced dashboard design.

We need help to:

• Connect Power BI to our ERP system (Ibcos, cloud-hosted, ODBC connection available)
• Configure and validate the Power BI Gateway for reliable scheduled refresh
• Clean and transform ERP data using Power Query
• Design a proper data model (best practice structure, star schema where appropriate)
• Create core base measures (e.g. Sales, Cost, GP)
• Implement proper date handling and time intelligence structure
• Ensure performance is acceptable
• Document the setup clearly so we can maintain it internally

We also have some supporting Excel data in shared folders that may need to be incorporated.

This must be:

• Built using best practices
• Clearly structured and documented
• Easy for us to maintain going forward
• Not dependent on proprietary scripts or obscure methods

We do NOT want:

• Overly complex architecture
• Custom software development
• A black-box solution we can't manage ourselves

Contract duration of 1 to 3 months. with 30 hours per week.

Mandatory skills:

Microsoft Power BI, Data Visualization, Data Analysis, Business Intelligence, Microsoft Power BI Data Visualization