Data Scientist- CSA

PivotRoots; Mumbai; On-site; INR 1,500,000 - 2,600,000; Full time

Job summary

PivotRoots is seeking a data science/analytics professional in Mumbai to build and maintain predictive models for marketing and sales. You will develop lead scoring and churn predictions, and design MMM studies to guide budget allocation. Strong Python and SQL skills, plus GCP experience, are essential.

You will work with client teams to translate model outputs into actionable recommendations and stay current with marketing measurement approaches.

Qualifications

• Strong Python and SQL skills for data analysis and ML workflows.
• Experience building lead scoring and churn prediction models.
• Familiarity with Marketing analytics concepts and MMM is a plus.
• Ability to communicate findings to non-technical stakeholders.

Responsibilities

• Build and maintain lead scoring models to prioritize high‑intent customers.
• Develop churn prediction models to support retention strategies.
• Design Media Mix Modeling studies to measure marketing effectiveness.
• Write efficient SQL queries on large marketing and transactional datasets.
• Build data pipelines and models in Python and deploy on GCP.
• Translate model outputs into actionable marketing recommendations.

Skills

Python for data analysis

SQL proficiency

GCP BigQuery

Lead scoring

Churn prediction

Media Mix Modeling

Data storytelling

Communication to stakeholders

Education

Bachelor's/Master's in Statistics, CS, Data Science, Economics

Tools

BigQuery

Looker Studio

Power BI

Cloud Run/Functions

Job description

Job Description:

Key Responsibilities

• Build and maintain lead scoring models to prioritize high-intent customers/prospects for sales and marketing teams
• Develop churn prediction models to identify at-risk customers and support retention strategies
• Design and execute Media Mix Modeling (MMM) studies to measure channel-level marketing effectiveness and guide budget allocation
• Write efficient SQL queries to extract, transform, and validate data from large marketing and transactional datasets
• Build and productionize data pipelines and models in Python (pandas, scikit-learn, statsmodels, or equivalent)
• Work within Google Cloud Platform (GCP) — BigQuery, Cloud Run/Functions, IAM, and related services — to build scalable data workflows
• Translate model outputs into clear, business-relevant recommendations for marketing and media teams
• Collaborate with client servicing, media planning, and analytics teams to embed data science outputs into campaign and business decisions
• Stay current on marketing measurement approaches (attribution, incrementality, media effectiveness) and apply them to client problems

Required Skills & Experience

• Strong proficiency in Python for data analysis and machine learning
• Solid SQL skills, comfortable working with large, complex datasets
• Working knowledge of GCP, particularly BigQuery; familiarity with cloud-based data pipelines
• Practical experience building lead scoring and churn prediction models
• Experience with or strong conceptual understanding of Media Mix Modeling (e.g., adstock, saturation curves, Bayesian approaches such as Meridian, Robyn, or PyMC-Marketing is a plus)
• Good understanding of media and marketing concepts — campaigns, channels, funnels, attribution, and marketing KPIs
• Ability to communicate technical findings to non-technical stakeholders, including clients
• Willingness to build expertise in Google Ads Data Hub (ADH), or prior exposure to ADH study types (Frequency Analysis, Brand Lift, Path to Conversion, etc.)

Good To Have

• Experience with GA4, Google Ads, Meta Ads, or other marketing platform data
• Exposure to reverse ETL / audience activation workflows
• Experience with Looker Studio, Power BI, or similar BI tools
• Prior experience in a media agency, ad-tech, or martech environment

Qualifications

• Bachelor's/Master's degree in Statistics, Computer Science, Data Science, Economics, or a related quantitative field
• 2–5 years of relevant experience in data science/analytics roles (adjust per seniority)

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