FMCG Brand Analytics Specialist

Agensi Pekerjaan The Supreme HR Advisory Sdn Bhd; Kuala Lumpur; Remote; MYR 67,000 - 100,000; Full time

Job summary

The Supreme HR Advisory Sdn Bhd is seeking a capable Reporting & Analytics professional to own monthly and quarterly brand, inventory, and e-commerce reporting. You will build data models and dashboards, manage retailer data, and support admin tasks like product registration and pack visuals.

With 1–3 years in accounting or data analytics in FMCG, you will use advanced Excel, Power BI/Tableau, and generate insights to track marketing ROI, optimize spend, and forecast shipments.

Qualifications

• Diploma or Degree in Statistics, Accounting, Finance, or a related quantitative field.
• 1 to 3 years of experience in an accounting, financial analysis or data/commercial analyst role, ideally in FMCG or a distributor environment.
• Advanced Excel (pivot tables, lookups, data models) and able to produce PowerPoint to the brand template unsupervised.
• Comfortable with statistical and financial analysis, including variance analysis, trend/forecast modelling, and expense and rebate reconciliation.
• Retail scan data literacy (e.g. Nielsen/IRI-type panel or category data).
• Working knowledge of retailer portals and standard sales-data systems (e.g. sell-in/sellout tracking systems).
• Dashboarding experience (Power BI, Tableau or advanced Excel dashboards) is desirable.
• High accuracy against a fixed, recurring deadline calendar, and comfortable flagging exceptions and risks proactively.
• Organised and process-minded: able to build and follow SOPs, and to suggest where a recurring manual task can be templated or automated.
• Comfortable using generative AI tools (e.g. Claude, ChatGPT) to lift productivity in reporting, drafting and analysis; prior experience is a plus but not required, and training will be provided

Responsibilities

• Own monthly and quarterly brand, inventory, e-commerce, Business Review and write-off reporting end-to-end, on a fixed deadline calendar
• Prepare sales gap analysis, marketing spend tracking, promotional ROI calculations and the competitor price/promotion tracker
• Build and maintain templates, single-source data models and dashboards that reduce manual re-keying over time
• Manage retailer portal submissions, scan sales, withdrawal reports and other retailer data extraction (admin)
• Handle new product registration, listing files, content Excel, declarations, pack shots and sample arrangement (admin)
• Track product ageing, short-expiry exposure, maintain the rolling forecast base, and check shipment documents against purchase orders
• Compile incentive rebates, trade claims, product-damage claims and brand expense packs (admin)
• Maintain certifications, the product information library, trade letter drafts and agency factsheets (admin)
• Maintain the distribution matrix, audit in-store photo compliance, and track point-of-sale material stock and deployment
• Escalate to the Brand Manager against agreed thresholds (e.g. write-off exposure, forecast variance, distribution gaps) rather than simply reporting the numbers.

Skills

Advanced Excel

PowerPoint

Data analysis

Dashboarding

Education

Statistics/Accounting/Finance degree

Tools

Power BI

Tableau

Excel (Data Models)

Job description

The Supreme HR Advisory Sdn Bhd is seeking a capable Reporting & Analytics professional to own monthly and quarterly brand, inventory, and e-commerce reporting. You will build data models and dashboards, manage retailer data, and support admin tasks like product registration and pack visuals.

With 1–3 years in accounting or data analytics in FMCG, you will use advanced Excel, Power BI/Tableau, and generate insights to track marketing ROI, optimize spend, and forecast shipments.