Sales Business Analyst

  • Colgate-Palmolive Fiji (Pte) Ltd
  • Hybrid (Lami, Suva)
  • Apr 14, 2024
Full time Customer Service & Fast Food Health Care & Medical Manufacturing Pharmaceutical Retail & Consumer Products

Job Description & Skills/Qualifications Required

Do you want to come to work with a smile and leave with one as well? In between those smiles, your day consists of working in a global organization, continually learning and collaborating, having stimulating discussions, and making impactful contributions!

If this is how you see your career, Colgate is the place to be! Our dependable household brands, dedicated employees, and sustainability commitments make us a company passionate about building a future to smile about for our employees, consumers, and surrounding communities. The pride in our brand fuels a workplace that encourages creative thinking, champions experimentation, and promotes authenticity which has contributed to our enduring success. If you want to work for a company that lives by their values, then give your career a reason to smile...every single day.


Purpose - The Business Analyst supporting the Sales function is responsible for collecting and analyzing data to evaluate business performance, existing and potential products and business opportunities. Assisting with product forecasts to accommodate promotional activities, consumption trends, advertising campaigns and assessing and facilitating marketing changes to prices.  This role is a key liaison between both internal and external stakeholders.


1.    Data Analytics

  • Daily Sales Update 

  • Customer Scan Data Analyses – (maintenance, update, sending to CBS)

  • Return on Investment Analyses

  • Setting Sales Targets & monitoring territory performance (Daily, Monthly, Qtrly)

  • Invoice Sales File Update and maintenance

  • Qlikview file uploads – monthly basis

  • Prepare monthly business reviews for customer

2.   CDT Finance

  • Collating and updating manual discount from CJP and submitting to CP Finance

  • Filing SAP Invoices

  • Processing credit notes and liaising with CJP Finance

  • Preparation of customer accruals (Rebates, scanback, paper adverts, etc.)

  • Managing trade spend for Fiji Islands

  • Discount entry in  Bixxze (CJP system) – monthly and on ad-hoc basis

  • Customer payments – reconciliation, liaising with stakeholders and uploads in FMP (SAP)

  • Preparing & managing revised deals – seek approval and sending to hub for upload

  • Qtrly sales incentive payout preparation and sign offs

  • List Price changes and communication to stakeholders

  • Monthly EDLP (deals) preparation

3.    Forecast Management

  • Assist in demand planning activities

  • Provide consumption trends, pricing changes and any promotional activitie

4.     Internal & External Reporting

  • Daily Sales Reporting to CDT 

  • Monthly & Qtrly performance vs Target

  • Customer Reviews

  • Update customer reviews (excel & powerpoint) highlighting customer performance versus target, subcategory and store performance

  • Smart App Reporting

  • 5P Audit – monthly basis

  • Photo Reporting

  • Sales Meeting/ Conference/ Mancom

  • Prepare and update presentations and also participate in sales meeting 

Required Qualifications:

  1. Have a tertiary qualification 
  2. Minimum 3 years of work experience
  3. Good in verbal and written communication with internal and external stakeholders
  4. Expertise in Microsoft Excel or Google suite applications
  5. Excellent interpersonal skills with ability to work in a team and ability to adapt to a rapidly changing environment
  6. Continuous improvement mindset
  7. Business partnership thinking
  8. Ability to work under tight deadlines
  9. Organized personality with attention to detail

How to apply 

Click on Apply Now to submit the following:

  1.  An Application letter
  2.  Current CV with contact details of at least 2 referees
  3.  Certificates/evidence of qualifications (if any )

Please read blog on tips on how to upload documents

Applications close 19 April 2024 - role is vacant now so don't wait.

Job Functions

Analysts, Assistant Accountants /Finance, Business Development, Finance Officer, Sales (Other)


Retail & Consumer Products