Specialist, Business Analytics

Colgate-Palmolive; Mumbai; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Colgate-Palmolive in Mumbai seeks a Specialist in the D&A team to build analytics solutions using Snowflake, dbt, Python and SQL. You will transform data, create consumption layers, and collaborate with stakeholders to deliver compliant, efficient analytics.

Requirements include 4–5 years in analytics engineering, a Bachelor's in CS/IT/Engineering, and strong visualization skills with Sigma/Tableau/Domo. This is a full-time on-site role in Mumbai.

Qualifications

• Bachelor's degree in CS/IT/Engineering or related field.
• 4–5 years of experience in analytics engineering or data engineering.
• Experience partnering with business teams to translate requirements into analytics solutions.
• Proficiency in Python and SQL; dbt and Snowflake experience preferred; visualization skills.

Responsibilities

• Develop analytics solutions for multi-functional teams using Snowflake, dbt, Python and SQL.
• Build visualizations with Sigma, Domo, Tableau or similar tools.
• Transform data and maintain consumption layers to support analytics needs.
• Ensure architecture compliance and adherence to enterprise standards.

Skills

Python

SQL

Data modeling

Stakeholder collaboration

Data transformation

Git

Education

Bachelor's degree in Computer Science / IT / Engineering

Tools

Snowflake

dbt

Sigma

Domo

Tableau

GitHub

Job description

Relocation Assistance Offered Within Country

Job Number #175422 - 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.

Brief introduction - Role Summary/Purpose

As a Specialist in the D&A team, you will focus on developing analytical solutions for multi-functional teams, ultimately empowering the organization to make more data-driven decisions. You will be responsible for transforming data, leveraging a technology stack that includes Snowflake, dbt, Python, and SQL, you will assemble large, sophisticated data sets that meet functional and non-functional business requirements. Working with various stakeholders, you will gather requirements and deliver compliant, efficient, sustainable, and well-documented analytics solutions leveraging this data.

Responsibilities

• Analytics Development
• Analytics and Visualization Build: Collaborate with various stakeholders to gather requirements and deliver compliant, efficient, sustainable, and well-documented analytics solutions. Build visualizations using tools such as Sigma, Domo, or similar.
• Data Transformation: Develop, support, and maintain consumption layers using Snowflake, dbt, Python, and SQL, to support various analytics needs.
• Architecture Compliance: Understand and stay compliant with the medallion architecture to ensure organized data progression and quality.
• Standard Stack: Leverage the standard data engineering technology stack to deliver data pipelines that are compliant with enterprise standards and best practices.
• Process Optimization and Innovation
• Continuous Improvement: Identify, design, and implement internal process improvements, including automating manual processes and optimizing analytics delivery.
• Emerging Tech: Research and evaluate new and emerging technologies within the analytics engineering space.
• Collaboration and Support
• Stakeholder Engagement: Work with various stakeholders across the company to understand business data strategy requirements and translate it to analytics execution
• Technical Assistance: Assist with data and analytics related technical issues and support business needs.
• Teamwork: Collaborate with other business and technical teams and develop meaningful relationships to achieve common goals.
• Governance and Standards
• Code Quality: Perform code reviews and help enforce data and analytics engineering standards and best practices.
• Compliance: Ensure solutions are compliant with enterprise standards, policies, and best practices.
• Documentation: Build, document, and maintain various components.

Required Qualifications

• Education: Bachelor’s Degree in Computer Science, Information Technology, Engineering, or a related field.
• Experience: At least 4-5 years of professional experience as an Analytics Engineer, Data Engineer or related role.
• Business Collaboration: At least 4-5 years of experience in collaborating with business teams, understanding requirements, and translating them into analytics solutions.
• Technical Proficiency:
• Programming: Experience developing in Python and SQL. Proficiency in dbt (optional)
• Data Warehouses: Experience working with Snowflake (optional)
• Visualization: Experience developing visualizations in Sigma, Tableau, Domo or similar.
• Databases: Experience in interacting with and using databases & SQL.
• Version Control: Experience using Git, GitHub, or other version-controlled code management tools.

Preferred Qualifications

• Monitoring: Experience in application-status monitoring, usage of FinOps tools while modeling and executing analytics workloads.
• Automation: Familiarity with software-automation production systems (GitHub Actions, Selenium, etc.).
• Deployment: Familiarity with code deployment tools.

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, 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.

Reasonable accommodation during the application process is available for persons with disabilities. Please complete this request form should you require accommodation.