Urgent Requirement of E-commerce Data Analyst(Google Sheets &Ad Excel)

Advanced About the Role

We're looking for a sharp, detail-oriented E-Commerce Operations & Analyst to join our growing team. You'll own real workflows, work with live data, and make decisions that directly impact revenue, customer experience, and operational efficiency across multiple e-commerce channels.
If you're someone who notices what's broken before anyone else does, loves turning messy data into clear action, and wants to learn how modern e-commerce runs at scale this role is for you.

Role & responsibilities:

Focus on e-commerce-specific skills paired with your emphasized tools.

• Google Sheets: Pivot tables, QUERY/IMPORTRANGE functions, conditional formatting, data cleaning, and real-time collaboration for sales dashboards.
• Advanced MS Excel: V LOOKUP/INDEX-MATCH, Pivot Tables, Power Query, SUM IFS, and charts for inventory analysis.
• Analyse sales, customer, and inventory data using Google Sheets and Excel to derive actionable insights.
• Build dashboards for KPIs like conversion rate, CLV, and churn using pivot tables and charts.
• Clean and transform datasets with formulas (V LOOKUP, QUERY) and Power Query.

Required Skills:

Skills- Google Sheets , MS Excel , Data Analysis

Proficiency Level- Advanced , Advanced, Intermediate

E-commerce Application:

i). Dynamic reports, IMPORTRANGE for multi-source data

ii). PivotTables, INDEX-MATCH for sales forecastng

iii). Metrics like AOV, cart abandonment