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 Responsibilities1. Daily Food Cost Reporting & Newsletter ManagementMaintain 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.DeliverablesMTD Food Cost %30-Day Rolling Food Cost %Top Received IngredientsFood Cost vs Budget AnalysisCovers and Average Check MetricsTop POS Food Sales Analysis2. Weekly Ingredient Inflation ReportingAnalyze 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.DeliverablesWeekly Ingredient Inflation ReportYTD Price Trend AnalysisException Reporting & Cost Escalation Highlights3. Recipe & Ingredient Database AdministrationMaintain 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 descriptionsPack sizesUnits of measureCase quantitiesUpdate centralized ingredient databases in Excel, Google Sheets, or related systems.Ensure data consistency across multiple properties.DeliverablesClean Ingredient Master DatabaseProperty-Specific or Consolidated Ingredient RecordsOngoing Data Quality Improvements4. Power BI Dashboard Maintenance & PublishingMaintain 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.DeliverablesUpdated Power BI DashboardsMonthly Dashboard RefreshesData Reconciliation & Exception LogsPublished Management Reporting5. Competitive Menu Benchmarking & AnalyticsMaintain 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.DeliverablesCompetitive Menu DatabaseMonthly Benchmarking UpdatesMenu Analysis DashboardsSource Change & Data Quality NotesProcess Ownership & GovernanceThe analyst will be responsible for ensuring that every recurring report includes:Documented refresh proceduresQuality assurance (QA) validation stepsDefined ownership and accountabilityArchived historical recordsError tracking and escalation proceduresConsistent formatting standards for property-facing reportingRequired QualificationsTechnical SkillsAdvanced Microsoft Excel (Pivot Tables, Power Query, formulas)SQL querying and data extractionPower BI Development and AdministrationPower Query and DAXGoogle Sheets and Google Apps ScriptMicrosoft Office SuiteData validation and reconciliation techniquesBusiness reporting and dashboard developmentSystems ExperienceNexus Purchasing SystemMicros iQuery (preferred)POS Reporting SystemsOffice ConnectPower BI Service & Workspace ManagementGoogle WorkspaceHospitality F&B systems and reporting platformsAI & Automation ExperienceChatGPT or equivalent AI toolsData parsing and standardization workflowsReport automation and workflow optimizationAPI and scheduled data refresh concepts (preferred)Preferred Experience3+ 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 CompetenciesStrong analytical and problem-solving skillsHigh attention to detailExcellent data accuracy and quality control practicesAbility to manage multiple recurring deadlinesStrong written and visual reporting skillsProcess improvement mindsetAbility to work independently in a remote/offshore environmentSuccess MetricsTimely delivery of all recurring reportsAccurate food cost and inflation reportingReduced manual reporting effort through automationMinimal reporting errors and reconciliation issuesIncreased adoption of dashboards and business intelligence toolsContinuous improvement of F&B data quality and reporting efficiencyDepartment: Food & Beverage Analytics / Business Intelligence
19 days ago