Open to opportunities

Priyanka Kapoor

@priyankakapoor1

Message

I’m a Senior Marketing Data Analyst who turns data into KPI-driven, real-time reporting.

United States

Message

What I'm looking for

I’m looking for a role where I can own KPI reporting and analytics automation—building SQL/Python pipelines, GA4 tracking, and interactive dashboards—so executives get faster, accurate real-time insights and stakeholders need fewer manual queries.

I’m a data analyst focused on building automated, KPI-first reporting systems that help stakeholders move faster with confidence. Across marketing, merchandising, and product analytics, I prioritize clarity, accuracy, and real-time decision support.

Most recently, as a Marketing Data Science Intern at OMG23–OMNICOM MEDIA GROUP, I optimized reporting workflows with a centralized data product, improving efficiency by 90% and saving 120+ hours of manual work. I also automated 4+ ETL pipelines for real-time campaign tracking and designed Streamlit dashboards with 96% accuracy in executive performance reporting.

In prior Senior Marketing Data Analyst work at Meesho, I orchestrated data workflows and reporting systems to boost KPI visibility while saving executives 5+ days per quarter. I automated multi-sourced data integration with tagging alignment to keep CRM and adplatform data clean, and implemented real-time KPI tracking that reduced stakeholder query response times by 15 hours/month.

I’ve delivered measurable impact end-to-end—SQL/Python analysis, forecasting and predictive modeling, and dashboard delivery. At Lenskart.com, my SQL and Python funnel analysis helped increase average order value by 7%, while migration from Excel-based planning to Python scripts reduced forecast errors by 22%, alongside real-time dashboards that improved data accessibility by 80% and decision-making efficiency by 90%.

Experience

Work history, roles, and key accomplishments

Data Analyst - University Analytics

Montclair State University

Aug 2024 - Dec 2025 (1 year 4 months)

Maintained SQL pipelines supporting Tableau dashboards for timely MBA/MSBA leadership insights. Built KPI and advising models in Power BI and led a GA4 migration using a tagging strategy for automated real-time data capture.

SQL Tableau Power BI GA4 Data Tagging KPIs KPI Reporting

Marketing Data Science Intern

OMG23–Omnicom Media Group

Jun 2025 - Aug 2025 (2 months)

Optimized reporting workflows with a centralized data product, improving efficiency by 90% and saving 120+ hours of manual work. Automated 4+ ETL pipelines and built Streamlit dashboards for real-time campaign tracking and executive performance reporting.

ETL Data Pipelines Streamlit Report Automation Campaign Tracking Data Integration

Senior Marketing Data Analyst

Meesho

May 2022 - Aug 2024 (2 years 3 months)

Orchestrated data workflows and reporting systems to boost KPI visibility and save executives 5+ days per quarter. Automated multi-sourced data integration with tagging alignment across CRM and ad platforms and implemented real-time KPI tracking to reduce stakeholder query response times by 15 hours/month.

Data Integration CRM Ad Platforms KPI Reporting Real Time Analytics

Senior Analyst - Merchandising

Lenskart.com

Sep 2021 - Apr 2022 (7 months)

Used SQL and Python funnel analysis to identify user drop-offs, increasing average order value by 7%. Migrated Excel-based demand planning to Python scripts (reducing forecast errors by 22%) and implemented scalable real-time dashboards that improved data accessibility by 80% and decision-making efficiency by 90%.

SQL Python Funnel Analysis demand planning Forecasting Data Visualization

Product Analyst

Amazon

Mar 2021 - Aug 2021 (5 months)

Analyzed product and inventory data across 1,000+ SKUs using SQL and Excel to guide assortment and replenishment decisions, reducing overstock and procurement costs.

SQL Excel Inventory Analytics Assortment Analytics