Commercial Operations BI Analyst

Colgate • Piscataway, NJ

3d • Onsite

About The Position

Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specializing 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. As our Business Development Analyst at Colgate Oral Pharmaceuticals (COP), you will bridge our Business Operations, Analytics, & Global IT teams. Reporting to our newly formed Commercial Operations team within Customer Development (CDO-Sales), you will serve as our cross-functional "Business Analytics Translator” . You will work with internal stakeholders to identify high-value & actionable business questions, analyzing relationships in data to create visualizations & reports that drive data-driven decision processes across Marketing, Sales, Finance, & Supply Chain. This position is based out of the Piscataway, NJ location. Work visa sponsorship is not available for this position.

Requirements

• Bachelor’s Degree or Equivalent (Business, Marketing, Business Analytics, or STEM preferred)
• 1–2 years of experience in Customer Development, Marketing, Commercial Finance or Business Ops
• Proven proficiency in technical software for data analysis (e.g. MS Excel, GSheets, Snowflake, Google BigQuery, etc.) & visualization tools (e.g. DOMO, Sigma).
• Strong familiarity with cloud computing platforms (e.g. Snowflake, GCP)
• Strong familiarity with SQL (Basic → Intermediate)
• Business Acumen & Intellectual Curiosity: Possess a holistic understanding of corporate/organizational objectives & business planning/processes (e.g. KPIs, data lineage). Demonstrate a detailed understanding of the methodologies & systems that allow the company to drive revenue, while analyzing the long vs short-term consequences of decisions with business function interdependencies in mind.
• Thrives in Ambiguity: Ability to remain effective & focused during periods of change; a self-starter comfortable navigating undefined territory & managing large, complex datasets.

Nice To Haves

• Proven expertise in SAP enterprise tools (S/4 HANA, BI/BWP, CRM) combined with Python or R proficiency for data modeling and reporting.
• Deep experience in Consumer Goods or Oral Pharma, specifically within commercial operations, sales analytics, or business-facing data roles.
• Hands-on experience with statistics and machine learning to uncover data relationships, backed by an ability to translate complex logic into business value.
• Skilled in developing data governance and process documentation with a track record of working cross-functionally within or alongside IT functions.
• Ability to bridge the gap between technical teams and business leadership, supported by BA or Lean Six Sigma certifications to prioritize and solve challenges.

Responsibilities

• Cross-Functional Operational Alignment: Support the integration of key operational frameworks across the organization to ensure business strategies are supported by efficient, scalable processes. Partner with key stakeholders to align COP’s data strategy with our cross-department business requirements to deliver sustainable value.
• Descriptive Analysis & Data Storytelling: Leverage your proficiency in SQL/cloud-based tools (e.g. Snowflake/BigQuery, DOMO/Sigma/Tableau) to analyze relationships in data. Specializing in Data Storytelling and Influence, you will analyze data relationships to create impactful visualizations & presentations that answer key business questions.
• Analytics Solution Design (UI/UX familiarity): Act as the primary bridge between business stakeholders and technical teams by translating multi-departmental requirements into intuitive dashboard layouts. Prioritize end-user usability and stakeholder consumption patterns to build effective visualization layouts.
• Technical Collaboration & Integrity: Support our on-site Analytics/Data Engineers to design & build data pipelines & core analytics solutions. Own the validation of outputs against source data to ensure a "single source of truth" across all relevant business functions.
• Governance & Business Planning: Help monitor the COP business budget & Latest Estimates (LEs) while maintaining centralized SOPs & documentation (logic, metrics, design standards). Assist with cross-departmental reviews to ensure operational consistency & support the implementation of annual business plans.

Benefits

• Salaried employees enjoy a comprehensive benefits package, including medical, dental, vision, basic life insurance, paid parental leave, disability coverage, and participation in the 401(k) retirement plan with company matching contributions subject to eligibility requirements.
• Additional benefits include a minimum of 15 vacation/PTO days (hourly employees receive a minimum of 120 hours) and 13 paid holidays (vacation days are prorated based on the employee's hire date within the calendar year).
• Paid sick leave is adjusted based on role and location in accordance with local laws. Detailed information regarding paid sick leave entitlements will be provided to employees upon hiring and may be subject to adjustments based on changes in legislation or company policies.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level