WNS

Marketing Mix Models, Data Ingestion

WNS

full-time

Posted on:

Location Type: Remote

Location: India

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AzurePythonSQL

About the role

  • 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

  • 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
  • Employees can work remotely
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