Specialist, CBS SCF-Commercial Analytics

Location: Mumbai, India

Relocation Assistance Offered Within Country
Job Number #177133 - Mumbai, Maharashtra, India
Who We Are
Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specialising in Oral Care, Personal Care, Home Care, Skin Care, and Pet Nutrition. Our products are trusted in more households than any other brand in the world, making us a household name!
Join Colgate-Palmolive, a caring, innovative growth company reimagining a healthier future for people, their pets, and our planet. Guided by our core values—Caring, Inclusive, and Courageous—we foster a culture that inspires our people to achieve common goals. Together, let's build a brighter, healthier future for all.
Brief introduction - Role Summary/Purpose:
As part of Colgate-Palmolive’s Supply Chain Finance (SCF) Modernization strategy, we are scaling our highly successful Analytics Hub model globally. We are seeking a detail-oriented, proactive, and insight driven Financial Analyst to join the APAC Commercial Analytics Hub (CAH). The Specialist will support the CAH Lead in building and managing a centralized team based in Mumbai, India, driving the transition of select fragmented, plant-level activities into a highly efficient regional center of excellence.This role is responsible for supporting the CAH lead in strengthening decision support, eliminating operational redundancies, and scaling commercial analytics and insights across APAC. The ideal candidate possesses deep supply chain finance expertise, hands-on experience with modern data platforms (Snowflake, Sigma, SAP), and a proven track record of leading finance transformation or shared services (CBS) transitions in a matrixed multinational environment.
Responsibilities:

1. Advanced Costing Insights & Variance Analytics (30%)

Commercial & Volume Variance: Lead the execution of regional Purchased Finished Goods (FG) PPV, Additive Cost (Freight, Tax), and Volume (Commercial/Production) variance analyses.
Costing Consolidation: Consolidate divisional cost comparison reports, perform margin and cost movement reconciliations, for in-house and externally manufactured goods.
Identify Redundancies: Proactively target and eliminate localized redundancies, ensuring operational efficiencies between CBS and local plants.

1. Financial Planning, Forecasting & Business Partnering (20%)

Budget Consolidation: Own the SCF data supporting consolidation of Supply Chain Cost of Sales (COS) budgeting, Latest Estimates (LE) across the region.
Trending and Scenario Analysis: Work with the Global Supply Chain finance team to develop cost overlays based on material and freight changes. Align with the Division Supply Chain Finance Director on the FTG savings impact inclusion in material cost changes.
Division Review: Assist the Hub Lead in preparing Supply COS exhibits and executive presentation materials.

1. Operational Management (20%)

Quality Assurance: Review and validate analytical outputs, variance analyses, and financial reports before distribution to stakeholders.Process Documentation: Maintain and enhance standard operating procedures (SOPs) and process documentation to ensure knowledge continuity.

1. Technology Enablement & Modernization (30%)

Digital Transformation:

1. Partner with Global Information Technology (GIT) to champion and accelerate the adoption of digital tools, specifically Snowflake data products and Sigma self-service reporting
2. Build and maintain interactive data dashboards (using tools like Power BI or Tableau) to track key performance indicators

Automation:
Identify opportunities to automate manual processes and replace localized reporting with standardized, automated solutions.
Self-Service Reporting:

1. Replace localized, manual plant monthly reporting packages with a standardized, Global Sigma P&L utilizing automated data streams to free up local finance team capacity.
2. Build Insights and Competition Intelligence solutions and Work on Connected data solutions, building automated insights and reports.
3. Extract, clean, and analyze quantitative and qualitative data sets to identify business trends, operational bottlenecks, and growth opportunities.

Required Qualifications :
+ Graduate in Engineering/Sciences/Statistics , Masters in Data Science, Data Analytics
+ Minimum 5-8 years experience working in Data Insights / Analytics role with Finance
+ Minimum of 2 years in a regional shared service, Global Business Services (GBS), or hub-and-spoke finance delivery model,preferably during a start-up or scope expansion phase
+ Exceptional English communication skills, with a proven ability to present complex financial insights to senior executives, lead discussions and influence decisions across cross-functional teams and multiple cultures (such as APAC sub-regions)
+ Advanced proficiency in SQL, Excel (including PivotTables/VBA), Python or R, and Data Visualization software
+ Advanced usage and deployment of visualizations using tools like Tableau, DOMO, Lookerstudio, Sigma
+ Strong proficiency in SAP (FICO/CO-PC), S4 HANA, enterprise BI tools, and modern data infrastructures
Preferred Qualifications :
+ Ability to Read , Analyze, Visualize, Interpret and Translate data in order to answer business questions and deepen understanding
+ Minimum of 2 years in a regional shared service, Global Business Services (GBS), or hub-and-spoke finance delivery model,preferably during a start-up or scope expansion phase.
+ Hands-on experience with SQL,Snowflake, Sigma, or other BI tools is a significant advantage.
+ Strong foundation in statistical analysis, predictive modeling, and data interpretation
#LI-MP1
Our Commitment to Inclusion
Our journey begins with our people—developing strong talent with diverse backgrounds and perspectives to best serve our consumers around the world and fostering an inclusive environment where everyone feels a true sense of belonging. We are dedicated to ensuring that each individual can be their authentic self, is treated with respect, and is empowered by leadership to contribute meaningfully to our business.
Equal Opportunity Employer
Colgate is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, colour, religion, gender, gender identity, sexual orientation, national origin, ethnicity, age, disability, marital status, veteran status (United States positions), or any other characteristic protected by law.
Reasonable accommodation during the application process is available for persons with disabilities. Please complete this request form (https://docs.google.com/forms/d/e/1FAIpQLSdaxk_eF4utznQoVHlxmL9jVFJbOkM4Oe5CAdKOg-h9EPdLfg/viewform) should you require accommodation.
#LI-Hybrid