E-commerce Customer Retention Analysis and Dashboard Development

Category: Data Science

Budget: 1525–1525 USDC

We are seeking a data analyst to perform a deep dive into our Shopify store's historical sales data from the past 24 months. The primary objective is to identify key drivers of customer churn and segment our audience based on CLV (Customer Lifetime Value). You will be responsible for cleaning the raw CSV exports, identifying purchasing patterns, and calculating month-over-month retention rates. The final deliverables include a comprehensive technical report summarizing your findings and an interactive dashboard built in Tableau or Power BI that allows our marketing team to filter performance by product category and acquisition channel. We expect the project to be completed within three weeks, with a preliminary insights meeting scheduled at the ten-day mark. The ideal candidate has experience with retail datasets and a strong ability to translate complex statistical findings into actionable business recommendations for a non-technical audience.

Skills required

• Python
• Tableau
• SQL
• Cohort Analysis
• Data Visualization

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