Financial Modeling & Excel Optimization (40%):
Review, audit, and simplify large, complex Excel financial models featuring multiple linked tabs and macros.
Streamline workbook architecture to eliminate manual work steps, improve model performance, and reduce calculation errors.
Build and maintain robust financial models, scenarios, and ad-hoc data analysis to support strategic decision-making.
BAU & Peak Budget Support (30%):
Support the annual budgeting, forecasting, and financial planning process across business units.
Assist with month-end financial reviews, variance analysis (Actuals vs. Budget), and routine BAU management reporting.
Process Documentation & Projects (30%):
Document key financial workflows, standard operating procedures (SOPs), and data lineage for ongoing finance transformation initiatives.
Identify operational bottlenecks and recommend process improvements to ensure long-term data integrity and efficiency.
Key Requirements
Experience: 1-3 years of experience in financial analysis, budgeting, forecasting, or management reporting.
Advanced Excel Mastery (Must-Have): Expert-level proficiency in Excel (complex formulas, index/match, nested logic, linked workbooks, and working knowledge/debugging of VBA/Macros).
Process Improvement Mindset: Proven track record of auditing "heavy/fragile" Excel files and simplifying them into automated, user-friendly structures.
Financial Acumen: Solid understanding of financial statements, budgeting frameworks, and corporate financial principles.
Documentation & Analytical Skills: Strong capability to map out complex financial processes clearly and synthesize large datasets into actionable insights.
Language: Professional fluency in English (written and spoken); Cantonese or Mandarin is an advantage.
