Ecommerce Data Analyst | Power BI, Excel & SQL | Driving RCA, KPI Insights & Performance Marketing Analytics Across D2C & Quick Commerce



Alwar, Rajasthan, India

Remote

New Delhi

Bengaluru

Master of Business Administration - MBA, Data Science and AI
Graphic Era Deemed to be University

Bachelor of Commerce - BCom, Business/Commerce, Digital Marketing
Banasthali Vidyapith
Join Divleen and 10k+ other professionals on
Tal is the app where bosses meet engineers & builders directly, without middlemen
Download Tal BossEcommerce Data Analyst | Power BI, Excel & SQL | Driving RCA, KPI Insights & Performance Marketing Analytics Across D2C & Quick Commerce
I turn messy ecommerce data into decisions that actually move the needle β OSA gaps, ROAS drops, market share shifts, you name it. Power BI Developer at Trailytics AI, working across D2C and quick commerce platforms, building dashboards that don't just look good β they point to root cause. What I do: I build end-to-end BI solutions for ecommerce and quick commerce β from raw SQL data pulls to interactive Power BI dashboards that business teams actually use. My focus is performance analysis: tracking KPIs like On-Shelf Availability, Sell-Through Rate, Market Share, Share of Search, and MRP compliance across SKUs, categories, and regions. Results I've driven: β Built 5+ dashboards that cut stakeholder reporting time significantly β Delivered RCA frameworks for OSA and discount leakage that surfaced actionable gaps in under 24 hours β Supported performance marketing analysis across platforms including Amazon, Blinkit, Zepto, and Swiggy Instamart, Flipkart, Bigbasket β tracking impressions, CTR, CPC, CVR, and ACoS Tools & methods I work with: Power BI Β· SQL Β· Excel Β· Python (scripting & automation) Β· DAX Β· Data Modeling Β· ETL pipelines Β· A/B test analysis Β· Funnel analysis Β· Cohort analysis Currently pursuing MBA in AI & Data Science β applying ML concepts to forecast demand shifts and surface predictive signals within BI workflows. Open to: Data Analyst / Business Intelligence roles in ecommerce, quick commerce, or performance marketing analytics β preferably with a team that moves fast and values data-backed decisions. π© DM me or connect β always happy to talk data, dashboards, or ecom strategy.
Dehradun
Power BI Developer at Trailytics AI, Nov 2025 - Present Β· 7 mos, πππππ: π΅π’ππππππ πππ-π‘π-πππ π΅πΌ π πππ’π‘ππππ πππ π·2πΆ πππ ππ’πππ ππππππππ ππππππ β ππππ ππππππ‘πππ ππ’ππ‘π-ππππ‘ππππ πππππππππ πππ‘π πππ‘π πππ π©ππππππ π‘π©ππ‘ ππππ£π ππππ-π‘πππ ππ’π ππππ π πππππ ππππ πππππ π πππ‘πππππ¦, π π’ππππ¦, πππ ππππππ‘πππ π‘ππππ . ππ‘ππ π ππ¨: -- Built and maintained 5+ production Power BI dashboards using DAX and SQL, unifying data from Amazon, Blinkit, Zepto, and Swiggy Instamart β reducing stakeholder reporting time by 15% and enabling same-day action on SKU-level issues -- Designed RCA frameworks for On-Shelf Availability (OSA) gaps and discount leakage, pinpointing root causes across categories and regions within 24 hours of anomaly detection -- Tracked full-funnel performance marketing KPIs β impressions, CTR, CPC, CVR, ROAS, and ACoS β across 4 quick commerce platforms, supporting data-driven campaign optimization and budget reallocation -- Developed ETL pipelines and data models to consolidate multi-source ecommerce data into unified dashboards, improving reporting accuracy and eliminating manual data consolidation -- Monitored MRP compliance, sell-through rate, and Share of Search across SKUs and geographies β flagging pricing and visibility risks before they impacted revenue -- Partnered with category and marketing teams to translate funnel drop-off patterns and market share shifts into concrete business recommendations, bridging the gap between raw data and strategic action ππ¨π¨π₯π¬ & π¦πππ‘π¨ππ¬: Power BI Β· DAX Β· SQL Β· Python (scripting) Β· Excel Β· ETL Pipelines Β· Data Modeling Β· RCA Analysis Β· Funnel Analysis Β· Ecommerce KPI Tracking Β· A/B Testing
Power BI developer at Trailytics AI, May 2025 - Nov 2025 Β· 7 mos, πΏπππ π‘π©π π΅πΌ πππ’ππππ‘πππ πππ πππππππππ πππππ¦π‘πππ ππππππ‘πππ β ππ’ππππππ πππΏ-ππππ£ππ πππ€ππ π΅πΌ ππππππ‘π πππ πΎππΌ πππ π©ππππππ ππππ π’πππ πππππ¦ ππ¦ π ππππ , π π’ππππ¦ ππ©πππ, πππ πππ‘πππππ¦ π‘ππππ . -- Built Power BI reports powered by SQL data pulls, structuring ecommerce datasets for multi-team consumption across sales and supply chain functions -- Tracked core ecommerce KPIs β OSA, MRP compliance, and sell-through rate β across product categories and regional markets, enabling weekly performance reviews -- Developed Excel-based analysis models for ad-hoc business reporting, accelerating category-level decision turnaround -- Automated data fetch workflows using Python scripts, reducing recurring manual data preparation effort across reporting cycles -- Contributed to DAX calculations and data modeling within a live production Power BI environment, gaining full-stack BI development exposure ππ¨π¨π₯π¬ & π¦πππ‘π¨ππ¬: Power BI Β· SQL Β· DAX Β· Excel Β· Python Β· KPI Reporting Β· Data Preparation
Marketing Lead at Banasthali Vidyapith, Aug 2022 - Jun 2025 Β· 2 yrs 11 mos, Alwar, Rajasthan, India, πΏππ πππππ‘ππ ππππππ‘πππ ππππππ‘ππππ πππππ π π π’πππ£πππ ππ‘π¦ ππππ‘ππππ β π€π©πππ π‘πππππππ ππππππππ πππ‘ππππ πππ πππππ¦π§πππ ππ©πππππ πππππππππππ π π©ππππ ππ πππππ¦π‘ππππ ππππππππ© π‘π πππππ’πππππ‘πππ π π‘πππ‘πππ¦. -- Tracked campaign performance metrics β reach, engagement rate, and CTR β across digital channels, using data analysis to refine content strategy and improve audience targeting -- Built Excel-based marketing performance dashboards to monitor multi-channel KPIs, translating weekly trend data into actionable strategy recommendations -- Managed end-to-end campaign execution across social and digital platforms, iterating on content strategy based on performance data to consistently improve engagement outcomes -- Developed stakeholder reporting frameworks to communicate campaign results to institutional leadership β building presentation and data storytelling skills directly applicable to BI reporting ππ¨π¨π₯π¬ & π¦πππ‘π¨ππ¬: Excel Β· Google Analytics Β· Social Media Analytics Β· Campaign Tracking Β· Stakeholder Reporting
Marketing Intern at VADS GROUP, Jul 2023 - Aug 2023 Β· 2 mos, Remote, ππ©πππ‘-π‘πππ ππππππ‘πππ ππππ π π’πππππ‘πππ πππππ‘ππ πππππ’πππππ‘πππ πππ ππππ‘πππ‘ π π‘πππ‘πππ¦ πππ π π π‘πππ‘ππππ πππππ’πππππ‘ππππ ππππ. -- Supported content creation and digital communication workflows, gaining exposure to campaign planning and multi-channel execution -- Tracked basic engagement metrics across social platforms to evaluate content performance
Social Media Marketing Intern at The Closet Shuffle, Sep 2022 - Oct 2022 Β· 2 mos, New Delhi, ππ’πππππ‘ππ π πππππ πππππ ππππππ‘πππ πππ π π·2πΆ πππ π©πππ πππππ ππ’ππππ πππππ¦ πππππππππ ππππ€π‘π©. -- Created and scheduled social content, monitoring post-level performance metrics to improve engagement rates -- Assisted in tracking follower growth and content reach across Instagram and Facebook
Digital Marketing Intern at Photoshooto, May 2022 - Sep 2022 Β· 5 mos, Bengaluru, π·ππππ‘ππ ππππππ‘πππ πππ‘ππππ π©ππ π π’πππππ‘πππ πππππ π£ππ ππππππ‘π¦ πππ ππππ‘πππ‘ πππππππππππ πππ π ππ©ππ‘ππππππ©π¦ π πππ£ππππ ππππ‘ππππ. -- Managed social media content calendar, tracking engagement and reach metrics to assess channel performance -- Supported SEO and paid campaign monitoring, developing foundational skills in digital performance tracking
Master of Business Administration - MBA, Data Science and AI, Graphic Era Deemed to be University
Bachelor of Commerce - BCom, Business/Commerce, Digital Marketing, Banasthali Vidyapith