Expert, Analytics Engineering (Mumbai, MH, IN)

<style type="text/css"> </style> <p><span style="font-family:Arial, Helvetica, sans-serif">Relocation Assistance Offered Within Country<br>Job Number #173512 - Mumbai, Maharashtra, India<br><br><strong>Who We Are</strong><br><br>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!<br><br>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.</span><br><br></p><p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><strong><span style="font-size:10.0pt">Brief introduction - Role Summary/Purpose:</span></strong></span></p> <ul style="margin-top:0.0px;margin-bottom:0.0px"> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:12.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Designing, building, and maintaining robust and scalable data pipelines to architect and manage data flow; developing and optimizing cloud data warehousing solutions; and translating complex data into clear, actionable visual representations and business insights for stakeholders. </span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:12.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Leading the design and implementation of scalable ELT processes; maintaining data integrity within Snowflake; creating high-fidelity visualizations; and serving as a strategic partner to Business teams  to ensure data infrastructure supports business objectives and data-driven decision-making.</span></span></p> </li> </ul> <p> </p> <p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><strong><span style="font-size:10.0pt">Responsibilities:</span></strong></span></p> <h4 style="margin-top:12.0pt;margin-bottom:2.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><strong><span style="font-size:10.0pt">End-to-End Data Engineering</span></strong></span></h4> <ul style="margin-top:0.0px;margin-bottom:0.0px"> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:12.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Architecting, constructing, and overseeing scalable data pipelines to manage data flow from diverse sources into Snowflake layers.</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Utilizing dbt for the implementation of sophisticated business logic, ensuring high standards for data quality, lineage, and modularity.</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:12.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Orchestrating complex workflows through Airflow and managing version control via GitHub while adhering to CI/CD best practices.</span></span></p> </li> </ul> <h4 style="margin-top:12.0pt;margin-bottom:2.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><strong><span style="font-size:10.0pt">AI Foundation and Modernization</span></strong></span></h4> <ul style="margin-top:0.0px;margin-bottom:0.0px"> <li style="font-size:9.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:12.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Architectural Leadership: Design and implement a Semantic Layer to bridge the gap between complex data schemas and Natural Language interfaces for executive reporting.</span></span></p> </li> <li style="font-size:9.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">AI Integration: Build and optimize NL2SQL pipelines that allow non-technical stakeholders to perform self-service analytics via LLM-powered interfaces.</span></span></p> </li> <li style="font-size:9.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Data Reliability: Implement AI-driven observability frameworks to ensure high-fidelity data feeds for automated reporting, minimizing model hallucination and "silent failures."</span></span></p> </li> <li style="font-size:9.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Strategic Automation: Evolve the reporting function from reactive dashboards to proactive decision intelligence, utilizing AI agents to surface automated insights and narrative summaries.</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="line-height:1.2;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Prompt Engineering</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="line-height:1.2;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">DBT Semantic Layer (MetricFlow) - Natural Language Query</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="line-height:1.2;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">LangChain / LlamaIndex - Agentic AI</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="line-height:1.2;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">GCP - Deployment</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="line-height:1.2;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Snowflake Cortex / Pinecone - Managing Unstructured data / Vector data</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="line-height:1.2;margin-top:0.0pt;margin-bottom:12.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">AI Governance / Security / Observability</span></span></p> </li> </ul> <h4 style="margin-top:12.0pt;margin-bottom:2.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><strong><span style="font-size:10.0pt">Visualization &amp; Storytelling</span></strong></span></h4> <ul style="margin-top:0.0px;margin-bottom:0.0px"> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:12.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Creating high-fidelity, intuitive, and visually engaging dashboards using platforms such as Sigma &amp; Domo</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Translating complex data into clear, actionable visual representations and business insights to highlight trends and opportunities for stakeholders.</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:12.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Overseeing the automated delivery of critical reports to executive leadership with a commitment to absolute accuracy and timeliness.</span></span></p> </li> </ul> <h4 style="margin-top:12.0pt;margin-bottom:2.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><strong><span style="font-size:10.0pt">Business Partnership &amp; Domain Expertise</span></strong></span></h4> <ul style="margin-top:0.0px;margin-bottom:0.0px"> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:12.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Serving as a strategic partner to leaders in CD teams to uncover core business needs through discovery sessions.</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:12.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Acting as a bridge between technical engineering constraints and business ambitions to ensure data-driven decision-making.</span></span></p> </li> </ul> <h4 style="margin-top:12.0pt;margin-bottom:2.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><strong><span style="font-size:10.0pt">Technical Leadership &amp; Mentorship</span></strong></span></h4> <ul style="margin-top:0.0px;margin-bottom:0.0px"> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:12.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Establishing internal standards for optimized SQL, clean code, and effective dashboard design principles across the organization.</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:12.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Performing rigorous peer reviews of code and visualizations to ensure performance optimization and consistency with brand standards.</span></span></p> </li> </ul> <p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><strong><span style="font-size:10.0pt">Required  Qualifications:</span></strong></span></p> <ul style="margin-top:0.0px;margin-bottom:0.0px"> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:12.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Possessing a Bachelor’s degree in Computer Science, Data Analytics, Mathematics, or a closely related quantitative field.</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Demonstrating 8+ years of extensive, hands-on experience in Data Engineering and Business Intelligence architectures.</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Expert-level mastery of the technical stack, specifically Snowflake, SQL, and dbt, to drive data modeling and logic.</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Proficiency in utilizing Python and Airflow for the orchestration of complex data workflows.</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Proven business acumen with Customer Development and Retail data sets</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:12.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Exceptional verbal and written communication skills, with a proven ability to translate and present complex data insights to executive leadership.</span></span></p> </li> </ul> <p> </p> <p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><strong><span style="font-size:10.0pt">Preferred Qualifications:</span></strong></span></p> <ul style="margin-top:0.0px;margin-bottom:0.0px"> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:12.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Applying UI/UX principles to the creation of sophisticated and intuitive dashboard designs.</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Demonstrating experience with AWS or GCP cloud ecosystem integrations to support data architectures.</span></span></p> </li> <li style="font-size:11.0pt;font-family:arial, helvetica, sans-serif;color:black"> <p style="margin-top:0.0pt;margin-bottom:12.0pt"><span style="font-family:arial, helvetica, sans-serif;color:black"><span style="font-size:9.0pt">Possessing a professional background within the Consumer Packaged Goods (CPG) or Retail sectors.</span></span></p> </li> </ul><p><br><span style="font-family:Arial, Helvetica, sans-serif"><strong>Our Commitment to Inclusion</strong><br>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.<br><br><strong>Equal Opportunity Employer</strong><br>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.<br><br>Reasonable accommodation during the application process is available for persons with disabilities. Please complete this <a href="https://docs.google.com/forms/d/e/1FAIpQLSdaxk_eF4utznQoVHlxmL9jVFJbOkM4Oe5CAdKOg-h9EPdLfg/viewform" target="_blank" rel="noopener"><span style="color:#0000ff">request form</span></a> should you require accommodation.<br><br><span style="color:#000000">#LI-Hybrid</span></span></p>