Associate Data Analyst
Pivot Roots · Jun 2025 – Present
- Owned end-to-end delivery of 70+ analytics dashboards across 25+ clients and 5 markets, translating ambiguous business requirements into scalable reporting solutions using Power BI, Tableau, and Looker Studio for global stakeholders.
- Analyzed 2,000+ campaigns across Google Ads, Meta, LinkedIn, DV360, and GA4 using SQL and Python, breaking complex funnel and audience problems into structured analyses to identify performance drivers and actionable optimization opportunities.
- Built and optimized complex BigQuery SQL pipelines, including multi-source data transformations, data validation, deduplication, campaign-level aggregations, and performance optimization for recurring reports
- Developed advanced Excel-based data solutions using Pivot Tables, XLOOKUP, INDEX-MATCH, SUMIFS, dynamic formulas, data validation, conditional formatting, and Power Query to automate data preparation, reconciliation, and reporting processes.
- Independently built a Marketplace analytics solution from data pipeline to executive dashboard, integrating creative-level image data and Copilot to surface automated insights and identify performance opportunities for stakeholders.
- Developed an AI-driven creative analytics framework using LLMs, Generative AI, and visual attribute analysis to evaluate creatives at scale and connect creative characteristics with funnel KPIs including clicks, registrations, and activations.
- Developed a reproducible consumer spending analytics report using Python, Pandas, and Quarto, creating reusable functions and visualizations to analyze synthetic inflation indicators across consumption categories and urban-rural segments.
