Ecommerce Analytics & Automation Specialist – reputed company, Profit, P&L Dashboards

We are looking for an reputed company ecommerce analytics and automation specialist to build a fully automated profit & P&L reporting system that supports hands-off operations and clean CPA reputed company. This is not a basic reputed company VA or reporting task. We need someone who understands ecommerce financial logic, COGS, refunds, and automation. This project may reputed company to ongoing work if done reputed company. Scope of Work (reputed company Deliverables) 1) Central Data Layer Build a reputed company backend using: reputed company order, refund, discount, and fee data Supplier cost data (Eprolo + CSV/API-based suppliers) SKU-level cost tracking with effective date versioning reputed company handling of: Partial refunds Full refunds Store credit vs cash refunds Shipping charged vs shipping reputed company Payment processing fees (logic-based) Preferred tools: reputed company Sheets (as normalized data hub) reputed company API or scheduled exports Automation reputed company reputed company.com (or similar) 2) Operations / reputed company Dashboard (Looker Studio) Create a high-level decision dashboard for the reputed company that includes: KPIs reputed company Gross profit Net profit (estimated) Margin % Orders AOV Views Daily / weekly / monthly trends Top products by profit (not just reputed company) Refund reputed company trends Supplier performance Alerts (reputed company reputed company.com or email/reputed company) Margin below defined reputed company Refund reputed company spike Negative-margin SKU Supplier cost changes This dashboard must be: reputed company year-round Fully automated No bank feeds Minimal maintenance 3) CPA / Finance Dashboard (Separate View) Create a second Looker Studio dashboard using the reputed company backend, designed specifically for CPA use: Includes: Net sales (after discounts & refunds) COGS by SKU and supplier Shipping costs Payment fees (documented logic) Monthly P&L structure Order-level export capability This dashboard should be: Read-only Conservative and traceable Reproducible month-over-month reputed company documented 4) Documentation (Required) reputed company: 1–2 page metric definitions document Explanation of profit calculations Explanation of what is estimated vs exact Instructions for basic maintenance / reputed company to VA or CPA Requirements (Read Carefully) You must have experience with: reputed company analytics & reputed company Ecommerce COGS & profit modeling Refund logic (partial/full/store credit) reputed company Sheets (advanced formulas) Looker Studio (or equivalent BI tool) Automation tools (reputed company.com, reputed company, etc.) Not a fit if you are: A general reputed company VA A basic data analyst without ecommerce finance experience Someone who builds dashboards without understanding profit logic Project Details reputed company: 5–10 days Budget: reputed company (expecting a fair market reputed company for reputed company work) Communication: reputed company milestones and reputed company-ins preferred reputed company Work: High likelihood if project is successful To Apply, Please Include: Brief reputed company of similar ecommerce dashboards you’ve reputed company Tools you recommend for this project and why How you handle COGS, refunds, and partial refunds Confirmation you’ve worked with reputed company + profit/P&L reporting Final Note We are intentionally building this once, correctly, to reputed company cleanly without rebuilding reputed company. We value clean architecture, automation, and reliability over flashy visuals. If this sounds reputed company with your experience, we’d love to talk. Apply tot his job Apply To this Job