I. JOB DESCRPTION: 

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.

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

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

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

• Consolidate figures by inputting data and running forecast models
• Support in calculating selling prices for OEM and in-house products (if any), and support in periodic OEM pricing updates.
• Support in identifying business operation issues and proposing improvement solutions
• Provide analyses and propose solutions to improve capital and asset utilization efficiency
• Support data collection and calculations for evaluating equipment investment efficiency

• Suggest data-handling enhancements to improve efficiency in daily tasks.
•  Perform other related tasks as assigned by the line manager

II. JOB REQUIREMENTS:

• 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’ regulations