Job Title:  Analyst, Data Architecture

Relocation Assistance Offered Within Country
Job Number #164634 - Mumbai, Maharashtra, India

Who We Are

Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specializing 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.
 

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 diligent 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  

The Experience:

In today’s multifaceted technology environment, it is an exciting time to be a part of the CBS Data Architecture team at Colgate!.

Our highly technical and innovative team is dedicated to driving growth for Colgate Palmolive in this constantly evolving landscape.

What role will you play as a member of the Colgate’s Data Architecture Team?

The candidate will support Colgate Business teams across the globe by providing Data & Analysis support. The role requires a person to have understanding of Internal & external data (Syndicated Market Data, Point of Sales etc.) and ability to develop and support the Analytical / Insights based Service & solutions. Phenomenal to have an understanding of vital Data Transformation & Data Visualization Tools and Technologies to drive the service and solutions. 

The Person should be Analytical problem solver with the ability to work on large data sets, collaborative and customer focused (proactive and Adaptable to Business needs) and Effective in Written and verbal communication skills.

Who are you…

You are a function expert -

• Supports data harmonization process set up and business as usual across all CP countries and categories to ensure standardization across varied data sets

• Build ETL and ELT pipelines for various in house tools

• Build & support standard Business evaluation Trackers & Dashboards per agreed to SLAs and ideate crucial report automations

• Snowflake database configuration and pipelining

• Crafting End to End Data Pipelines demonstrating GCS, Snowflake, Airflow and DBT

• Data Sanity is important so validating the trackers and dashboards to ensure that consistency is maintained over different reporting cycles

• Work on different datasets & systems (Marketing, Customers, Product masters, Finance, Digital, Point of Sales) and link the business rationales to develop & support Analytical solutions

• Support / supply to analytics projects (Technical Migrations) with propaccuratels, consultancy and analysis.

You are a collaborator -

• You will engage with Business teams in Corporate, Divisions, Hub (Cluster of Countries) and countries to understand business requirements and collaborate on solutions

• Work with Internal Analytics teams & Information technology teams to learn and advance on developing balanced and standard reporting trackers

• Partner with external data vendors  to ensure timely data availability with appropriate data sanity i.e. Nielsen, Kantar. Be responsible for the contracts and set performance KPIs and conduct quarterly/annual reviews of data providers

You are an innovator -

• With a constantly evolving business environment, you will find out different ways to solve the business problem through Analytical solutions (Data transformation, Data Visualization, Data Insights)

What you’ll need…(Required)

• Bachelor of Engineering/Sciences, MBA 

• 1-2 Years of experience in an ETL / Automation Role

• Knowledge of Data Transformation tools - R/Python/ SQL/Cloud solutions (GCP/Snowflake)) /GoogleApps

• Demonstrable understanding of visualization tools like Tableau, DOMO, Data studio

• Ability to Read , Analyze and Visualize data 

• Effective Verbal & Written Communication for Business engagement

What you’ll need…(Preferred)​​​​​​

• Experience with third-party data i.e. syndicated market data (Nielsen, Kantar, IRI) , Point of Sales, etc.

• Solid grasp of consumer packaged goods industry

• Understanding of Colgate’s processes, and tools supporting analytics (for internal candidates)

• Willingness and ability to experiment with new tools and techniques 

• Good facilitation and project management skills

Our Commitment to Diversity, Equity & Inclusion
Achieving our purpose starts with our people — ensuring our workforce represents the people and communities we serve —and creating an environment where our people feel they belong; where we can be our authentic selves, feel treated with respect and have the support of leadership to impact the business in a meaningful way.

Equal Opportunity Employer
Colgate is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, 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 should you require accommodation.

#LI-Hybrid