Financial Planning And Analysis Executive

1. Data Processing & Consolidation:

• Extract, clean, and standardize data from Bravo, internal Excel files, and other sources.
• Develop and run SQL queries (basic to intermediate) to process and consolidate data.
• Monitor actual monthly expenses, including Selling Expenses, GA Expenses, Manufacturing Costs, and Material Costs, track and record variances against Budget and Forecast.
• Execute cost allocation processes in Bravo based on management accounting principles.
• Analyze actual revenue, expenses, and profit against budget and forecast.

2. Prepare standard management reports (P&L by channel, brand, SKU) covering budget, forecast, and actual performance.

• Prepare P&L reports by distributor/customer, if any

3. Support departments a in budgeting and budget management.

• Coordinate with departments to collect, validate, and complete data in line with budget templates, following up on any missing or inconsistent inputs.
• Consolidate figures by inputting data and running budget models

4. Coordinate with departments to collect, validate, and complete data in line with forecast templates.

• Consolidate figures by inputting data and running forecast models

5. Support in calculating selling prices for OEM and in-house products (if any), and support in periodic OEM pricing updates.

6. Support in identifying business operation issues and proposing improvement solutions

7. Provide analyses and propose solutions to improve capital and asset utilization efficiency

8. Support data collection and calculations for evaluating equipment investment efficiency

9. Participate and contribute ideas in process or system improvement projects when implemented.

• Suggest data-handling enhancements to improve efficiency in daily tasks.

10. Perform other related tasks as assigned by the line manager

• University graduate or higher in Finance or Accounting
• At least 2 years of professional experience in management accounting, Business Intelligence, or Data Analysis.
• Solid knowledge of basic and advanced accounting and financial principles and practices.
• Excellent knowledge of data analysis, budgeting, and forecasting.
• Working knowledge of Microsoft Office, SQL, Power BI and financial software.
• A problem-solver with attention to detail.
• Good communication skills.
• English reading and writing skills sufficient for financial and technical documents.
• Experience in manufacturing, especially FMCG
• Working time: 8:am to 5pm Monday to Friday, WFH as company’s regulations