Financial Reporting Analyst

ALL MARKET SINGAPORE PTE. LTD.; Singapore; On-site; SGD 50,000 - 70,000; Full time

Job summary

A leading consumer goods company in Singapore is looking for a Financial Reporting Analyst to join their Finance team. This role is essential for ensuring the integrity of financial data for the Global Supply Chain and APAC region. The ideal candidate should have a Bachelor’s degree in Accountancy or Finance, solid analytical skills, and proficiency in tools such as SAP and Power BI. Responsibilities include month-end reporting, variance analysis, and data management to deliver actionable insights.

Qualifications

• Strong attention to detail and accuracy.
• Willingness to learn and a can-do attitude.
• Ability to work independently in a fast-paced environment.

Responsibilities

• Execute the monthly volume reconciliation process.
• Prepare and update management decks and Power BI dashboards.
• Assist in preparing in-depth variance analysis.

Skills

Attention to detail

Analytical skills

Problem-solving skills

Strong Excel skills

Communication skills

Interpersonal skills

Education

Bachelor's degree in Accountancy or Finance

Tools

SAP

Power BI

TM1

Job description

Main Tasks and Responsibilities

As a Vita Coco Financial Reporting Analyst, you will be a critical member of the Finance team, responsible for ensuring the financial integrity and timely delivery of results for the Global Supply Chain and APAC region. You will own the foundational data, manage financial reconciliations, and assist in the production of monthly management presentation decks. This role focuses on maintaining data integrity and transforming raw financial data into actionable business insights that drive efficiency and informed decision‑making.

1. Month‑end Finance Reporting / Budgeting / Forecast

• Volume Reconciliation: Execute the monthly volume reconciliation process, ensuring alignment between SAP and the Full Year Forecast during month‑end close.
• Data Report: Manage data reliability by extracting, validating, and distributing essential reports from SAP and other sources for reports and analysis usage.
• COGS Reconciliation: Accurately reconcile COGS data (Standard Price, Pure PPV, and Premiums) based on YTD, Balance of Year (BOY), and Full Year (FY).
• Variance Analysis: Assist in preparing in‑depth variance analysis (Volume‑Price‑Mix impact, COGS Waterfall, $/L, $ per Case) across key metrics for Senior Analyst review.
• Closing Cycle: Execute the full month‑end close cycle, preparing a timely and accurate Supply Chain P&L view for review prior to GL close.
• Hedging & Commodities: Prepare the monthly Hedging in Purchase Currency Summary and maintain the commodities tracking sheet to calculate gain/loss and monitor market fluctuations.
• Deck Preparation: Prepare and update Management Decks and the Power BI Dashboard for Month‑end Close and rolling forecasts.
• Commitment Tracking: Prepare and update monthly volume commitments for factories, including calculation of penalties and rebates.
• Risks and Ops: Assist in preparing Risk and Ops assessment
• Other COGS: Prepare and forecast Other COGS charges for YTD and BOY.

2. Master Data

• Overall AMS Visibility: Manage full AMS Volume, Sales, and COGS (Product and Freight) data—including commercial markets and commodities—to ensure overall supply chain visibility.
• Finance Master Data: Drive the transformation and maintenance of Finance Master Data (Vendors, Warehouses, Standard Price, Carriers, Regions) for the AMS finance team.
• Product Detail Integrity: Maintain Product SKU data integrity, ensuring accurate attributes for pack type, flavors, count, pack size, and SKU type for analysis use.
• Other Data: Support the creation and maintenance of master data for Packaging Materials (Pack Mat), Raw Materials (Raw Mat), Bills of Materials (BOM), COGS End‑to‑End and Ocean Freight data.
• Pricing Alignment: Support the maintenance of the SAP Pricing Data summary, ensuring SAP FOB pricing data and Optimity NP file accurately reflects Factory Price.

3. Power BI & Systems

• Reporting Integrity: Ensure the accuracy and monthly maintenance of existing Power BI Dashboards for stakeholders.
• Development: Support the creation of new Finance BI Dashboards to drive continuous improvement in reporting.
• Process Improvement: Assist in integrating current COGS and Volume processes with new system implementations and data warehouses.

4. Complete any ad‑hoc projects and tasks as assigned.

Qualifications and Skills

• Bachelor’s degree in Accountancy or Finance.
• Strong attention to detail and accuracy.
• Willingness to learn and with a “can do” attitude.
• Excellent analytical and problem‑solving skills.
• Possess strong skills in MS Excel (Pivot tables, V-lookups, X-lookups, Power Query).
• Experience with SAP, Power BI and TM1 is an advantage.
• Excellent communication and interpersonal skills.
• Ability to work independently in a fast‑paced environment and as part of a team.

Experience

• Minimum 2 to 4 years of relevant working experience in Finance or Accounting roles.