Skip to main content
FreelanceJobs logo

Power BI Consultant – ERP Data Connection

FreelanceJobs
CAPosted February 27, 2026

Job Description

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

Want AI-powered job matching?

Upload your resume and get every job scored, your resume tailored, and hiring manager emails found - automatically.

Get Started Free