Business Analyst

Part-Time Business Analyst (eCommerce Subscription Business)We're a fast-growing eCommerce subscription company looking for a part-time Business Analyst to help us track performance, uncover insights, and drive smarter decisions.You'll gather data from multiple platforms, organize it into clean dashboards, and translate numbers into clear stories that help guide growth.ResponsibilitiesBuild and maintain KPI dashboards for revenue, retention, churn, CAC, LTV, AOV, and fulfillmentPull and clean data from Shopify, QuickBooks, Google Sheets, and marketing channelsIdentify trends, risks, and opportunities in financial and operational dataProvide weekly and monthly summaries with actionable insightsCreate simple, repeatable systems for reporting and analysisRequirements3+ years experience in business analysis, FP&A, or data analyticsProficiency in Google Sheets or Excel (pivot tables, formulas, charts)Strong understanding of subscription metrics (CAC, LTV, MRR, churn, ARPU)Familiarity with Shopify, QuickBooks, and common eCommerce data sourcesExcellent communication skills — able to explain insights clearly and visuallyDetail-oriented, organized, and proactiveDeliverables: Weekly KPI dashboard (LTV, CAC, churn, retention, MRR, AOV, active subs, new vs. canceled)Monthly performance summary with trends, insights, and key takeawaysClean, reliable data pulled from Shopify, QuickBooks, and marketing platformsCohort analysis showing subscriber retention and churn patternsLTV:CAC ratio tracking and payback period calculationsFinancial snapshot: revenue, COGS, margins, and contribution profitDocumented reporting process (data sources, update steps, definitions)Ad-hoc analysis to answer strategic questions or model "what-if" scenarios