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 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).