Analyst , Business Analytics

Colgate’s interview process typically starts with a timed aptitude test, followed by a technical round that includes SQL/Python exercises and a business case study focused on FMCG analytics. The final HR round assesses cultural fit, communication skills and career motivations. Candidates should practice data storytelling and be ready to discuss past projects involving market data.

Colgate‑Palmolive fosters an inclusive, collaborative environment where employees are encouraged to innovate and take ownership. The company offers clear career ladders, regular skill‑upgradation programs and a healthy work‑life balance, making it a preferred employer in the FMCG sector.

Graduate in Engineering/Sciences/Statistics or MBA; Minimum 60% aggregate in graduation; 2‑3 years of experience in Data Insights/Analytics; No active backlogs; Strong command of English (written & verbal); Ability to work collaboratively across functions; Preference for candidates with exposure to FMCG sector and syndicated market data.

Round 1: Aptitude & Logical Reasoning → Round 2: Technical/Data Analytics case study (including SQL/Python test) → Round 3: HR interview (fit, culture, career aspirations)

Colgate-Palmolive Company is a global consumer‑products leader with a presence in more than 200 countries. The firm’s portfolio spans Oral Care, Personal Care, Home Care, Skin Care and Pet Nutrition, making it a household name in India and worldwide. With a heritage of over 200 years, Colgate is known for its commitment to sustainability, innovation and a strong focus on improving the health and wellbeing of people and pets. The company’s culture is built around three core values – Caring, Inclusive and Courageous – which drive collaboration, continuous learning and a purpose‑led mindset across all functions. The Business Analytics Analyst role sits at the intersection of marketing, sales and data science. The incumbent will partner with global business teams to translate massive internal and external data sets – such as syndicated market data (Nielsen, Kantar, IRI), point‑of‑sale information, finance and digital metrics – into actionable insights that shape brand strategy, product launches and competitive positioning. The role demands a strong analytical mindset, solid communication skills and the ability to deliver automated, high‑impact reporting solutions in a fast‑paced consumer‑goods environment. Key Responsibilities: 1. Build and maintain competition‑intelligence dashboards and automated insight solutions. 2. Design, develop and schedule data pipelines that integrate marketing, sales, finance and digital datasets. 3. Create standard business evaluation trackers and visual dashboards aligned with SLA commitments. 4. Validate data quality, perform sanity checks and resolve discrepancies with internal and external stakeholders. 5. Liaise with divisions, hubs and country teams to capture business requirements and translate them into analytical deliverables. 6. Collaborate with internal analytics and IT teams to institutionalise sustainable reporting frameworks. 7. Manage relationships with external data vendors ensuring timely, accurate data delivery. 8. Continuously explore new analytical techniques – data transformation, visualization, predictive modelling – to solve evolving business problems. 9. Present findings and recommendations to senior leadership with clear visual storytelling. 10. Support ad‑hoc analysis requests and first‑level diagnostic investigations. Tech Stack: R / Python for data manipulation, Snowflake for cloud data warehousing, Tableau, DOMO, Looker Studio or Sigma for visualization, and basic SQL for querying. Familiarity with automation tools (e.g., Alteryx, Power Automate) is a plus. Growth Path: Analysts typically progress to Senior Analyst, then to Analytics Manager, and eventually to Business Insights Lead or Category Head, gaining exposure to global brand strategy and cross‑functional leadership. Why Join Colgate‑Palmolive? The company offers a purpose‑driven environment where data directly influences products that improve daily lives. Employees benefit from structured learning programs, mentorship from seasoned marketers, and the chance to work on world‑class brands. With a strong emphasis on work‑life balance, inclusive culture and competitive compensation, Colgate is an ideal platform for ambitious analytics professionals to accelerate their careers.