Business Analytics Specialist

Colgate - Palmolive India Ltd; Mumbai; On-site; INR 1,620,000 - 1,980,000; Full time

Job summary

Colgate-Palmolive India Ltd in Mumbai is seeking a Specialist, Business Analytics to build data-driven solutions using Snowflake, dbt, Python and SQL, collaborating with multi-functional teams.

You will transform data, assemble large datasets, deliver compliant analytics, and maintain documentation, ensuring architecture compliance and enterprise standards.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• 4-5 years of experience as Analytics Engineer/Data Engineer or related role.
• Experience collaborating with business teams to translate requirements into analytics solutions.
• Proficiency in Python and SQL.
• Familiarity with dbt and Snowflake is a plus.

Responsibilities

• Analytics development: gather requirements and deliver documented analytics solutions.
• Data transformation: build and maintain data consumption layers using Snowflake, dbt, Python, and SQL.
• Ensure architecture compliance and standard data-engineering practices.
• Collaborate with stakeholders and provide technical assistance.

Skills

Python

SQL

Data analytics

Education

Bachelor's degree in Computer Science/IT/Engineering

Tools

dbt

Snowflake

Sigma

Tableau

Domo

Git

GitHub

Job description

Specialist, Business Analytics Relocation Assistance Offered Within Country

Job Number #175422

Location: 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 valuesCaring, Inclusive, and Courageouswe 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: Bachelors 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 peopledeveloping 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 .