Financial Analyst

1. Perform Monthly management pack
- Prepare consolidation P&L report: by plants and by client at consoliate level
- Prepare full report package for shareholder
- Prepare output/production report to measure each Production plant's performance
- Prepare cost center report to evaluate budget utilization for all departments.
- Consolidate & manage monthly Closing schedule to have materials for Board of Management (BoM), Board of Director (BoD) review.
- Validate input data for above reports to ensure integrity & consistency and crosscheck results with other sources.
- Analysis: prepare insight supplement analysis for all above main reports and get to know more about the root causes of variance between actual figures and benchmark (standard, budget, forecast...)
- Review monthly performance with each plant/business head.
- Support Treasury at weekly cash flow report forecast, bank condition measurement
- Other ad-hoc report assigned by team lead, Finance Director or CFO
2. Manage and develop BI tools (especially in Power BI) for management reports and analysis.
- Update and check Power BI model of main reports (2-3 main models)
- Develop BI report to analysis or adopt management 's request (Production KPI)
- Provide basic trainning and support to PowerBI users.
3. Support in budget and forecast management report (annually & quaterly)
- Forecast Overhead cost: bottom-up data, self-estimation...
- Forecast Direct labor cost and update PowerBI DL Efficiency report
- Prepare draft Budget/Forecast P&L.