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).
#J-18808-Ljbffr
