Data Scientist

No Relocation Assistance Offered
151545 - Mumbai, Maharashtra, India

Li-Remote

**About Colgate-Palmolive**

Do you want to come to work with a smile and leave with one as well? In between those smiles, your day consists of working in a global organization, continually learning and collaborating, having stimulating discussions, and making impactful contributions

If this is how you see your career, Colgate is the place to be

Our dependable household brands, dedicated employees, and sustainability commitments make us a company passionate about building a future to smile about for our employees, consumers, and surrounding communities. The pride in our brand fuels a workplace that encourages creative thinking, champions experimentation, and promotes authenticity which has contributed to our enduring success.

If you want to work for a company that lives by their values, then give your career a reason to smile...every single day.

**Job Purpose**:

- The role will lead and support in store drivers optimization projects for a subsidiary/Hub in Europe.
- The person will work with the Division RGM manager to build on promo optimization capabilities and approaches for the intended Sub/Hub in the European Division. Also will help to leverage methodologies and tools for promo optimization analysis and recommendations.
- The person will support the “Grow the Head” initiative for Europe, collaborating with stakeholders and conduct most appropriate Strategic Pricing, Price Pack Architecture (PPA) and assortment analysis and modeling. The person will provide to the RGM Manager and the business stakeholders short term and long term opportunities in in Pricing / Price Pack Architecture (PPA) and assortment as a result of detailed analysis of existing retail audit data, internal financial data, consumer needs segmentation data and other relevant market, brand, competitive and macro-economic data together with advanced analytics modeling conducted by external intelligence and data providers and in-house for the given subsidiary/hub.

**Accountabilities/ Responsibilities**:
**Pricing, PPA, Promotion and Assortment Capability: tools and models**
- Stay fully updated on state of the art Pricing & PPA and assortment tools and models
- Understand and share new practices and success cases to build awareness, knowledge & usage of PPA and assortment optimization techniques in the regional team
- Attend regular training on PPA and assortment optimization tools
- Embrace new Promo Optimization tools and methodologies in the region based on RGM principles

**Pricing and Price Pack Architecture, Assortment Analysis: Key activities**
- Clearly identify questions: Participate in Category team meetings whenever possible and proactively engage with category teams to identify any pricing needs and questions. Prioritize and align on the questions, align with the category teams on the scope for further analysis.
- Data collection & review: Compile consumer research reports, pricing studies, elasticity studies, market structure reports, category situational analysis reports, financial reports, Nielsen share reports. Review, summarize, prepare initial learning and identify information gaps.
- Nielsen / external data agency analysis: Conduct situation review analysis to identify opportunities & develop hypothesis using PPA tools (Mekko charts, Pricing structure, Magic price points, Threshold analysis, Price Gap/index vs competitors, SKU Margin Analysis, Quadrant / Bubble charts and Price pack incentive curves etc) and assortment optimization tools.
- High level of proficiency in Nielsen Answers and Excel / Google sheet, Google Data Studio and R/Python coding required.
- Discrete Choice modeling: Consumer testing of new pack sizes/formats in a choice based conjoint study and quantify the market size opportunities for new pack sizes
- Participate and lead initiatives for Price and Promo studies to gather price elasticities
- Very familiar with promo mechanics and funding rules, able to recommend the right promo strategy to improve the efficiency of the promotions and simulate the impact on the PnL
- Help run promo optimization analysis and projects in house and/or with agencies
- Embrace new methodologies and capabilities to step up in promo optimization in Europe
- Partner closely with the EU Divisional and Global RGM group

**Communication**:

- Communicate all learning and insights in a compelling way to drive action: Ensure presentations and reports are clear, timely and inspiring as well as actionable. Influence Category Teams. Build management confidence in recommended actions with appropriate interpretation and integration of key concepts.
- Workshop & Activation: Setup detailed agenda, invite key stakeholders, arrange other logistics related to a debrief workshop to share and align on the learnings, recommendations for short term and long term

**Required Experience / Education**:

- University Degree, Economics / Finance / Technic