Ecommerce Data Analyst – Build Automated Sales, Refund, Dispute

Overview
We are a fast-growing U.S.-based ecommerce brand looking for an experienced Ecommerce Data Analyst to build a robust dashboard that tracks:
- Sales, Refunds, Disputes, COGS breakdown by SKU
- Daily profitability
- Time-based trends
- Cohort analysis and trends
This is NOT basic spreadsheet cleanup.
We need someone who understands ecommerce metrics and profitability analysis.
Project Scope
You will:
Consolidate data from:
Stripe (payments, refunds, disputes)
Dispute management platform
Order management system
COGS data
Build a clean data model that:
Identifies repeating vs new orders
Calculates lost COGS on fulfilled disputed transactions
Calculates refund rate by cohort
Calculates dispute rate by cohort
Create an automated dashboard that shows:
Revenue by SKU
Gross margin by SKU
Refund rate trends
Dispute rate trends
Cohort performance (weekly and monthly)
LTV vs refund/dispute risk (if possible)