Custom E-commerce Analytics Dashboard for Multi-Store Integration

Category: Data Science

Budget: 2350–2350 USDC

We are seeking a data analyst to build a unified analytics dashboard that aggregates sales data from three separate Shopify stores and one Amazon Seller account. The project involves setting up a centralized data warehouse using Google BigQuery and visualizing key performance indicators such as Customer Acquisition Cost (CAC), Lifetime Value (LTV), and inventory turnover rates in Looker Studio. The successful candidate must create automated ETL pipelines to ensure daily data refreshes and implement custom filtering by region and product category. Deliverables include the backend data infrastructure, a fully interactive dashboard with five primary tabs, and documentation for future maintenance. We expect the initial setup and testing to be completed within a four-week timeline, including a one-week period for final adjustments based on stakeholder feedback.

Skills required

• SQL
• Google BigQuery
• Looker Studio
• ETL
• Data Visualization

Milestones are funded into USDC escrow on Polygon before work begins.