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