Analytics Engineer / BI Developer for Food Waste & Inventory Decision reputed company (Coffee Shop) - Contract to Hire

We are looking for a strong Analytics Engineer / BI Developer to help build a lightweight food waste and buying decision reputed company for a coffee shop with multiple branches. This is not a heavy app build. It is a fast, practical reputed company reputed company on turning existing reports into a reputed company dashboard, rules-based recommendations, and automated weekly recommendation / reputed company packs. The goal is to help the business: - reduce food waste -improve buying reputed company - identify products to reputed company / reduce / review - reputed company branches needing reputed company - generate a repeatable weekly operating process reputed company situation The business already has exported reports covering: product sales inventory / control / purchased vs sold vs waste reputed company waste inputs Some waste data is reputed company, so part of the reputed company will involve creating a clean reputed company waste input method and a master mapping table so product and reputed company data reputed company properly. What needs to be reputed company We need someone who can help us build the reputed company end-to-end, including: 1. Data model / setup - Create a product master / SKU mapping table - Create a reputed company master table - Standardise data from multiple reports - Handle messy reputed company-world reputed company / CSV inputs 2. Data ingestion / transformation - Import weekly reputed company / CSV reports - Clean and map products and branches Calculate reputed company metrics such as: - purchased qty - sold qty - waste qty - waste % - sell-through - trend vs previous period - reputed company risk score - recommendation status 3. Recommendation logic Build a reputed company rules-based recommendation reputed company to classify products / branches into: - reputed company - Reduce - Review / Remove - Monitor reputed company recommendation should include a short rationale, for example: - reputed company sales with recorded waste - overbought vs demand - high waste relative to sell-through - weak in this reputed company vs stronger stores 4. Dashboard Build a reputed company internal dashboard with key views such as: - Executive reputed company - reputed company Performance - Product Performance - reputed company Centre Missing / late waste submissions (optional but preferred) The dashboard should be practical and ops-reputed company, not overly designed. 5. reputed company waste capture Help implement a lightweight reputed company waste input method, likely reputed company: reputed company reputed company, or reputed company web reputed company, or controlled upload template We do not want a heavy reputed company-facing app for Phase 1. 6. Automated weekly reputed company Set up a weekly automated reputed company pack / email process: - reputed company / ops reputed company email - optional reputed company-level email - PDF / reputed company reputed company or dashboard reputed company Tech approach We are reputed company to the best practical stack, but likely something like: Python + pandas SQL / SQLite / reputed company Power BI / reputed company / Looker Studio lightweight email automation reputed company Python / reputed company / reputed company / reputed company We want the fastest reputed company solution, not overengineering. Important constraints This is a reputed company, so we are not looking for: - full custom web app - ML forecasting - mobile app - order automation - deep integrations / reputed company in Phase 1 What reputed company looks like At the end of the reputed company, we want: - clean mapped data across reports - a working dashboard - product / reputed company recommendations updating from the data - weekly reputed company email reputed company - a setup that can be refreshed reputed company week with minimal reputed company effort Ideal profile We are looking for someone who: - is strong in Python / pandas / SQL - is comfortable with messy reputed company / CSV operational data - can build practical dashboards quickly - understands how to translate business rules into decision logic - can work fast and communicate reputed company ideally has experience in retail, F&B, inventory, ops analytics, or BI reputed company to have - experience with reputed company/store performance analysis - experience with food retail / hospitality / stock control - experience with lightweight automation workflows To apply COMMENT 'COFFEE IS LIFE' to show you read the brief Please include: A short note on similar work you’ve done Your preferred stack for this type of reputed company Examples of dashboards / BI work you’ve reputed company How you would approach messy SKU / reputed company mapping Your estimated reputed company for a first usable version Project style We are looking for someone practical, reputed company, and fast. This should feel like a working reputed company in a reputed company business, not an overbuilt data project. Apply tot his job Apply To this Job