Business Data Analyst (Microsoft BI) — F&B

Joud Coffee · Abu Dhabi

Hybrid: Abu DhabiFull TimeInformation Technology
Posted 3 months ago

Job description

Responsibilities

  • Design, build, and maintain Power BI dashboards for daily/weekly executive and outlet views
  • Model and transform POS, ERP, inventory, and other data into a single source of truth
  • Publish/govern datasets, schedule refreshes, and manage row-level security
  • Automate KPI packs (email/Teams) and provide self-serve datasets
  • Conduct deep-dive analyses: menu engineering, pricing tests, seasonality, forecasting, benchmarking
  • Create documentation, data dictionaries, and user how-to guides
  • Monitor and improve data quality; resolve anomalies with vendors and internal teams
  • Handle ad-hoc stakeholder questions with fast queries and clear narratives

Requirements

  • 3+ years analytics/BI with 2+ years Microsoft BI (Power BI, Power Query, DAX)
  • Strong SQL (joins, CTEs, window functions) and data modeling (star/snowflake)
  • Track record simplifying messy operational data into executive dashboards
  • Business acumen in F&B/retail (store ops, margins, inventory, promos)
  • Excellent communication with non-technical stakeholders
  • Ownership mindset; comfortable working fast with imperfect data

Preferred Qualifications

  • Experience with Foodics POS, Microsoft Dynamics 365 Business Central, Supy, or similar
  • Python for analysis/automation; Power Automate/Power Apps for workflows
  • Forecasting/experimentation (baseline vs. lift, cohorts, seasonality)
  • Arabic language skills

Benefits

  • Details not specified

About the Company

Joud Coffee is an Abu Dhabi–born specialty coffee company founded in 2015. The brand operates multiple neighborhood locations across the city, roasting in small batches at its Abu Dhabi facility and sourcing through ethical, sustainable partnerships. With 11+ locations and growing, Joud serves the local community with quality coffee, food, and pastry offerings. This role is based in Abu Dhabi, UAE (hybrid).

Skills & tools

Power BIDAXPower QuerySQL ServerAzure SQLMicrosoft Dynamics 365 Business CentralFoodicsPythonPower AutomatePower AppsData ModelingRow-Level SecurityMenu EngineeringForecastingCohort analysisF&B AnalyticsKPI ReportingExcel

What the team is looking for

Use this list as a quick fit check before you apply.

  1. 01Power BI
  2. 02DAX
  3. 03Power Query
  4. 04SQL
  5. 05Data modeling
  6. 06Star schema
  7. 07Snowflake schema
  8. 08F&B analytics
  9. 09Executive dashboards
  10. 10Row-level security
  11. 11Azure SQL
  12. 12Excel
  13. 13Documentation
  14. 14KPI automation
  15. 15Communication