Business Analytics Manager - (NetSuite Integration + AI & Predictive Analytics)

apartmentBidfood Middle East placeDubai calendar_month 

Job Description

Project Overview

We are a UAE-based company using NetSuite as our ERP and Power BI as our main business intelligence platform. We are seeking a skilled freelancer to:

  • Connect NetSuite to Power BI and create a robust, optimized data model.
  • Develop a professional executive dashboard for finance, sales, and operations.
  • Implement AI capabilities for natural-language querying, automated insights, and predictive analytics.
  • Deliver knowledge transfer and documentation so our internal team can maintain and expand the solution.
  • Work closely with the FP&A (Financial Planning & Analysis) team — FP&A will design and define the reporting requirements and dashboard structure, and the freelancer will be responsible for implementing these designs in Power BI.
Scope Of Work
  • Data Integration
  • Connect NetSuite → Power BI using SuiteAnalytics Connect (OData) or third-party connector (e.g., CData).
  • Optimize queries for fast refresh performance.
  • Extract and prepare key datasets such as:
  • Sales Orders, Invoices, Payments
  • Items & Product Categories
  • Customers & Regions
  • Financial KPIs (Revenue, GP, etc.)
  • Data Modeling
  • Build a star-schema data model with proper relationships. - Create calculated columns & DAX measures for: As per business requirements defined by FP&A and management.
  • Dashboard Development
  • Design a visually appealing and user-friendly Power BI dashboard with: As per business requirements defined by FP&A and management.
  • AI & Advanced Analytics
  • Inside Power BI:
  • Enable & configure Power BI Copilot (if licensing supports it).
  • Implement Q&A visual for natural-language querying.
  • Add Smart Narrative for automated written insights.
  • Predictive Analytics:
  • Implement forecasting and anomaly detection in Power BI.
If required, integrate AI Builder, Python Prophet, or Azure Machine Learning for advanced forecasting models. - Optional: - Integrate Azure OpenAI or ChatGPT API for conversational querying of Power BI datasets.
  • Knowledge Transfer
  • Provide full documentation covering:
  • Data connections & refresh setup
  • Data model & DAX formulas
  • AI features & predictive models
  • Conduct a training session for internal users (1–2 hours).
Deliverables
  • Working NetSuite → Power BI live connection.
  • Optimized Power BI data model with KPIs.
  • Executive dashboard with AI-powered features.
  • Predictive analytics capability for sales & finance forecasting.
  • Documentation & training handover.
Qualifications
  • Proven track record with NetSuite to Power BI integration. -
  • Strong DAX and Power Query expertise.
  • Experience with AI features in Power BI (Copilot, Q&A, Smart Narrative).
  • Familiarity with predictive analytics (AI Builder, Python Prophet, Azure ML).
  • Experience integrating Azure OpenAI or ChatGPT API is a plus.
  • Strong dashboard design & data storytelling skills.

Application Instructions

When applying, please:

  • Provide examples of NetSuite → Power BI projects you've delivered.
  • Share AI and predictive analytics projects you have implemented with Power BI
  • Briefly outline your approach.
thumb_up_altRecommended

Business Analyst - 6mths contract

apartmentmanpower middle eastplaceDubai
Job Description About the Role Our client, a leader in the FinTech industry, is seeking a RAS Issuing Solutions Analyst / Associate to join their team. In this role, you will support the Product Lead in managing and scaling risk and identity...
check_circleNew offer

Business Analyst

apartmentm i r a l.l.cplaceDubai
Job Description We are looking for a Business Analyst for an international company operating in the commodities trading industry with global business processes and distributed infrastructure. Key responsibilities:  •  Analyze and formalize business...
electric_boltImmediate start

Business Risk Analyst

apartmentinnovations globalplaceDubai
analyse ratios and recommend credit risk rating  •  Report Writing – Prepare business rating report, prepare entity profile along with commentary on the ratios and its graphs. Undertake a SWOT analysis based on the available information and management...