buisness intelligence analyst technical

Job Summary:

We are seeking a Technical Business Analyst to bridge the gap between our restaurant operations and technology solutions. You will lead the design and implementation of two critical systems: (1) a billing and sales expenditure tracking system, and (2) a QR-code-based website for customer self-ordering and payment at each table. Your goal is to increase operational efficiency, reduce errors, and enhance the guest experience.

1. Billing & Sales Expenditure System

. Analyze current manual or semi-digital billing processes and expenditure tracking (food cost, labor, overheads).

. Design and document requirements for a unified system that captures:

. Daily sales (per table, per server, per menu item)

. Real-time expenditure (ingredients, supplies, wastage)

. Profitability per dish and per shift

. Work with developers or POS vendors to build or configure the system.

. Ensure integration with accounting software (e.g., QuickBooks, Zoho Books).

. Create automated reports on cost of goods sold (COGS), margins, and expense anomalies.

2. QR Code Ordering Website

. Lead the end-to-end requirements for a mobile-friendly website accessible via QR codes placed on each table.

. Specify the customer journey:

. Scan QR code → View digital menu (with images, allergens, modifiers) → Add to cart → Enter table number → Pay online.

. Integrate payment gateways (Stripe, Razorpay, PayPal, or local UPI/cards).

. Ensure the website syncs orders directly to the kitchen display system (KDS) or POS printer.

. Define requirements for table management (e.g., prevent order mixing, support splitting bills).

. Collaborate with UI/UX designers and developers for a frictionless experience.

3. Integration & Data Flow

. Ensure the QR ordering website pushes data (sales, items, payment status) back to the billing/expenditure system automatically.

. Define API requirements between systems.

. Handle offline scenarios (e.g., website down - fallback to manual billing).

4. Testing & Deployment

. Write test cases for billing accuracy, payment security, and order routing.

. Conduct UAT (user acceptance testing) with restaurant staff.

. Train managers and servers on using the new systems.

5. Ongoing Optimization

. Monitor system performance, order conversion rates, and payment failures.

. Suggest improvements based on sales/expenditure data (e.g., remove low-margin items, adjust pricing).

Required Skills & Experience

. 6+ years as a Business Analyst, Technical BA, or Product Owner in restaurant, retail, or hospitality tech.

. Proven experience designing POS systems and tracking.

. Solid understanding of language platforms, e-commerce checkout flows, and payment gateway integration.

. Ability to write functional requirements, user stories, and process flow diagrams (UML, BPMN).

. Familiarity with restaurant POS (Toast, Square, Micros, or similar) is a strong plus.

. Basic technical knowledge: APIs (REST), databases (SQL), and web technologies (HTML/CSS/JS fundamentals) to communicate with developers.

. Excellent stakeholder management - you will work with chefs, servers, owners, and developers.

. Experience with Jira, Confluence, or Notion for documentation.