{bc}
linkedin

Business Data Analyst (Microsoft BI) — F&B

Joud Coffee
Abu Dhabi, UAE
fulltime
Mid-Senior
2 months ago
SQLPythonR ProgrammingData VisualizationStatistical AnalysisMachine Learning
Free

Job Fit Check

Base Career helps you apply smarter for this job.

?%
Ready to Scan

Key skills for this role

SQLPythonR Programming
Smart Apply

Full Job Posting

Overview

The role

You will own our BI stack end-to-end: ingesting data, building clean models, and delivering clear dashboards that drive action.

You’ll partner with Operations, Finance, Marketing, and Supply Chain to surface the metrics that matter (AOV, attachment rate, COGS, labor %, waste, menu mix, cohort retention, store P&L, campaign ROI, etc.).

What You’ll Do

  • Design, build, and maintain Power BI dashboards (DAX, Power Query) for daily/weekly exec and outlet views.
  • Model and transform data from POS, ERP, inventory, and other sources into a single source of truth.
  • Publish and govern datasets, set refresh schedules, and manage row-level security.
  • Build automated KPI packs (email/Teams summaries) and self-serve datasets for stakeholders.
  • Deep-dive analyses: menu engineering, price tests, promo/seasonality, forecasting, and store benchmarking.
  • Create clear documentation, data dictionaries, and how-to guides for non-technical users.
  • QA data quality; resolve anomalies with vendors and internal teams.
  • Support ad-hoc questions with fast queries and crisp narratives that drive decisions.

Must-have Qualifications

  • 3+ years in analytics/BI; at least 2 years hands-on with Microsoft BI (Power BI, Power Query, DAX).
  • Strong SQL (joins, CTEs, window functions) and data modeling (star/snowflake).
  • Proven record turning messy operational data into simple executive dashboards.
  • Business acumen in F&B/retail (store ops, margins, inventory, promos).
  • Excellent communication: you can translate analysis into action for non-analysts.
  • Ownership mindset; comfortable working at speed with imperfect data.
  • Nice to have
  • Experience with Foodics POS, Microsoft Dynamics 365 Business Central, Supy, or similar systems.
  • Python for analysis/automation; Power Automate/Power Apps for light workflows.
  • Forecasting/experimentation (baseline vs. lift, cohort retention, seasonality).
  • Arabic language skills.
  • Tools & data sources you’ll touch
  • Power BI (Service/Desktop), DAX, Power Query, SQL Server/Azure SQL, Excel, Dynamics 365 BC, POS exports (e.g., Foodics), inventory/procurement, staffing/labor, marketing & e-commerce.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Joud Coffee