Kritika Chauhan
Associate Data Analyst | Media Analytics | Tableau, SQL, Python | Campaign Performance Reporting | AWS Glue, PySpark, ETL | Data Automation & Insights
- Role
- Associate Data Analyst at IPG Mediabrands
- Location
- Lucknow, UP, IN
- LinkedIn followers
- 500 followers
About Kritika Chauhan
Results-driven Associate Data Analyst with hands-on experience across media analytics, campaign performance reporting, and large-scale data engineering. I specialize in transforming raw data into meaningful business insights and building scalable reporting & automation solutions.In my current role, I design and enhance Tableau dashboards to track campaign performance, impressions, CTR, and ROI across platforms — enabling faster, data-driven decision-making for marketing and account stakeholders. I work extensively with SQL and Python to deliver accurate and automated client reporting, improving KPI reliability and reducing manual reporting effort by over 75%.Previously, I worked in a data engineering environment where I developed PySpark-based AWS Glue pipelines, automated ETL workflows, and optimized SparkSQL transformations to improve performance and reduce data discrepancies. I’ve also engineered serverless AWS architectures to significantly reduce data processing latency.I enjoy working at the intersection of data, analytics, product and business teams — enabling organizations to scale insights, improve reporting speed, and drive measurable impact.
Experience
Associate Data Analyst
May 2025 — Present · Pune, IN
Designed and enhanced 8+ Tableau dashboards to track media performance, campaign trends, impressions, CTR and ROI across regions & platforms, enabling faster, data-driven decisions for marketing and account stakeholders.Developed and optimized 100+ SQL queries for campaign analytics and revenue tracking, improving KPI accuracy to >95% and reducing reporting discrepancies by ~70% across channels.Automated weekly and monthly media performance & client reporting using Python (pandas)+ SQL outputs + Tableau Server scheduling, cutting manual effort from ~8 hrs to ~2 hrs/week and increasing dashboard adoption by ~40%.Conducted trend, cohort and audience-segment analysis that identified 3 high-growth channels / audience clusters, supporting optimization initiatives that contributed to ~10–15% MoM uplift in key campaigns.
Education
Graphic Era Deemed to be University
Bachelor of Technology - BTech, Computer Science
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.