Senior Data Analyst- CSA

PivotRoots; Gurugram District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

PivotRoots Digital Private Limited in Gurugram is seeking a data analytics professional to analyze marketing campaigns across digital channels, leverage ADH, and derive actionable insights. Build dashboards tracking CAC, ROAS, LTV, and conversions, ensuring data quality across platforms.

You will communicate findings to both technical and non-technical stakeholders, translate data into clear recommendations, and contribute to strategy with strong SQL and visualization skills and storytelling

Qualifications

• Bachelor’s degree in Engineering, Data Science, Statistics, or a related field.
• 2+ years of experience in data analytics.
• Strong experience with Google Ads Data Hub (ADH) or media platforms (Google Ads, Meta Ads Manager, DV360, etc.).
• Proficiency in SQL and data visualization tools (e.g., Looker, Tableau, Power BI).
• Solid understanding of digital marketing metrics, attribution models, and media effectiveness.
• Strong Excel and analytical skills; experience with Python or R is a plus.
• Excellent communication skills and ability to tell a compelling story through data.

Responsibilities

• Analyze marketing campaigns across various digital media platforms (Google Ads, Meta, YouTube, DV360, etc.) to assess performance and identify improvement areas.
• Leverage Google Ads Data Hub (ADH) to perform granular campaign analysis and derive privacy-safe insights.
• Develop and maintain dashboards and reports tracking KPIs including CAC, ROAS, LTV, and conversion metrics.
• Ensure data quality and consistency across platforms, managing large and complex datasets.
• Translate insights into clear, actionable recommendations and present findings to both technical and non-technical stakeholders.

Skills

SQL

Data visualization

Analytical thinking

Communication

Education

Bachelor’s degree in Engineering, Data Science, Statistics

Tools

Google Ads Data Hub (ADH)

Looker

Tableau

Power BI

Excel

Job description

Key Responsibilities

• Analyze marketing campaigns across various digital media platforms (Google Ads, Meta, YouTube, programmatic, etc.) to assess performance and identify improvement areas.
• Leverage Google Ads Data Hub (ADH) to perform granular campaign analysis and derive privacy-safe insights.
• Develop and maintain dashboards and reports tracking key performance indicators (KPIs), including CAC, ROAS, LTV, and conversion metrics.
• Ensure data quality and consistency across platforms, managing large and complex datasets.
• Translate insights into clear, actionable recommendations and present findings to both technical and non-technical stakeholders.

Qualifications

• Bachelor’s degree in Engineering, Data Science, Statistics, or a related field.
• 2+ years of experience in data analytics.
• Strong experience working with Google Ads Data Hub (ADH) or media platforms (Google Ads, Meta Ads Manager, DV360, etc.).
• Proficiency in SQL and data visualization tools (e.g., Looker, Tableau, Power BI).
• Solid understanding of digital marketing metrics, attribution models, and media effectiveness.
• Strong Excel and analytical skills; experience with Python or R is a plus.
• Excellent communication skills and ability to tell a compelling story through data.

Here at Havas across the group we pride ourselves on being committed to offering equal opportunities to all potential employees and have zero tolerance for discrimination. We are an equal opportunity employer and welcome applicants irrespective of age, sex, race, ethnicity, disability and other factors that have no bearing on an individual’s ability to perform their job.