Data Engineer — Food Cost Analytics

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 Big. Query: 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, Big. Query).