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

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

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

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

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