Marketing Mix Models, Data Ingestion

WNS

Data Analyst in CPG domain responsible for data ingestion and transformation using Advanced Excel and Python. Collaborating with modeling teams to support MMM Models' development.

Posted 4/13/2026full-timeRemote • 🇮🇳 IndiaJuniorMid-LevelWebsite

Tech Stack

Tools & technologies

AzurePythonSQL

About the role

Key responsibilities & impact

Responsible for collecting, transforming and validating the data required for MMM Models.
Using Advanced Excel & Python to manipulate and transform the raw data into model ready datasets.
The processed data needs to be warehoused in Azure and presented using PowerBI.
Validate and derive insights from the transformed data to assist modeling team in building hypotheses for the MMM Models.
Provide training and support for internal employees.

Requirements

What you’ll need

2-8 years of experience in Data Analytics, Data Manipulation, Modeling in CPG or Consumer Pharma Domain.
Robust knowledge on Consumer Industry Brands & Category, knowledge on CPG data processing (with sales / marketing / commercial operations teams).
Able to source data from external syndicated data provider’s portals.
Knowledge of Marketing Mix Modeling, Pricing, RGM or any other Advanced analytics solution for CPG and Pharma domain.
Experience of working on Nielsen, IRI, IQVIA datasets.
Experience of working on Media data – offline or online for CPG or Pharma clients.
Manipulating data using Advanced excel, Python or R; Knowledge of any BI tools – PowerBI preferred; Knowledge of Azure platform is a plus.
Identifying new ways to leverage data (internal and external data sets - sales, digital, advertisement, media, sales force, social) to generate business insights.
Demonstrate technical functional expertise and be seen as an expert and partner by the client and internal stakeholders.
Fluent verbal communication and good written communication, communicate statistical outputs in a business language.
Run small to medium size projects, and manage the execution by planning project activities, tracking and monitoring the tasks, and working with close coordination with the project manager.
Provide training and support for internal employees.
Well-developed conceptual, analytical, strategic thinking and problem solving skills.
High sense of ownership.
Proven ability to handle multiple projects while meeting deadlines and documenting progress towards those deadlines.
Provide support to global markets and display flexibility.
Nice to have Machine Learning (ML), DevOps, Azure Data bricks experience/understanding.
Preferred knowledge/experience in R, SQL and PL/SQL, Power BI, Azure.

Benefits

Comp & perks

Employees can work remotely

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Data AnalyticsData ManipulationModelingMarketing Mix ModelingAdvanced ExcelPythonRSQLPL/SQLMachine Learning

Soft Skills

Fluent verbal communicationGood written communicationAnalytical skillsStrategic thinkingProblem solvingHigh sense of ownershipProject managementTraining and supportCollaborationFlexibility