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.