Full-Stack Data Engineer (Python / FastAPI / SQL) – Restaurant Analytics Dashboard

We operate a fast-growing beverage concept in California and are building an internal operating system to power multi-store expansion.

We are looking for a highly capable Full-Stack Data Engineer to help design and build our internal analytics dashboard.

This is NOT a basic web developer role.

You will help build a real-time operating intelligence system that integrates:

• Toast POS API
• 7shifts (labor scheduling)
• Inventory and recipe cost tables
• Customer loyalty and retention data
• Review sentiment tracking

Your work will directly impact business decisions, expansion strategy, labor optimization, and profitability.

This is a long-term role for someone who thinks architecturally, not just executes tasks.

RESPONSIBILITIES

• Design and implement data pipelines (API ? database ? metrics ? dashboard)
• Build and maintain FastAPI backend services
• Design clean and scalable PostgreSQL schemas
• Implement metric calculations (CPLH, contribution margin, retention rates, etc.)
• Create dashboards (React frontend preferred)
• Build alert systems (threshold-based notifications)
• Write clean, documented, maintainable code
• Proactively suggest architecture improvements

REQUIRED EXPERIENCE

• Strong Python development experience
• Experience integrating external APIs
• Strong SQL knowledge
• Experience building dashboards or analytics systems
• Experience designing database schemas
• Able to work independently and propose solutions

Bonus:
• Experience with POS systems
• Experience with ETL/data pipelines
• Familiarity with FastAPI
• Familiarity with React