HumanBit Logo

Consultantyst | Scrabble & Jigsaw

full-time
Posted on 17-11-2026

Job Description

Business Analyst

Job Summary

We are seeking a Business Analyst to bring structure to QUA’s business data and enable better, faster decision-making. This role involves working across sales, marketing, inventory, product, and finance functions to consolidate data, build insightful dashboards, and uncover actionable insights that directly impact business performance.

Responsibilities

  • Revenue & Commercial Analytics: Manage weekly and monthly analyses of revenue, orders, average order value (AOV), average selling price (ASP), conversion rates, units per order, discounting, new vs repeat customers, and category/style/SKU performance. Provide explanations for changes and underlying causes.
  • Inventory & Merchandising Analytics: Develop SKU × size × colour views covering sell-through rates, stock cover, ageing, stock-outs, lost-sales risk, size imbalances, incoming stock, reorder needs, and markdown candidates. Support decisions on production quantity and timing.
  • Customer & Cohort Analytics: Own acquisition cohorts, 30/60/90-day repeat rates, retention, lifetime value (LTV), first-to-second product purchase behavior, customer segmentation, return behavior, and revenue from new vs returning customers.
  • Marketing & Funnel Analytics: Link traffic and acquisition spend to landing page/product detail page (PDP) performance, conversion rates, customer acquisition cost (CAC), marketing efficiency ratio (MER)/return on ad spend (ROAS), return-adjusted revenue, repeat behavior, and contribution. Analyze Meta, Google, and CRM performance without acting as a media buyer.
  • Management Information System (MIS) & Root-Cause Analysis: Run weekly business scorecards and independently investigate variances such as revenue decline, rising CAC, poor conversion, inventory build-up, return spikes, margin deterioration, or cash burn.
  • Forecasting & Decision Support: Assist with revenue forecasts, inventory requirements, production priorities, sale/markdown decisions, pricing tests, new category analysis, store economics, and other strategic questions at the founder level.
  • Reporting Automation & Data Quality: Automate recurring reports using SQL, Power Query, and business intelligence (BI) tools; reconcile source systems; document metric definitions; reduce manual spreadsheet work; and prevent multiple versions of the truth.

Qualifications

  • Advanced proficiency in Excel/Google Sheets including XLOOKUP, INDEX-MATCH, SUMIFS, pivot tables, Power Query, scenario modeling, and cohort calculations.
  • Strong SQL skills: joins, common table expressions (CTEs), GROUP BY, CASE statements, window functions, date logic, deduplication, and understanding data grain.
  • Experience with BI tools such as Power BI, Tableau, or Looker Studio; ability to build decision-useful dashboards beyond visual reports.
  • Solid understanding of business fundamentals: revenue, gross margin, contribution, EBITDA, cash flow; inventory turns, stock cover, sell-through, and working capital.
  • Knowledge of e-commerce analytics: CAC, AOV, conversion rate (CVR), LTV, MER, ROAS, repeat purchase rates, returns, return to origin (RTO), customer cohorts, and funnel analysis.
  • Excellent communication skills: able to explain complex analyses succinctly using the framework Observation → Cause → Impact → Action, including assumptions and confidence levels.

Preferred Skills

  • 3-5 years of experience in business analytics, financial planning & analysis (FP&A), or a similar analytical role.
  • Experience in direct-to-consumer (D2C), e-commerce, apparel/fashion, retail, consumer internet, marketplaces, or omnichannel consumer businesses.
  • Hands-on exposure to order, inventory, marketing, and customer data; marketplace-only reporting experience alone is insufficient.
  • Familiarity with Shopify, Google Analytics 4 (GA4), Meta platforms, Google Ads, ERP-Warehouse Management Systems (WMS), or finance MIS is advantageous but not mandatory if analytical fundamentals are strong.
  • Educational background in engineering, mathematics, statistics, economics, commerce, or an MBA; demonstrated analytical capability is valued over degree prestige.

Experience

  • 3 to 5 years of relevant experience in business analytics or related analytical roles.

Environment

  • The role involves cross-functional collaboration across sales, marketing, inventory, product, and finance teams.
  • Specific location and work setting details are not provided.

Why Join QUA?

  • Opportunity to work directly with the founders, influence financial decisions, and contribute to sustainable scaling.
  • Chance to build the business intelligence function from the ground up, shaping systems and frameworks that drive business decisions.
Powered by
HumanBit Logo