Data Engineer — Food Cost Analytics
Tkxel
Date: 2 weeks ago
City: Lahore
Contract type: Full time
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).
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).
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
SDR- Appointment setter - LHR, Pakistan
Spark AI,
Lahore
1 day ago
DescriptionWE'RE HIRING: APPOINTMENT SETTER FOR TECH PRODUCTSLocation: Lahore, Pakistan Full-Time | UAE Market | B2B SalesWe’re looking for an SDR based in Lahore to join our sales team and help us grow our UAE client base.What You'll DoMake outbound cold calls to UAE businesses.Identify and speak with business owners & decision-makers.Generate conversations through LinkedIn, WhatsApp & Email.Research and find new...
Medical Systems Engineer
Medequips SMC,
Lahore
2 days ago
. Medical Systems EngineerCompany: Medequips Locations: Lahore, Multan, Islamabad, Karachi Qualification: BS Electrical Engineering (Electronics) Reports to: Service / Technical ManagerRole summary Responsible for installing, commissioning, maintaining and supporting advanced medical systems (imaging, diagnostic and critical-care equipment) at hospitals and healthcare facilities, ensuring maximum uptime and patient safety.Key responsibilitiesInstall, commission and calibrate advanced medical systems at customer sitesPerform preventive maintenance...
Property Operations & Client Relations Executive
CS Outsource,
Lahore
6 days ago
Property Operations & Client Relations Executive – Short-Term Rentals (STR)Job SummaryWe are looking for a Property Operations & Client Relations Executive to support the day-to-day operations of our clients' short-term rental properties across the United States. In this role, you will work closely with guests, clients, vendors, and internal teams to ensure smooth property operations, a seamless guest experience, timely...