Freelance Opportunity | Power BI Developer / Business Intelligence Consultant
We are looking for an experienced Power BI Freelancer to build a comprehensive CEO Dashboard for our fashion e-commerce company, Maaesa Creations.
We are a growing women's fashion brand with an annual turnover of approximately ₹15 Crore, selling across multiple marketplaces and our own D2C website. We are looking for someone who can transform our business data into actionable insights for leadership.
Scope of Work
Build an interactive Power BI dashboard covering:
Sales Analytics
- Daily, Weekly & Monthly Sales
- Channel-wise Performance (Amazon, Myntra, Ajio, Flipkart, Shopify, etc.)
- SKU & Category Performance
- Sales vs Targets
Inventory Dashboard
- Stock Availability
- Inventory Ageing
- Fast & Slow Moving Products
- Stock-out Alerts
Profitability Dashboard
- Gross & Net Margins
- Marketplace-wise Profitability
- Product-wise Contribution
- Ad Spend vs Revenue
CEO Dashboard
- Daily Sales
- MTD vs Target
- Channel-wise sales
- SKU-wise sales
- Category-wise sales
- Top 20% SKUs contributing 80% revenue
Profitability Dashboard
- Gross Margin
- Net Margin
- Marketplace-wise profitability
- Ad Spend vs Revenue
- Contribution Margin
Ad Alerts
- Campaigns wasting money
- Winning campaigns
- Best ROAS products
Action List
The most important section.
Example:
- Replenish Style MAA-245 immediately.
- Increase Meta budget on Kaftan campaign.
- Push inventory to Myntra warehouse.
- Reduce inventory of Style MAA-112.
- Launch new color in best-selling shirt.
AI Marketplace Growth Agent
A custom GPT trained on:
- Myntra reports
- Ajio reports
- Amazon reports
- Ad spend data
Every morning it should answer:
- Which SKU is losing rank?
- Which SKU is out of stock?
- Which SKU needs ads?
- Which marketplace is underperforming?
- Which category is growing?
This is likely the single most useful AI tool for Maaesa management.
Instead of reading 20 reports, you read one page.
Preferred Skills
✅ Power BI (Advanced)
✅ DAX & Power Query
✅ SQL (Preferred)
✅ Experience with e-commerce and marketplace analytics
✅ Ability to connect multiple data sources (Excel, Google Sheets, Shopify, Amazon, Tally, Unicommerce, APIs, etc.)
Engagement
- Project-based Freelance Assignment
- Remote
- Immediate Start
Interested candidates, please send:
- Your portfolio or sample dashboards
- Relevant e-commerce projects you've worked on
- Expected project cost
- Estimated timeline
- Contact details
Pay: ₹20,000.00 - ₹40,000.00 per month
Benefits:
Work Location: Remote
