Food & Beverage Reporting & Business Intelligence Analyst

We are seeking a detail-oriented Food & Beverage Reporting & Business Intelligence Analyst to support and maintain critical F&B reporting, analytics, and data automation processes across multiple properties. This role will be responsible for producing recurring operational and financial reports, maintaining ingredient and menu benchmarking databases, supporting Power BI dashboards, and improving data workflows through automation.

The ideal candidate combines strong analytical skills with experience in hospitality reporting systems, Excel-based data management, business intelligence platforms, and process automation tools.

Key Responsibilities

1. Daily Food Cost Reporting & Newsletter Management

Maintain and refresh daily Food Cost reporting processes.

Export and analyze Nexus receiving data (MTD and trailing 30 days).

Create pivot tables and identify top ingredients by quantity and invoice value.

Import and reconcile food revenue, cover counts, average food check, and POS food sales data.

Generate property-facing reports in professional newsletter, dashboard, or Power BI formats.

Validate report accuracy through established QA procedures.

Archive reporting outputs according to company standards.

Deliverables

MTD Food Cost %

30-Day Rolling Food Cost %

Top Received Ingredients

Food Cost vs Budget Analysis

Covers and Average Check Metrics

Top POS Food Sales Analysis

2. Weekly Ingredient Inflation Reporting

Analyze year-to-date purchasing data from Nexus.

Calculate weighted week-over-week ingredient pricing changes.

Maintain and update ingredient price trend dashboards and charts.

Monitor pricing exceptions and identify significant cost variances.

Archive historical price trend reporting.

Incorporate same-time-last-year (STLY) analysis as historical data becomes available.

Deliverables

Weekly Ingredient Inflation Report

YTD Price Trend Analysis

Exception Reporting & Cost Escalation Highlights

3. Recipe & Ingredient Database Administration

Maintain ingredient master databases supporting recipe costing and menu management applications.

Export and analyze recent purchasing data from Nexus.

Utilize AI-assisted tools to parse and standardize:

Ingredient descriptions

Pack sizes

Units of measure

Case quantities

Update centralized ingredient databases in Excel, Google Sheets, or related systems.

Ensure data consistency across multiple properties.

Deliverables

Clean Ingredient Master Database

Property-Specific or Consolidated Ingredient Records

Ongoing Data Quality Improvements

4. Power BI Dashboard Maintenance & Publishing

Maintain monthly F&B reporting dashboards.

Refresh Office Connect templates and data models.

Update forecast versions and fiscal years as required.

Validate data integrity and reconcile key financial metrics.

Troubleshoot data refresh and schema issues.

Publish approved dashboard updates and maintain issue logs.

Deliverables

Updated Power BI Dashboards

Monthly Dashboard Refreshes

Data Reconciliation & Exception Logs

Published Management Reporting

5. Competitive Menu Benchmarking & Analytics

Maintain menu item benchmarking databases across defined competitive sets.

Collect and update menu information from approved sources.

Standardize menu items into predefined categories and taxonomies.

Support competitive pricing and product analysis.

Publish benchmarking results through Power BI and executive reports.

Deliverables

Competitive Menu Database

Monthly Benchmarking Updates

Menu Analysis Dashboards

Source Change & Data Quality Notes

Process Ownership & Governance

The analyst will be responsible for ensuring that every recurring report includes:

Documented refresh procedures

Quality assurance (QA) validation steps

Defined ownership and accountability

Archived historical records

Error tracking and escalation procedures

Consistent formatting standards for property-facing reporting

Required Qualifications

Technical Skills

Advanced Microsoft Excel (Pivot Tables, Power Query, formulas)

SQL querying and data extraction

Power BI Development and Administration

Power Query and DAX

Google Sheets and Google Apps Script

Microsoft Office Suite

Data validation and reconciliation techniques

Business reporting and dashboard development

Systems Experience

Nexus Purchasing System

Micros iQuery (preferred)

POS Reporting Systems

Office Connect

Power BI Service & Workspace Management

Google Workspace

Hospitality F&B systems and reporting platforms

AI & Automation Experience

ChatGPT or equivalent AI tools

Data parsing and standardization workflows

Report automation and workflow optimization

API and scheduled data refresh concepts (preferred)

Preferred Experience

3+ years of reporting, business intelligence, or financial analysis experience.

Hospitality, hotel, restaurant, or food service industry experience preferred.

Experience working with purchasing, inventory, recipe costing, or menu analytics data.

Understanding of food cost controls, menu engineering, and F&B operational metrics.

Key Competencies

Strong analytical and problem-solving skills

High attention to detail

Excellent data accuracy and quality control practices

Ability to manage multiple recurring deadlines

Strong written and visual reporting skills

Process improvement mindset

Ability to work independently in a remote/offshore environment

Success Metrics

Timely delivery of all recurring reports

Accurate food cost and inflation reporting

Reduced manual reporting effort through automation

Minimal reporting errors and reconciliation issues

Increased adoption of dashboards and business intelligence tools

Continuous improvement of F&B data quality and reporting efficiency

Department: Food & Beverage Analytics / Business Intelligence

Originally posted on Himalayas