Job Description

Food cost is one of the largest line items in our business, and it moves at the intersection of purchasing, prep, portioning, and menu mix. We are hiring a data-minded engineer to make that cost legible: to trace where margin leaks, quantify why, and ship the code that helps our teams correct it. This is not a reporting-only role — you will own the full loop from data diagnosis to production deployment. Key Responsibilities ● Analyze purchase orders, vendor invoices, inventory counts, and point-of-sale data to identify drivers of food cost variance by store, vendor, item, and week. ● Write and maintain MySQL and SQL Server queries that surface waste, over-prep, portion drift, price movement, and invoice discrepancy trends. ● Build and support the data feeds, calculations, and fixes behind our internal food-cost tooling. ● Write and deploy production PHP code in our internal applications to carry food-cost insights into the workflows store and operations teams use daily. ● Diagnose data quality issues in operational systems (missing items, mismatched units of measure, duplicate or stalled imports) and partner with engineering to resolve them. ● Communicate findings in clear written analysis: what the data shows, how confident we can be, and what action it recommends. ● Partner with purchasing, store operations, and leadership to turn analytical findings into measurable cost reduction. Requirements Required Qualifications ● Strong SQL skills across both MySQL, SQL Server and BigQuery: joins, aggregations, windowed logic where available, and performance-minded query design on transactional data. ● Know how to use LLMs to get things done, correctly and quickly ● Demonstrated analytical ability: breaking ambiguous business problems into testable questions and answering them with data. ● Clear, concise written communication; comfortable writing up findings for non-technical audiences. ● Working knowledge of relational database design and data quality diagnostics (duplicates, nulls, grain mismatches, unit conversions). ● Comfort working directly with stakeholders to turn analysis into action. ● Production experience writing and deploying PHP in a real application — this role ships code (Would prefer to have this but not important if the resource doesn’t) Preferred Qualifications ● Familiarity with food-cost concepts: theoretical vs. actual food cost, yield testing, plate cost, and inventory valuation. ● Experience with vendor invoice reconciliation or purchase-order auditing. ● Familiarity with reporting and visualization tools (Quicksight). ● Experience integrating or auditing point-of-sale or ERP data (Brink, SQL Server, BigQuery).