Data Engineer for Restaurant Sales & Inventory Analytics
Budget: $20.0 - $30.0
HOURLY / PART_TIME
⭐ 0.00 (0)
United States
data-analysis, analytics, tableau, sas
Preferred qualifications
- Experience: Intermediate
Seeking an experienced Data Engineer to build a centralized data platform for a multi-location restaurant business, integrating POS transactions, inventory, vendor purchasing, and labor costs into reliable operational reporting.
The goal is to automate data collection, improve financial reconciliation, and provide accurate visibility into food costs, inventory variance, and location-level profitability.
Responsibilities:
- Develop automated ETL/ELT pipelines connecting Toast POS, inventory systems, vendor invoices, and payroll data.
- Design and maintain a scalable SQL data warehouse.
- Implement sales, refunds, discounts, and payment reconciliation.
- Create standardized data models for food costs, inventory usage, labor expenses, and profitability.
- Develop Power BI dashboards with daily operational KPIs.
- Implement data validation, monitoring, and automated refresh workflows.
Required Skills:
Python, SQL, REST APIs, ETL/ELT, cloud data warehousing, and Power BI.
Experience with Azure, dbt, restaurant POS integrations, or inventory analytics is preferred.
Initial Deliverable:
A production-ready data pipeline and reporting dashboard for one restaurant location, designed for expansion across additional locations.
To Apply:
Share a relevant data engineering project, your preferred technology stack, and your approach to reconciling inconsistent POS and inventory records.
Open job
AI proposal draft
Generate a short cover letter to copy into the offer. Says you are interested and ready to work.
Sign in to generate an AI proposal draft.
Log in