Financial Data Analyst Needed for Shopify SKU Profitability & Margin Audit at Upwork | UnseenRoles
Financial Data Analyst Needed for Shopify SKU Profitability & Margin Audit
Upworkยท
viaUpwork
RemoteContractorPublic
Anywhere42d ago
Job Description
We are a growing Shopify DTC brand generating strong top-line revenue, but we are experiencing diminishing net cash flow and lack visibility into our product-level variable costs. We need an experienced financial modeler to build a comprehensive SKU Profitability and Operational Margin Audit.
Our operations have scaled to over 30 SKUs with varying shipping weights, bundle configurations, and fulfillment costs. We need an expert to integrate our raw Shopify sales data, 3PL rate cards, and COGS sheets to determine our actual unit economics.
Deliverables required:
A clean, automated Excel dashboard calculating true landed contribution margin for each SKU (deducting COGS, dimensional freight fees, pick-and-pack, processing fees, and blended CAC).
A "Margin Killers" summary table isolating products that are generating net cash losses on every transaction.
Visual waterfall charts showing the exact cost structure breakdown for underperforming items.
Operational inventory flags highlighting SKUs with low turnover rates that are tying up working capital.
Requirements:
Advanced Microsoft Excel skills (Financial Modeling, Data Analysis, Dashboard creation).
Experience analyzing e-commerce data (Shopify, 3PL fulfillment structures, acquisition costs).
Ability to deliver a polished, executive-ready dashboard.
Financial Data Analyst Needed for Shopify SKU Profitability & Margin Audit
Upwork ยท Anywhere
New
Decision Maker
Daniel Mercer
Head of Engineering
Hiring Team
+3 team members
Advanced Hiring Intelligence
Explore the hiring team for this profile. Go beyond the job board to find decision-makers.