Custom E-commerce Analytics Dashboard for Multi-Store Integration

Category: Data Science

Budget: 2350–2350 USDC

We are seeking a data analyst to develop a comprehensive analytics dashboard for our Shopify and Amazon operations. The goal is to consolidate sales, inventory, and marketing spend data into a single source of truth. The project involves building automated ETL pipelines to sync data from three different APIs into a BigQuery warehouse. Deliverables include a real-time Looker Studio dashboard featuring LTV analysis, customer acquisition cost (CAC) tracking, and inventory turnover ratios. The ideal candidate has experience with SQL, API integrations, and e-commerce metrics. We expect a functional prototype within two weeks and a final handover including documentation by the end of the month. Total project timeline is four weeks.

Skills required

• SQL
• Google BigQuery
• Looker Studio
• Python
• ETL

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