Business Data Analyst (Microsoft BI)

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