Business Data Analyst (Microsoft BI)

Joud Coffee; Abu Dhabi; On-site; AED 120,000 - 200,000; Full time

Job summary

A leading coffee company based in Abu Dhabi is seeking a BI Analyst to manage their Power BI stack from data ingestion to dashboard creation. You will partner with various departments to provide meaningful insights and automate reports. Candidates must have over 3 years of analytics experience, including 2 years with Microsoft BI tools. Strong SQL and business acumen in the food & beverage sector are essential. This role offers an opportunity to impact business decisions significantly.

Qualifications

• 3+ years in analytics/BI; at least 2 years hands-on with Microsoft BI.
• Strong SQL knowledge including joins and window functions.
• Proven record of creating executive dashboards from messy data.

Responsibilities

• Design and maintain Power BI dashboards for executive views.
• Transform data from various sources into a single source of truth.
• Create documentation and guides for non-technical users.

Skills

Microsoft BI (Power BI, Power Query, DAX)

SQL

Data modeling (star/snowflake)

Communication skills

Business acumen in F&B/retail

Tools

Power BI (Service/Desktop)

Excel

Dynamics 365 BC

Foodics POS

Job description

Overview

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.).

Responsibilities

• 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.