Sr. Technical Specialist

Relocation Assistance Offered Within Country Job Number #173957 - 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. Title: Sr. Technology Associate / Specialist, Analytics Engineering   Brief introduction - Role Summary/Purpose: This position requires a high-impact Data Engineer capable of connecting sophisticated technical processes with strategic leadership narratives. The candidate will manage the complete data lifecycle, facilitating ingestion within Snowflake and developing influential dashboards to guide organizational decision-making. The role demands expertise in constructing resilient ELT pipelines through dbt and Airflow, combined with the professional insight to design persuasive visual analytics. Acting as a strategic advisor, the individual will convert Customer Development inquiries into actionable technical solutions. Responsibilities: 1. Holistic Data Architecture Management Architectural Oversight: Construct and oversee resilient, enterprise-grade pipelines sourcing from diverse environments into Snowflake tiered data structures. Logic Implementation: Leverage dbt for sophisticated transformation processes, maintaining rigorous standards for data lineage and modular integrity. Workflow Management: Orchestrate sophisticated schedules via Airflow while utilizing GitHub to enforce professional CI/CD versioning protocols. 2. Analytics Visualization & Narrative Design Visual Mastery: Engineer high-impact dashboards within Sigma, prioritizing professional aesthetics and seamless user navigation. Strategic Storytelling: Transform raw metrics into persuasive narratives, elucidating commercial trends and anomalies for executive-level comprehension. Executive Reporting: Direct the automated distribution of high-priority analytics, guaranteeing absolute precision and adherence to reporting timelines. 3. Strategic Business Collaboration & Domain Insight Collaborative Discovery: Facilitate strategic sessions with business leads to synthesize technical requirements. Inter-Departmental Translation: Function as a technical advisor, bridging the gap between engineering capabilities and strategic organizational goals. 4. Leadership & Technical Mentorship Standards Governance: Establish team-wide benchmarks for optimized SQL development and sophisticated data visualization methodologies. Quality…