Expert / Sr. Expert, Data Architecture

Relocation Assistance Offered Within Country Job Number #177130 - 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. Brief introduction - Role Summary/Purpose : The Data Architect for Supply Chain Analytics at Colgate-Palmolive is responsible for designing, developing, and maintaining robust data architectures to support advanced AI enabled analytics and reporting in supply chain operations. govern our modern data and AI infrastructure. The ideal candidate will bridge the gap between traditional data engineering and advanced artificial intelligence by architecting scalable data pipelines, AI/ML workflows, and cutting-edge Generative and Agentic AI solutions. The Data Architect will define strict guardrails across our core stack, enforce CI/CD best practices, leverage intelligent AI development tools, and drive project success using Agile methodologies to build and optimize data models and pipelines that drive supply chain insights, process efficiencies, and business value, while adhering to best practices in data governance and security. Responsibilities : Design and develop robust data pipeline architecture to support supply chain analytics initiatives. Create and maintain data models, integration pipelines, and data warehouses & Lakehouse architectures for supply chain data. Collaborate with cross-functional teams to gather requirements and translate them into scalable data solutions. Act as a CI/CD workflow reviewer and approver, ensuring code quality, security, and smooth deployments. Ensure data quality, consistency, and integrity across various systems and sources. Implement and enforce data governance, security standards, and best practices. Optimize data structures and processes for performance, scalability, and reliability. Integrate new data sources and technologies to enhance analytics capabilities. Troubleshoot and resolve data-related technical issues promptly. Document data architecture, standards, and data flows for reference and compliance. Review program codes and suggest correction in case of any errors Conduct performance tuning to improve system performance over multiple business processes Provide technical guidance and thought leadership in supply chain data management and analytics. Maintain production systems reliability through correct utilization of IT standards and governance processes Collaborate with business / functional team, develop detailed plans and accurate estimates for completion of build, system testing and implementation of project Required Qualifications and skills : Proven 5 to 7 years of experience as a data architect, data engineer, or in a similar data-focused role with exposure to Safe Agile environment, preferably within supply chain or manufacturing industries. Strong background in executing and managing projects using Agile methodologies, with high proficiency in tools such as GitHub Projects and Jira. Experience working with Visualisation tools (e.g., Sigma, DOMO). Strong proficiency in data modeling, database design (relational and non-relational), and ETL processes along with Data orchestration tools. In-depth knowledge and extensive hands-on experience working with Apache Airflow, dbt, Python, and Snowflake. Extensive integration experience with all types of data file formats, specifically modern formats including Apache Iceberg, Parquet, and JSON. AI, ML & Advanced Artificial Intelligence: Strong hands-on expertise in designing data architectures that support scalable AI/ML models and pipelines. Proven experience architecting and integrating Generative AI solutions (e.g., LLMs, RAG architectures, prompt engineering pipelines) into enterprise data systems. Experience designing frameworks for Agentic AI, enabling autonomous AI agents to interact with databases, execute workflows, and make data-driven decisions. Experience with modern data warehousing solutions e.g., Snowflake and Data Transformation platform - DBT. Demonstrated ability to architect scalable solutions and define strict development/operational guardrails within the Airflow, dbt, Python, and Snowflake ecosystems. Proven experience designing and creating robust data pipelines across Data Lakes, Cloud Databases, and AI-enabled applications. Hands-on experience designing, developing, and deploying data solutions using next-generation intelligent IDEs (specifically Devin, Antigravity, and Cursor). Proficiency in data integration tools and programming languages such as SQL, Python and Version Management tools - Github. Proven experience acting as a CI/CD workflow reviewer and approver, ensuring code quality, security, and smooth deployments. Hands-on experience in AI/ML routine integration and applications is desirable. Preferred Qualifications and skills : Master in Computer Science with Specialisation in Data Science is preferable. Solid understanding of data governance, data security, Metadata management and data quality best practices. Familiarity with supply chain processes, analytics, and key performance indicators (KPIs) is highly desirable. Excellent presentation, problem-solving skills, strong communication and collaboration skills to work effectively with IT and business stakeholders. #LI-RS1 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, 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