Job Closed
This listing is no longer active.
Market Mix Modelling, Pricing, RGM, Data Analytics, Data Manipulation SQL
Location
India
Posted
49 days ago
Salary
0
Seniority
Mid Level
Job Description
Market Mix Modelling, Pricing, RGM, Data Analytics, Data Manipulation SQL
WNS
• As a key team member, You would be responsible for collecting, transforming and validating the data required for MMM Models. • Using Advanced Excel & Python, you would be required to manipulate and transform the raw data into model ready datsets. • The processed data needs to be warehoused in Azure and presented using PowerBI. • You would have to validate and derive insights from the transformed data to assist modeling team in building hypotheses for the MMM Models. • This will be for various datasets – Consumption or POS data, Media – both online and offline, Medical Expert & Finance data • You will be seen as a strong voice of influence for sharing ideas and contributing to innovation of the entire data ingestion process from source to modeling
Job 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
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
Analista de datos
SendaPara. Piensa. Hazlo distinto. Consultoría para el desarrollo organizacional y acompañamiento a familias empresarias.
• Ordenar y mantener la base de datos global (Bitrix24/CRM). • Unificar criterios y formularios de ingreso de datos por región. • Colaborar con desarrollo para automatizar procesos. • Crear dashboards y reportes (Looker Studio / Power BI). • Asistir a comerciales con segmentación y análisis de campañas. • Filtrar datos por país respetando regulaciones locales.
Data Analyst Intern, UG & PG
ATPCOATPCO is committed to providing the best flight shopping experiences through reliable pricing data and innovative retail technology. Positioning itself as "the foundation of modern
• Assist in extracting, cleaning, and analyzing data from multiple sources to identify trends and patterns • Support the development of dashboards and reports using tools like Tableau or Power BI • Collaborate with data scientists and engineers to ensure data accuracy and consistency • Perform ad-hoc analyses and help translate findings into actionable insights • Contribute to improving data workflows and processes for better efficiency
• We work with business, product management, and design teams to develop ergonomic, reliable tools. • You will be responsible for collecting, processing, analyzing, and visualizing data to deliver strategic insights. • You will play a key role in decision-making by working closely with business teams, developers, and data engineers. • Develop interactive, dynamic dashboards in Looker and Looker Studio. • Identify and track critical KPIs to guide business operations. • Design optimized data pipelines in BigQuery. • Ensure data quality and reliability to guarantee consistency across analyses. • Write and optimize complex SQL queries in BigQuery. • Automate analytical processes to improve efficiency and performance. • Work closely with the client’s business teams across multiple countries to understand their analytical needs. • Train and support users in the use of dashboards and analytical tools.
• Lead assessment of current-state stakeholder workflows, operating models, and pain points • Provide senior-level advisory support on solution design, product usage strategy, and workflow optimization • Advise stakeholders on future-state processes, operational change impacts, and adoption priorities
