Associate Data Analyst - CSA

Havas Group; Mumbai City; On-site; INR 600,000 - 1,000,000; Full time

Job summary

PivotRoots is seeking a Data Analyst to support performance marketing and campaign analysis across multiple media platforms. You will manage end-to-end data pipelines and deliver dashboards using Looker Studio and Power BI, integrating data from Google BigQuery and CRM systems.

You will collaborate with account POCs, data engineering, and clients to provide accurate reporting, ensure data quality, and translate insights into actionable recommendations for stakeholders.

Qualifications

• Bachelor’s degree in Engineering, Data Science, Statistics, or a related field.
• 0–2 years of experience in data analytics;experienced candidates preferred.
• Proficiency in SQL and Data Visualization Tools (e.g., Looker, Tableau, Power BI).
• Basic understanding of digital marketing platforms (Google Ads, Meta Ads, DV360, etc.) and their metrics.
• Strong Excel and Analytical skills
• Excellent communication skills and ability to tell a compelling story through data.
• Attention to detail and a structured approach to problem-solving

Responsibilities

• Analyze marketing campaigns across various digital media platforms (Google Ads, Meta, YouTube, Programmatic, etc.) to assess performance and identify improvement areas.
• Support the stakeholder requirements gathering process by validating stakeholder requirement forms and ensuring data source access
• 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.
• Document processes and maintain standard conventions for data transfers, tables, and dashboards

Skills

SQL

Data storytelling

Excel

Analytical skills

Education

Bachelor’s degree in Engineering, Data Science, Statistics

Tools

Looker Studio

Power BI

Tableau

Google BigQuery

Job description

Agency :

PivotRoots

Job Description :

We are looking for a skilled Data Analyst to support performance marketing and campaign analysis across multiple media platforms. This role is responsible for managing end-to-end data pipelines, from requirements gathering to dashboard delivery. You will work with data from multiple paid media platforms, CRM systems, and other digital sources using tools likeGoogle BigQuery,Data Fetch Tools, andData Visualisation Tools (Looker Studio, Power BI). You will collaborate closely with Account POCs, Data Engineering, and clients to deliver accurate and actionable reporting solutions.

Key Responsibilities:

• Analyze marketing campaigns across various digital media platforms (Google Ads, Meta, YouTube, Programmatic, etc.) to assess performance and identify improvement areas.

• Support the stakeholder requirements gathering process by validating stakeholder requirement forms and ensuring data source access

• 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.

• Document processes and maintain standard conventions for data transfers, tables, and dashboards
  

Qualifications:

• Bachelor’s degree in Engineering, Data Science, Statistics, or a related field.

• 0–2 years of experience in data analytics;experienced candidates preferred.

• Proficiency in SQL and Data Visualization Tools (e.g., Looker, Tableau, Power BI).

• Basic understanding of digital marketing platforms (Google Ads, Meta Ads, DV360, etc.) and their metrics.

• Strong Excel and Analytical skills

• Excellent communication skills and ability to tell a compelling story through data.

• Attention to detail and a structured approach to problem-solving

Contract Type : Permanent

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.

Contract Type :

Permanent

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.