MMM Data Ingestion

About the Role: As a key team member, you would be responsible for collecting, transforming, and validating the data required for Marketing Mix Modeling (MMM) Models. Using Advanced Excel & Python, you will manipulate and transform raw data into model-ready datasets. The processed data needs to be warehoused in Azure and presented using PowerBI. You will validate and derive insights from the transformed data to assist the modeling team in building hypotheses for various datasets, including Consumption/POS data, Media (online and offline), Medical Expert, & Finance data.

What You'll Do

• Collect, transform, and validate data required for MMM Models.
• Manipulate and transform raw data into model-ready datasets using Advanced Excel & Python.
• Warehouse processed data in Azure and present it using PowerBI.
• Validate and derive insights from transformed data to build hypotheses for the MMM Models.
• Share ideas and contribute to the innovation of the entire data ingestion process from source to modeling.
• Identify new ways to leverage internal and external datasets to generate business insights.
• Run small to medium size projects, track tasks, and coordinate closely with the project manager.
• Provide training and support for internal employees.

What You Bring

• 2-8 years of experience in Data Analytics, Data Manipulation, or Modeling in the CPG or Consumer Pharma Domain.
• B.Tech or Post Graduate degree (M.Sc. Statistics, Operational Research, Mathematics, or B.Sc. Stats + MBA).
• Robust knowledge of Consumer Industry Brands & Categories and CPG data processing.
• Knowledge of Marketing Mix Modeling, Pricing, RGM, or other Advanced analytics solutions.
• Experience working on Nielsen, IRI, IQVIA datasets and Media data (offline/online).
• Proficiency in manipulating data using Advanced Excel, Python, or R.
• Knowledge of BI tools (PowerBI preferred) and the Azure platform.
• Fluent verbal and written communication skills; ability to communicate statistical outputs in a business language.
• Bonus: Machine Learning (ML), DevOps, Azure Databricks experience, and knowledge of SQL/PL-SQL.

Benefits

• Remote work flexibility (Shift Time: 8:00 AM to 5:00 PM IST).
• Opportunity to provide support to global markets and display flexibility.
• High sense of ownership in a fast-paced and innovative environment.