Ajay Rawat
Data Analyst || Social Media & Marketing Analytics || Dashboard & Data Visualization Expert || Looker Studio || Google Sheets
- Role
- Senior Data Analyst at Degree 360 Solutions Pvt. Ltd
- Location
- New Delhi, DL, IN
- LinkedIn followers
- 500 followers
About Ajay Rawat
Experienced Data Analyst with a strong background in data-driven decision-making…
Experience
Senior Data Analyst
Sep 2024 — Present · Delhi, IN
Monitored social media daily using Meltwater, identifying trending tweets, breaking news, and public sentiment shifts. Tracked audience behavior and engagement patterns to inform content strategy.Managed and queried large-scale datasets in Google BigQuery, ensuring optimized, scalable data infrastructure for advanced analysis of digital trends and campaign performance.Performed data cleaning and transformation using Google Sheets, leveraging formulas, pivot tables, and conditional formatting to create quick, insightful summaries and visualizations.Designed dynamic dashboards and performance reports in Looker Studio, visualizing key content metrics (e.g, reach, engagement, impressions) to communicate insights clearly to stakeholders.Analyzed performance data across YouTube, Instagram, and X (Twitter), uncovering audience demographics, behavior patterns, and content preferences to refine outreach and posting strategies.Generated actionable insights from real-time public online data, contributing to data-driven decision-making in communication strategies, campaign design, and stakeholder reporting. Identified KPIs, benchmarked performance, and tracked campaign ROI, translating complex analytics into recommendations that improved targeting and audience engagement. Collaborated cross-functionally with content, PR, and digital teams, ensuring insights from social listening and platform data were integrated into broader communication plans.
Education
Delhi University
Bachelor of Commerce - BCom
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.