Senior/financial Reporting Analyst

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