Analyst, Data Architecture

Relocation Assistance Offered Within Country

Job Number #166340 - 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, lets 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. Great to have an understanding of necessary 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 Responsive 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
• Create ETL and ELT pipelines for various in house tools
• Build & support standard Business evaluation Trackers & Dashboards per agreed to SLAs and ideate essential report automations
• Snowflake database configuration and pipelining
• Creating End to End Data Pipelines leveraging GCS, Snowflake, Airflow and DBT
• Data Sanity is essential 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 / contribute to analytics projects (Technical Migrations) with proper tools, 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 sustainable and standard reporting trackers
• Partner with external data vendors to ensure timely data availability with appropriate data sanity i.e. Nielsen, Kantar. Manage 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 tackle 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 )/Google Apps
• Working knowledge of visualization tools like Tableau, DOMO, Datastudio
• 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.
• Working knowledge 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

Please complete this request form should you require accommodation.