Business Analytics Specialist Andina

INGEPSY; Sur; Híbrido; COP 100.440.000 - 167.400.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Relocation Assistance Within Country

Descripción de la vacante

Colgate-Palmolive, una empresa global de consumo, busca un analista de datos para ejecutar iniciativas analíticas avanzadas (RGM, MMM) y gestionar datos e informes de BI. Colaborarás en desarrollar visualizaciones y dashboards para decisiones basadas en datos y apoyarás estrategias de precios y marketing.

Se valoran experiencia en SQL, Excel y dominio de inglés, con enfoque analítico y habilidades organizativas. Ofrecemos traslado dentro del país y un entorno de trabajo colaborativo.

Formación

• Licenciatura
• Al menos 2 años de experiencia en insights, marketing o BI
• Dominio avanzado de Excel
• SQL intermedio–avanzado
• Inglés alto intermedio o avanzado
• Competencias analíticas con atención al detalle
• Organizado, eficiente y confiable
• Colaborativo y orientado al trabajo en equipo
• Conocimiento de Python y data science es un plus
• Mentalidad inquisitiva y creativa

Responsabilidades

• Apoyar la implementación del plan regional de Analytica impulsando transformación de datos, automatización y visualización usando herramientas globales como Snowflake y DOMO
• Desarrollar visualizaciones y analíticas a medida para apoyar la toma de decisiones
• Contribuir a la implementación de precios y tableros KPI para apoyar la estrategia de precios y realizar análisis de promociones
• Apoyar la optimización de inversiones de marketing participando en modelado MMM para categorías clave
• Contribuir a la preparación de presentaciones de revisión de negocio entendiendo tendencias de comportamiento del consumidor
• Gestionar calidad de datos, segmentaciones y mejoras en datos sindicados

Conocimientos

Advanced Excel

SQL

Inglés (alto intermedio/avanzado)

Análisis

Organizado

Trabajo en equipo

Educación

Licenciatura

Herramientas

Snowflake

DOMO

Descripción del empleo

Descripción del trabajo

Relocation Assistance Offered Within Country

Job Number #175549 - Cali, Valle del Cauca, Colombia

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.

Job Summary

• Engage in executing advanced analytics initiatives, including RGM, Marketing Mix Modeling (MMM), alongside data management and Business Intelligence reporting.
• Analyze syndicated data and deploy new tools to enhance corporate profitability and performance.
• Partner in developing appropriate visualizations, reports, and dashboards to support data-driven business decisions.
• Serve as an analytics translator for commercial teams, bridging the gap between market dynamics and commercial strategy.

Responsibilities

• Support the implementation of the regional Analytics Plan by driving end-to-end data transformation, automation, and visualization processes using global IT tools like Snowflake and DOMO.
• Develop tailored data visualizations and analytics aligned with Colgate's requirements to enhance strategic decision-making and support growth scenarios.
• Contribute to the implementation of pricing and KPI decks to support the pricing strategy for Colgate Brands, and execute additional pricing analyses. This includes leveraging new functionalities such as calculating return on investment (ROI) and evaluating the performance of promotional packs, temporary price reductions, and other pricing activities.
• Support the optimization of marketing investments by participating in advanced analytics marketing mix modeling for core categories, including managing data extractions and data validation processes.
• Support the preparation of main business review presentations, by helping to understand trends in consumer behavior and their connection with category performance.
• Responsible for syndicated data quality control, managing the implementation of new segmentations and enhancements.

Requirements

• Bachelor's degree
• At least 2 years of professional experience in insights, marketing, or business intelligence roles
• Advanced proficiency in Microsoft Excel
• Intermediate to advanced SQL capabilities
• High intermediate or advanced level of English
• Robust analytical skills paired with a meticulous focus on detail and precision
• Highly organized, efficient, and dependable
• Strong competence in planning and setting priorities
• Collaborative, teamwork-oriented approach
• Familiarity with Python and data science is considered a plus
• Inquisitive and creative mindset

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.

#LI-Hybrid