Senior/Financial Reporting Analyst

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

Job summary

An established industry player is looking for a Financial Reporting Analyst to enhance their financial operations. This role involves preparing month-end reports, managing budgeting and forecasting processes, and leveraging automation tools to deliver high-quality insights. The ideal candidate will possess strong analytical skills, a keen attention to detail, and a proactive approach to problem-solving. You'll work in a dynamic environment, collaborating with various teams to drive efficiency and improve reporting capabilities. This is a fantastic opportunity for a finance professional eager to make a significant impact in a global organization.

Qualifications

• 3-5 years of experience in finance month-end reporting functions.
• Strong skills in MS Excel, particularly Pivot tables and V-Lookups.

Responsibilities

• Prepare month-end close process and P&L for review.
• Develop and maintain automated Power BI dashboards for real-time insights.

Skills

Financial Reporting

Variance Analysis

Budgeting

Forecasting

Power BI

SAP

MS Excel

Education

Degree in Accountancy

Degree in Finance

Tools

Power Query

TM1

SQL Database

Job description

As a Vita Coco Financial Reporting Analyst, this role provides support in month-end reporting for Global Supply Chain and APAC, as well as the annual budget and forecasting processes, driving value through in-depth analysis reports for stakeholders. To help and drive process improvement and efficiency projects for the region and support in formulating key performance indicators, you will be a financial expert with a high level of ownership and pro-activity in delivering on-time and accurate results within strict deadlines. The responsibilities and required experience will be commensurate with the Analyst or Senior Analyst level.

1. Month-end Finance Reporting

• Preparation of month-end close process, including the timely and accurate preparation of P&L for review. Running of Draft Month-end P&Ls from SAP for interim update & review until GL close date. (Detailed Excel Profit Centre P&L, APAC Markets P&L, PL P&L, SC P&L, Executive Summary P&L updates)
• Manage the Trade and Marketing Accruals, Royalty fee calculations
• Perform various variance analysis, price mix impact and reconciliation of key accounts (Sales, Volume, Ocean Freight and others) for review
• Ocean Freight - Reconcile Interco Sales and match freight invoices received status, 512010 account reconciliation, PPV recharges to Markets, PIT Ocean Freight Rates based on Invoice received and Container Log
• Prepare insightful financial reports and analysis to stakeholders - Month end, Quarter and Full Year Forecast Presentation Deck

2. Budgeting and Forecasting Processes

• FYFC Interco Sales and Freight Volume Data reconciliation (Actual + Container Log + Production) for FY Assessment
• Ocean Freight Full Year Assessment - Rates per route, FYFC Model and Summary for review
• Monthly Full Year Forecast P&L Assessment for all entities in AMS - Preparation template, Upload Template, Analysis
• Monitor actual performance against budget and forecast, providing variance analysis
• Complete TM1 Forecast and Budget Load for all Entities
• Assist in the preparation of Budget working file and Presentation Deck for management

3. Master Data

• Contribute to the transformation and maintenance of Finance Master Data for Vendors, Nodes, std price, carriers etc for AMS finance team usage
• Maintain Master Data for Ocean Freight - One source for all
• Assist in the transformation and maintenance of other master data such as COGS,OPEX

4. Power BI and Automation

• Leverage automation tools to maximize productivity and deliver high-quality data insights through reports, analysis, and impactful presentations (Power Query, OLAP, Power Pivot, TM1, Power Automate, SQL database)
• Develop and maintain interactive fully automated Power BI dashboards that provide real-time financial insights by establishing automated connections to Vita Coco's SQL database warehouses. Manage audience segmentation for Power BI Access
• To explore further utilization of new SAP reports, other systems (Gocomet and Anaplan) to further enhance reporting capabilities

5. SAP Product Pricing Maintenance

• Standard Cost, Intercompany Price and 3rd Party Selling Price inputs and validation for approval

Role requirements:

• A recognized degree in Accountancy or Finance with a successful track record in finance month-end reporting functions, at least 3 – 5 years of experience in finance in MNCs
• Attention to accuracy and detail required
• Ability to think outside of the box and utilize available resources
• Ability to work independently in a fast-paced and rapidly changing environment
• Possess effective communication with a “can do” attitude
• Strong people skills
• Power Query & Power BI skill a strong preference
• Possess strong skills in MS Excel (Pivot tables, V-Lookups)
• Experience with SAP and TM1 is an advantage